I'm trying to configure a report to sort when a Field(colunm) header is clicked. I have know idea how to do this. Any help appreciated. Thanks, Jim ...more >>

We have an application that gets a report's parameters and parameter values. We're using SQL Server 2005. The problem is that we need a couple of the report's parameters to be non-prompting AND not read-only. In our application, we dynamically build the UI based on the parameters and paramete...more >>

I am new to SQL2005, have been using & supporting SQL2000 for years w/o Reporting Services. I'm trying to learn the RS2005 on my laptop and keep getting an error when in VS2005 I try to create a shared data connection for a report. I can set the properties of the connection, but when I test t...more >>

Hi, Is it possible to copy reports and data source definitions, roles and subscriptions from one SSRS server to another? Currently we have an installation of SQL Server 2000 Reporting services with many reports in it. I have setup a new server with SSRS 2005 and would like to move all SSRS...more >>

hello - We are looking for a 3rd party tool for dashboarding, gauges and Key Performance Indicators (KPIs). We are already using SSRS 2005 for reporting purposes. Is MS's Business Scorecard Manager (http://office.microsoft.com/en-us/FX012225041033.aspx) anyway related to SSRS 2005? Is...more >>

Hi, I created a report which works just fine. But when I try to export to excel, i get the following error: Reporting Services Erro -------------------------------------------------------------------------------- Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderin...more >>

Hello, I took over a report that someone else created. The data comes from an sp that takes 4 args. If I run the sp from the data window, I get the dialog box that askes for all 4 parms, prm1, prm2, begin date, end date. If I go to the preview window of the same report, the textboxes for...more >>

I'm getting the following error: An error has occurred during report processing. Cannot create a connection to data source 'MyReports-ReportServer-PHX'. Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. This is only for data sources that use inte...more >>

Is there any possibility to loop through all the parameters of the parameters collection in the custom code of a report? I tried using a "For Each" loop, but aparently that doesn't work. The goal is to be able to use the parameter name - value pairs, independently of the number of parameters i...more >>

When you view the report in Report Manager it shows that it is Page 1 of 1 but when I export it to PDF it actually has 437 pages. Which is fine....no probs there but would like to know the reason that it says Page 1 of 1 rather than the 437. Any help would be greatly appreacited on this, a...more >>

Have a report written in SQL2005 that has 12 parameters, 3 of which are date pickers. The client is complaining that once clicking on the link for the report that it takes nearly 10 seconds to open the parameter page up. Does anybody else have any probs with this sort of thing or does anybod...more >>

I have been waiting for a MS Word extension since the launch of the first SQL Reporting Services. What is it going to take for Microsoft to actually implement this? Are there any plans to add an extension to export reports in Word? For that matter, are there any plans to add an extension t...more >>

I installed custom security the same way I did on SRS 2000. I've been running srs2000 for a little over a year with custom security. I used the 2005 Custom Security project and installed it on a dev box. Everything seems to work (i get login screen when i try to access report manager) but ...more >>

I will be grateful to anyone who can tell me where to find a clear, comprehensive explanation of what features of Reporting Services are available in which edition(s) of Reporting Services. I'm using Reporting Services 2005. After much searching/experimenting, I now know 2 things: --A "scal...more >>

Hi, I've got a custom assembly used in Rptsvcs that calls a web service on the local host. When run in Report Designer, it works as planned, but when run in Report Server, it doesn't call the web service. I have a HelloWorld-method in the custom assembly that works, so the assembly is working...more >>

Can anyone tell me what the error code means when trying to print an AutoRefresh report from Report Manager using the ActiveX print control? Many thanks, James Snape ...more >>

I have a report where I'm suppressing detailed records that meet certain criteria. The records are also being grouped by one of the fields within the dataset. If no detailed records are displayed, I would like to suppress the group record. However, I currently get a group header record on the ...more >>

Hi, I have a problem with Reporting services pie chart legend which is limited in character Does it exists a solution to write more text on pie charts legend ? Thx ! ...more >>

Reporting Services 2005 seems to have a problem with DateTime parameters. One report has default datetime parameters. It uses the navigation feature to call a second report, with the same parameters passed to the second report. In the designer this works fine but when deployed the second repo...more >>

I uninstall the complete SQL Server 2005, and then when I reinstall it, Reporting Services don't want to install because a previous installed instance is detected. ...more >>

With a few printers (lexmark), PDF documents exported from reporting services doesn't print on both-sides when I select "two-sides print option". It alwyas print on Odd pages. But when I print PDF documents who are not generated by Reporting Services (any PDF from any sources), they print on od...more >>