Reports

RS2005 front-end disaster-how to assoc ReportServer db to new fron
Search phrases: encyrption key symmetric keys Scale-out deployment... not supported Sql Server 2005 Standard Edition Reporting Services 2005 The report server installation is not initialized. (rsReportServerNotActivated) (rsRPCError) Reporting Services Configuration Manager ==================== Question: ... 28 Dec 2005 17:28

Counting Rows
I have a simple report, listing patient names, and then columns depending on certain condition. If they have the condition the column is True, and if they don't the column is false. The problem I have is trying to count how many have each condition. I inserted the following expression in the footer: =Coun... 29 Dec 2005 10:04

Drillthrough Event for Remote Reports
I have a Report Server 2005 installation in which I am using the ReportViewer control to view the report. It is a drill through report and I am trying to capture the drillthrough event to set session variables. But the event doesn't fire ?? My code looks like :- protected void Page_Load(object sender, Event... 23 Dec 2005 17:33

RS2005 Web ReportViewer: Unable to set parameters and ReportServerCredentials
Hey guys, I'm using the report viewer web control in my web application. I got it somewhat working but now I'm stuck: 1) I can't set the parameters for the report. When I call SetParameters and pass a ReportParameter array, it complains that this report doesn't have parameter 'XYZ'. But in reality it does. ... 22 Dec 2005 17:46

OLEDB - parameters
Hi. I'm new in OLEBD and I have some problems when I'm creating query for report. The way to uses parameters in query is with '?' instead of '@'. So, for each '?' symbol in the query the Report Designer creates one parameter. But, what's happening if I need to use the same parameter in the Query? I don't need that... 22 Dec 2005 14:07

Matrix - Totals
What does the following error mean? [rsNonAggregateInMatrixCell] The Value expression for the textbox ?textbox2? references a field outside an aggregate function. Value expressions in matrix cells should be aggregates, to allow for subtotaling. Build complete -- 0 errors, 1 warnings ... 21 Dec 2005 07:51

Unable to connect to remote server
I have deployed The Adventureworks Sample Reports to Reporting Services, and attempted to open the reports. Any report that I open, I receive the message: Unable to connect to the remote server. The attempted operation is not supported for the type of object referenced This message occurs with any report, in... 17 Dec 2005 19:05

Report Server connecting to another SQL Server
Our report server works if connecting to databases in the same SQL Server instance. However, if I try to connect to a database of another SQL Server, it does not work. The authentication fails. We are using our custom data extension and use web service to connect. Do you know what else we can do? We know t... 3 Jan 2006 22:51

Changing Report's Datasource
I have one report that I want to have the ability to use different stored procedures...depending on the the user's criteria they want to see. Is there an RS method that I can use to change the stored procedure that a report is using at runtime, or is there a better way to do what I want to do? ... 14 Dec 2005 18:01

Dynamic connection to the Database
Hi, I want to connect to several databases, is it possible to pass the connection string as a parameter and change connection to the database dynamically ? Thanks. ... 15 Dec 2005 05:22