I am trying to install reporting services on XP Pro with SP2. The XP Pro machine is running SQL Server 2000 with SP3A, IIS 5.1, and Visual Studio ..Net 2003. I can install the client tools sucessfully, but I get an unexpected error when installing the report server. The error code is 2561...more >>

Hello, I have a subreport embeded into the main report. When the subreport contains more data than it can be displayed on the same page, it breaks to the next page leaving the previous one almost empty. Does anybody know a solution for keeping subreport data on the same page as much as poss...more >>

After I installed .NET Framework sp1, my report server was broke. I got the following error. I did not remember I backup the symmetric key when I installed the report server. How do I deal with the isse and get my report server work. The report server cannot decrypt the symmetric key used ...more >>

The export link on the HTML toolbar continues to be disabled after I select an export format. This seems to happen everytime a report is launched from our application - it does this in a new browser window. I don't see this behavior if I view a report from the report manager (on the same cl...more >>

Hello, I have the report with a lot of data, but I want them in one long list without any page breaks. On preview pane they are always rendered on many pages. I tried with page height property but I cannot set it as big as I need. What should I set to get one-page report? Is it possible at ...more >>

Created a DSN use notessql. Created a datasource and a report in VS .net. The report can be previewed but can't be displayed on the reportserver. The error read like below: An error has occurred during report processing. (rsProcessingAborted) Get Online Help Cannot create a connection to data...more >>

Every so often I find reporting services logs (C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles) in excess of 33 mb. For example there are 135 log files from today with the name similar to ReportServerService__05_19_2005_09_11_25.log and are all between 33 and 34 mb i...more >>

I have the same error as Ricky when I tried to run my report on the browser. The following is the error. Help would be greatly appreciated. An error has occurred during report processing. (rsProcessingAborted) Get Online Help Cannot create a connection to data source 'ClientReg'. (rsErrorO...more >>

The fact table might store values like 1-may 200 2-may 400 3-may 500 4-may 600 The user will provide 2 dates and the result they expect is cumulative. For example, for a date range 2-may to 4-may, they expect to see 2-may 600 3-may 1100 4-may 1700 thank you -- Message posted v...more >>

Hi, I want the page header and footer to be displayed only in the first page and not in the following pages... Thanks in Advance,...more >>

When creating a subscription, SRS creates very cryptic SQLAgent job names. This can make it very difficult for our dba to maintain them on the server. There's no easy way to identify which job belongs to which subscription. Changing the name while at the server won't work, because when you edi...more >>

Hi All, Wats the maximun size for the parameters in SQl?? I have a string parameter and if a paa about 130 characters... Its getting truncated ... Any help please.. Thanks,...more >>

I've got a group row that I have set to be a different background color. I would like for the background color to span all the cells in the row (like colspan in HTML). How do I do this? I'm assuming I "merge" the cells, but I'll be darned if I can find ANY information on how to do it. Th...more >>

If I create a stored procedure named [dbo].[report.sales.detail] I can call this just fine from query analyzer but it does work from the Data tab. I get a ‘an error occurred while retrieving the parameters in the query. Cold not find server ‘report’ in sysservers. Execute sp_a...more >>

Hi all, I want to do a aspx page who host the report inside of a frame. I need get the rdl definition from the server thru of the application. Can I get the rdl thru web services? I don't want to do the report manager. Thanks Manuel Jorge ...more >>

I'm trying to create a subscription, but I keep getting an error message stating "Subscription cannot be created because the credentials used to run the report are not stored, the report is using user-defined parameter values, or if a linked report, the link in no longer valid." I can run t...more >>

Hi, No matter how many times I push the god damn "Apply" button in the report manager (parameters section) it never Applies my changes. The page doesn't even refresh. Im getting quite frustrated with this problem and I can't seem to find an hint on what could possibly be causing it. T...more >>

I have a user I have given permission to folder and reports as a Content Manager, but when the user clicks on the security tab for a folder or report they get an error of: The permissions granted to user 'DOMAIN\USER_ID' are insufficient for performing this operation. (rsAccessDenied) I am ...more >>

I am building my dev box. I installed SQL Server 2000. I installed SQL Server 2000 SP4. I installed SQL Reporting Services Developer Edition. Installed SRS SP2 (this seemed to hang, and ran very slowly on my P4 3GHz box with 2GB of RAM). When I try to launch Report Manager, I get this error: ...more >>

Can I install RS 2003 on a machine that does not have SQL on it. ...more >>

Hi, my customer is running a Sql Server 2000 Standard. I would like to develop a new ASP.NET application with Reporting Services using the "Go Live" of VS 2005 Beta 2. On my development pc I have a VS 2003, Sql Server 2000 Dev + Reporting Services SP1. Now I have installed VS 2005 Beta 2 wi...more >>

Hi. I’m trying to create File Share Data-Driven Subscription. Everything work right, but when I set User and Password to the position “Get the value from database” some problems begin: the subscription stops working immediately, it doesn’t even try to generate report. Can anybody...more >>

I have tried to export a Reporting Services report with 60,000 rows in it (not more than Excel 65k limit!) to Excel but an "Internal Server Error" was returned. When I checked the web servers event log it stated that ASPNET_WP.EXE had terminated the process because it had consumed more than ...more >>