Take a look at the Execution Log topics in Books Online. All of the informaiton you want is stored in the ReportServer database. There is even a DTS package to extract the data and a set of reports which show you statistics. Brian Welcker Group Program Manager SQL Server Reporting Services ...more >>

Hi everyone, I have SQL server Dev edt. installed on my laptop and my company has SQL server Ent. Edt. on our production server. I recently downloaded the reporting services trail of 120 days from the site of microsoft. Anyway my question is if i install the trail reporting services on bo...more >>

We have completed the Reporting Service's 2005 upgrade (sept ctp) and have been testing some of the reports. We are finding reports that work just find on 2000 (our prod. box) are not working properly in 2005. Is anyone else having any issues? I will try to explain one of the scenarios in wh...more >>

I need to move the database for reporting services from one server to another. I know how to move the database itself. Could someone tell me what needs to be changed to make reporting services use the database on the new server? Thanks. TT ...more >>

In my group footer I build a string based on the number of rows in that group plus the field the group was based on. But if the group was based on a an empty string I get an #error in the textbox. So I wrapped the code with an IIF statement. If the field is empty do nothing otherwise build ...more >>

Have SQL Server 2005 September CTP I am Local admin on box Sysadmin in SQL Server Installed reporting server. I used the BI Development Suite (VS) to build reports. I ran the build with no issues than deployed the reports to the server successfully. I can log in and view the reports fro...more >>

Basically we have implemented custom security so that our logins to the Report Server are using details in a custom database. They are not Windows usernames/passwords. However when we use the web service api (ListSubscriptions) to return user's subscriptions we get nothing? After digging fur...more >>

A question to those who installed and configured Reporting services 2005 successfully and area ble to generate a data model from the cube though a browser { IE}. Can you please let me know what accounts did you use in the setup process and to create a data model from the browser ? I inst...more >>

Hi, I've been looking for some time now and can't find a definitive answer to my problem. I've set up a subscription in RS but it always fails with the error message "Logon failed" in the UI. The log file shows: ReportingServicesService!library!1f58!09/23/2005-07:53:03:: e ERROR:...more >>

There is a bug with RepeatOnNewPage in RS 2000 that makes my reports look really ugly and unprofessional. I have a TableGroup with a Header and Footer. Group is set to PageBreakAtEnd. Header is set to RepeatOnEveryPage. Footer has nothing special. I'm rendering as PDF and have installed a...more >>

Hi, Is it possible to send the DataReader from business object that I created to the a report in reporting server and let the report takes it as the input data and display accordingly? Right now, I have a business object that calls the Render() method using web service API. I was wonderi...more >>

My task is to use the RS Web Service to create subscriptions. We have the June CTP, and this works fine with the original code examples that had been presented with SQLServer 2000. When I try to use the same code with the Sept CTP, I get an error, "rsDeliveryExtensionNotFound". So this makes ...more >>

Hi, I am trying to use asp.net (vb.net). Is it possible to bind the dataset to the reporting services report using vs.net 2003 or does one need vs.2005 and sql reporting services 2005? I would prefer to use vs.net 2003 and sql reporting services 2005. Rgs, Mehuk...more >>

Hi all, If you have a chart and want to relate to different series, that have different scales ie Number of Sales, and Revenue, per Day. Can you have different axis scales so that 'number of sales ' is not scaled down to near invisiblity. I'm Working arround it by having two charts, but t...more >>

Hi! According to msdn http://msdn2.microsoft.com/en-us/library/ms228006 all I need to do to allow SSIS datasource in the report builder is to uncomment an extension line with SSIS name in the rsreportserver.config. But this not works on my VS2005 (i tried on both Beta2 and RC instances)... N...more >>

Hi, I want to use Custom Code to control the Visibility of a Group. I write a test code, it always Return True: Function CanSeen() as Boolean Return True End Function Then I set the initial visibility of a group to Expression =Code.CanSeen() But the the group can't seen!! What is t...more >>