I've checked the Multi-value in a Report Parameter. When running the report if I check more than one value in the parameter dropdown I get the following error: An error has occurred during report processing. (rsProcessingAborted) Query execution failed for data set 'ActivityDetail'. (...more >>

Hi, When installing Reporting Services 2005 I receive the following error. 'SQL Server setup failed to retrieve the SSL Certificate Name' I installed the SSL certificate using IIS Resources SelfSSL with the following cmd 'selfssl.exe /N:CN=[ComputerName] /T /V:365 Reporting Services 20...more >>

If I have two installations of reporting services, is there a way to copy the entire set of reports, security, connection settings, and other metadata from one server to another? Is there a command line tool to do this?...more >>

Does anyone have any examples on how to use the security filters in report builder models. Do you setup a standard filter. How do you pass the user back to the server in the query? Thanks ...more >>

Please forgive what I'm sure is a novice question but I've only been playing around with Reporting Svcs for a few days. I have a report that's rendered from a stored procedure (no prob there - works quite nicely). One of the grouping variables, Type, has values such as "SS_F", "SS_P" and the ...more >>

I captured this mdx statement issued by Report Builder in SQL Profiler to figure out why it was returning more than one year: (SELECT { ( Extract( filter( { [Accounting Date].[MDY Date].Levels(1).Members * { [Accounting Date].[Date].[Calendar] } }, ( ( [Accounting Date].[MDY Date].Curren...more >>

Actually, I've tried RowNumber(Nothing), RowNumber(), and RowNumber("CallDetail") (where CallDetail is a dataset), and it blows up. This is a calculated field. Doesn't actually matter if I put the field on the report or not, as long as it appears in the list of fields, it blows up. By "blow...more >>

I'm a newbie to reporting services. Is it possible to copy a report to more than one folder in the Report Manager? We have a staging area where all of our reports are being deployed. They are then moved to specific folders for various clients. Some clients will use the same report, so it will ...more >>

I have 2 instances of reportingservices 2005. Trying to use the one ReportingServer with Forms Authentication like this server.Url = @"http://web2/reportserver2/reportservice2005.asmx"; server.LogonUser(TxtUser.Text,TxtPwd.Text, null); the logon method throws this : System.Web.Services...more >>

We are currently running RS2000. We have a test server that I has RS2000 on it as well. I need to replicate all the reports on our production server to the test server. Without uploading individual reports, what's the recommended way of replicating all these reports? ...more >>

Hello - I am using SSRS 2005 and my report dataset has a parameter of type GUID. In 2000 I could just pass this in as a string. I now get the error: "Failed to convert parameter value from a String to a Guid." I've tried setting my Dataset parameter value as: =Guid(Parameters!<my parameter>...more >>

I have a report I've been running for several months using a URL like the one below: http://server/ReportServer?/folder/report&rs:Command=Render I updated the report today and now I get 2 "Permission Denied" javascript errors when the page loads. One is in function OnLoadToolbar calling ...more >>

ok I've designed a report template that uses cascading paramters based on several sp's. The user selects a value for the first parameter and that value is passed to the sp that populates the second parameter list. The value selected for the second param is used to populate the third param list...more >>

I have a line chart with ammounts both above and below 0, and I would like to make the grid line for 0 be bold, but I can't figure out how to make this happen. I know in the format box for the line thickness I need something like this: =Iif(?????=0, 2pt, 3pt) I just can't think of what I'm comp...more >>

I must do a report using this expression for data set: = "SELECT * FROM Partitario WHERE DATEDIFF(d,DataScadenza, " & Parameters!Data.Value &") > 0" This is a part of the complete query. I have a date as a input parameter. The field named "DataScadenza" belongs to table "Partitario". I have ...more >>

Hi, I'm trying to access a db from the custom code, but it doesn't seem to be possible, because if i try to preview the report i get errors: [BC30002] 'DAO.Recordset' type not defined, and some other similar errors if i try to use SqlConnection ect. Is it a strange behavior of my reporting ser...more >>

Hi, Can someone tell me or give me some reference about this: I have a report and want to by user to show different report content. Such as Administrator can see the column of UserID and UserName, but the general user can't. How do I implement this function, can someone give me some reference...more >>

Hi NG We have a problem to install the MS Reporting Services 2000 on a Windows 2003 Server Web Edition. IIS is propertly installed, runing, and its serves many wepages. During the installation (System prequestites check) of RS comes the following message: "IIS either not installed o...more >>

Hello. We have a number of subscriptions created by myself and so seem to associated to my user as the owner. I recently removed my user from the local admin group and since then the subscriptions did not run. The service itself runs as its own user and all the sql jobs run as that user, so I ...more >>