SSRS Reports

Refresh Reporting Services to view newly added sproc fields

How do I refresh reporting services fields after I have added new fields to my stored procedure? The new felds do not show up in Report Data window. I have tried rebuild and refresh. Neither sem to work. I am using SSRS 2008 Software/Hardware used: SSRS 2008

Exporting SSRS Report in Simple Excel sheet(not formatted)

Hi All, when I export and ssrs report in excel, it gets exported in excel but in a fancy format. I want to export the data in a simple excel sheet format so that I could apply filters or formulaes. If any one of you are aware of this do let me know please. Avhilash.

Pagination in SSRS 2005 Reports

I have several reports in SSRS 2005 that consist of a "report header" area with various textboxes (note this is in the body of the report, not a page header) and then a table -- sometimes a very long table (and then a "report footer" area with some more textboxes, and also a bona fide page footer...

Rename Sheet when report exported to excel

hi, When i export SSRS report to excel, each new page comes with new sheet. The sheet names are default names (sheet1, sheet2.. sheetn). Is there a way to rename these sheet names while exporting. Thanks in Advance, Rachitha.

ReportServerService restarting after app domain cant unload

SQL Server Reporting Services (MSSQLSERVER) service terminated unexpectedly. We are rs2005 Version 9.00.3239.00. What is causing this error to happen when in the ReportServerService_Main log there are 11 attempts to unload the app domain from 14:16:18 to 14:19:04 and then this error => e ERROR:...

SSRS Memory Performance

Microsoft SQL Server Reporting Services Version 9.00.3239.00 We are experiencing problems with memory and other performance related issues. This is a scaled out deployment with ssrs installed on 2 server web farm (used to be 3) with windows 2003 sp2, 32GB RAM. Customers run 100s of subscriptions...

Connection issue from analysis to reporting

I have a report pulling the data from analysis services and reporting in SSRS reports. when i try to render the report I can view the report in the local server.when I try to access the same link remotely, I am unable to access the data and I am getting the below error. An error has occurred during...