Hello, My team has been having a very annoying problem where Visual Studio always deploys the reports in a project even when you turn Deploy off in the Configuration Manager. The ideal solution for us is to be able to run the the reports locally using RSReportHost (not a local report serve...more >>

Hello All, I have designed some Reports in RS, now i want to install it on Production Machine (Web Server) but issue is that, production machine doesnt have RS. Can it be possible to make any setup or package which install required dll's to production machine without installing RS? Please hel...more >>

Hi, I have a problem with viewing already deployed Report through Reports Manager. I am able to see the list of reports in Reports Manager but when I click on any report, I'm getting "Directory Listing Denied" error message.I am using SQL Server Reporting Services 2000, on IIS6. Any ideas? ...more >>

My Report shows fine on pop-up preview window yet gives error when viewed in report server I believe that the pop-up window simulates the report server , my report is fine in th epop up window, yet it breaks in the report server, my config files are all the same, i made sure they are all al...more >>

We have a web application that supports muliple companies (around 500). All tables in our SQL Server database have a CompanyId field. We want to use SSRS Report Builder to let end users create Ad Hoc reports. We need to build a Model/Data View that allows an end user to veiw data from the...more >>

Hi, I'm editing some reports at the moment, and they've been set up using start and end date parameters both having datetime datatype. They both have a default value as the user would like them to run immediately, the problem is they are both set to Date.Now() so no information is coming...more >>

I want to state the issue as clearly as possible: we have SQL 2000 on a Windows 2000 Server we have a Windows Web Server 2003 on a separate server Then we have the Client so we have this three tier set up... We have Installed RS 2000 separately on the Web Server tier because we don't wa...more >>

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 w...more >>

I have a report whose columns will be hidden at runtime and the final width of the table during runtime will be less than 10.5. However initially at design time my table width is more than 10.5 and hence my report page width is also more than 10.5. Thus when I export the page to pdf format in...more >>

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?...more >>

Hi, I'm using the method SetDataSourceContents to change connectionstring property from my asp.net application and work properly. But when I run a report that uses this datasoruce I get the follow error: An error has occurred during report processing. (rsProcessingAborted) Get Online Help Ca...more >>

After upgrading our reporting services from standard to enterprise (to take advantage of data-driven subscriptions) I can't seem to get the button to show up. I have gotten the automatic drill through to work with a report model (this ensures me that it is now enterprise). I've also backed ...more >>

Does RS2005 provide the ability to create reusable components? By component I mean the ability to create graphs or textboxes that are tied to certain expressions or sql queries and stored for reuse. This would allow an enduser to simply select the component to put on the report without knowi...more >>

Hello, I had the September CTP installed. I uninstalled this and installed the RTM of SQLServer 2005 When I did this, the existing RS databases evidently remained from the first installation, as I got a message saying that these were the wrong version (altho I can't remember just when I sa...more >>

If my understanding is correct, Oracle is not yet supported as a data source for report models in SSRS 2005 (and thus not available for report builder). Is there a timeframe estimate to when this might be available?...more >>

Consider the following report with Employee Sales: Employee Sales Robert David Mary 100 John 200 Alex 150 Total David ...more >>

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....more >>

Hi, I have a date field in a dataset that is bringing back UK formatted dates (dd/MM/yyyy) from a UK configured SQL Server on a UK configured server. In RS the preview displays these dates, again as UK - everything is fine so far... My problem is when I run the report the dates are output in...more >>

How do you configure SRS to use SSL after you've installed it?...more >>

Hello all I made some reports at my machine. Now i installed Sql Server Reporting Services on other machine which is production machine. I want to make an installable or setup or any package to install created reports. Can anyone help me how to do this? I gone through Publish sample reports...more >>

Hi all, I have created a report with the report wizard. I used a cube as a datasource. After creating I also run the report without any problems. However when I go to the data tab to edit my dataset. The dataset becomes empty and my reports is getting errors like "Report item expressions c...more >>

I have a web service which consists of a web method that reads an XML file and returns it as a dataset. [WebMethod] public DataSet ReadXMLFile() { DataSet dsXML = new DataSet(); dsXML.ReadXml("C:\\TestXML.xml"); return dsXML; } The XML File that I am read...more >>