I have sql 2005 installed on my dev machine including SSRS. I found Reporting Services Configuration under SQL 2005/configuration tools. I browsed through that and all seems to be OK. However, I don't see anything under SQL 2005 for Report Manager. In SQL 2K there is a report manager whe...more >>

Could someone please tell me how to bring up the dataset window in Reporting Services so I can drag and drop the fields from the dataset? I've searched high and low in the report designer and cannot find that option anywhere. I am working with Reporting Services 2000. Thank you. ...more >>

Does anyone know how to determine how many times a report is being accessed/viewed each day by looking at the Reporting Services System tables....more >>

Has anyone had success getting a custom data processing extenstion to write to the Event Log? Writing to the log works fine on my machine in the IDE but once deployed to the server it fails. I'm assuming its a security issue but I do not know how to resolve it. Any help is greatly appreci...more >>

(Note: This is a repost of an earlier thread of 8/8/2006 with my "correct" nospam e-mail alias. I was told it was not getting answered because I did not use my proper nospam e-mail alias.) We are in process of converting one of our applications to Application Role security, and the last m...more >>

Is it possible to display three different record values in one grouping header? For instance, I have End of Year values for three different records for a grouping called Burbank. I am grouping by Burbank, but I want to show the Year End value for Burbank in 2005, 2006, and a 2007 projection,...more >>

Hi all! My report is ran from a sproc and I have one parameter called @district. When I preview the report the prompt comes up and lists the district names like I want it to. The user can then pick one or more than 1 districts to view data from. When the report is ran for all districts it wor...more >>

here is the message I got. Is there any way to fix the problem? ============================== The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Get Online...more >>

Is it possible to do something like a horizontal grow for columns? I found this, but wanted to know if there was an easier way. http://blogs.msdn.com/ChrisHays/ Search for "Horizontal Tables" see if that is what your looking for. ...more >>

Hello all, I have a SQL db that stores first & last names in one field (i.e. John Doe). Does anybody know how to get reporting services to show the name as lastname, firstname? Thanks. ...more >>

Anyone know how to fix this error? Error 1 [rsInvalidReportParameterDependency] The report parameter 'district' has a DefaultValue or a ValidValue that depends on the report parameter "district". Forward dependencies are not valid. Thanks! ...more >>

I need some real help with this, please. (SQL/RS v2000, Visual Studio .NET 2003) I am somewhat new to RS...I have two fully-functional reports with email subscriptions that work just fine. I have a GREAT many other reports that I need to migrate to RS, but none of them are working because ...more >>

I have a report that works perfectly in the development enviroment but when I deploy it and run it in the report server I get this message: "An error has occurred during report processing. (rsProcessingAborted) Obtener ayuda en línea Query execution failed for data set 'All_TTs'. (rsErrorEx...more >>

Hi all, I need help using stored procedures in Reporting Services. I have a dataset set to type stored procedure and when I run the sp it doesn't return all the data that it should. When I run it in query analyzer it returns approxiamately 4500 rows, but in RS it only returns around 1000. Is ...more >>

Hello, We are using reporting services for about 6 months now and granting access to windows users works great. I cant seem to get user groups to work however. I am not a expert on windows users/groups so I dont really know what to check. Say for example we have a user group called "Activa...more >>

I have a basic matrix with a title in the top lef corner, a list of locations down the left hand side and one column per day of reporting across the top. My problem is that the title is actually data from another column of my recordset. I am repeating the matrix several times and filtering on...more >>