I am writing an ASP.NET app that uses a SQL Server 2005 with SSRS setup. I want to use the ReportViewer control but I get an error when using ReportViewer 10 because it needs SSRS 2008. How can I ...

I am using SQL Server Reporting Services 2005 - I have created a portrait A4 report 8.5in by 11in. The report consists of a header, body and a footer. The body consists of a number of textboxes...

I have a report in SSRS and one of the parameters I use is Cities. The user can select from a list of cities to pull the report for that location, or multiple locations. My datset is simply a selec...

We have a 2005 report that can be 2 to around 250 pages with the average being in the ballpark of 10. When the report was developed, our developer was told that 10 pages or so was the right number,...

I am getting the following exception when calling the LoadReport() method of the ReportExecutionService2005 web service provided by SSRS 2005; System.Web.Services.Protocols.SoapException: Server d...

I need to pass a value as a parameter from ASP.Net application to SSRS Report.How can i do this?Can anybody help me ? Thanks in advance.

I have one report that does not export to excel friendly from SSRS 2005. I know I can use <Render> <Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.Exc...

Is it possible to have SSRS's Report Manager display a report name that is not the .RDL file name? I.E. I have a Report .RDL named "MyReportAboutSomeImportantStuff.RDL" but I want the Report Manag...

We've recently upgraded one of our SSRS2005 servers to SSRS2008 and have found that all of our applications that utilized the reporting services web service for producing reports no longer works. ...

I've the following expression in my report. =FormatNumber(MAX(Fields!Reading.Value, "CellReading_Reading"),3) Now when the dataset is empty 'Fields!Reading.Value' becomes empty and finding their...

I'm attempting to add a web reference to my ASP.Net 3.0 project. This is a reference to the SQL Server Reporting Services web service. I have verified the service is up and running, but when I try ...

I am fairly new to using SSRS and I would like to create a report that automatically prints to a specified printer when the report is generated. I found this question on SO and it mentions writing...

I am using SQL Server Reporting Services 2005, and I'm developing a report in Report Designer/Business Intelligence Studio. Right now I have a normal-looking table that displays data like this: --...

In my development environment, every time I reboot windows (which must be done at least daily for me), all of my Shared SSRS Datasources lose their credentials. Currently I have them set up to log...

The problem that I have is SQL Server Reporting Services does not like Sum(First()) notation. It will only allow either Sum() or First(). The Context I am creating a reconciliation report. ie. wha...

I have html in an MS SQL DB. I would like to render the html on a SSRS page, is this possible?

Reading MSDN (and other sources) about custom report items (CRI) for reporting services 2005. It looks like I'm limited to generating a bitmap. Not even with some mapping overlay for detecting mous...

I have some reports in SQL Server Reporting Services 2005 that I need to keep audit logs for. The audit log should include who ran what report with what parameters. I can't use Windows authenticati...

I have a report in SSRS 2005 that's based on a query that's similar to this one: SELECT * FROM MyTable (NOLOCK) WHERE col1 = 'ABC' AND col2 LIKE '%XYZ%' I need to be able to dynamically includ...