Hallo, I've tried several times installing RS on a particular machine. The installation finishes without error messages and without installing the RS components. During RS installation on a member server (Win2003, SQL2000 Std SP3a, RS 2000 Std) i dont get the usual Server Components choices...more >>

Hi all, Anyone reading this please do not take offense but I have posted a couple of questions here with less-than-satisfactory results (in fact, no results). Could anyone please direct me to a forum/web site or sites or any other place where I might post questions relating to Reporting Se...more >>

I'm still fairly new to Reporting Services, and i have been tasked with recreating a report that i believe was originally created with Python. I know i can do it in ASP.Net, but i would rather use Reporting Services. I know i can figure out most items, but the one issue that i'm having is gett...more >>

We are trying to control the access an individual user has to a report, for example: 1) Bob has access to the customer report; 2) Judy has access to all the reports; and 3) James has access only to the vendor report. In order to accomplish this we are trying to use 'Integrated Security' c...more >>

Hello! During my holiday the report manager stopped working and it is not possible to access the reports using http://reportserver/reports. All automatic distribution of reports have also stopped. As always, nobody has done anything on the web server except adding a new website. All report...more >>

Can we have an ADO.NET dataset as a datasource to a MS SQL Reporting service report ? If so, how do we configure the report to do so ? Regards, Chak. ...more >>

Hello, I have a application that stores most of the data that need to be analized in Xml, in a text collum. I would like to know if there is a way that the reporting service consume this datasource to create the reports. I have the intention to migrate to SQL 2005 and put all the...more >>

Hi, I'm working on many reports that are generated using SQL Server Reporting Services SP 1 from an ASP.NET 1.1 web application. One of the things the users would like to do is have the report automatically generate a PDF when they click on the View Report button after entering the parameters...more >>

My data warehousing team uses Informatica for ETL (loading data), Autosys (Computer Associates product) for scheduling the jobs, and Microsoft Reporting Services (RS) to report on the data. The first two pieces are directly related, and RS is the new kid on the block. I need to integrate all t...more >>

All, Why does chr(13) +chr(10) create a new line feed in Visual Studio, but does not when you render using IE with the HTML viewer? Any ideas?? Jim ...more >>

I have one stored procedure which has 3 select statements inside it. So this stored procedure returns 3 recordsets. I need to print all of these 3 recordsets onto the report. Are there any way to print these 3 recordsets onto this report without splitting this stored procedure into 3 store...more >>

I am trying to bind the data view off of a view that is a monster, I dont want to make it an indexed view, is there anyway I can bind to this view without a primary key? When I try to currently it gives a primary key required error. Can I schema bind my view or something? It is a SQL Server...more >>

I have a sales table( id, date , techid, amount) id date techid amount ----------------------------------------- 1 01/01/2005 tsmith 99.99 .... 1054 08/16/2005 jborrow 29.99 I need to create historical report&graph with monthly totals...more >>

Hi Folks Importing Access reports that have grouping are really quite a struggle. All of the grouping sections are imported as controlled by report parameters. Am I missing something, this is incredibly painfull with all of the build errors in VS.NET? Rob...more >>

Out of the blue today, with no changes on the server that I'm aware of, I'm getting this message when I try to access the report manager.... The underlying connection was closed: The remote name could not be resolved. I can access https://localhost/reportserver and get the FTP style listing ...more >>

Is it possible to report out an html string into the rich format? --> I use an html control (RichTextBox 2.5) that allows the user to create the main body of a quote in a wysiwyg environment, and that formatting is successfully saved as an html string to the SQL db and successfully displayed ...more >>

a CSV unicode file does not look good in Microsoft Excel (while maintaining it's delimiters). I want to keep the file as a real CSV, but have it open in Excel. If I save a unicode CSV as ANSI (notepad/wordpad) then it still looks OK to other programs, and looks good in Excel. I'm doing a ...more >>

This is the error from the logfile. Any idea anyone? w3wp!webserver!1228!08/16/2005-15:27:04:: e ERROR: Internal error: System.MissingMethodException: Method not found: Int32 Microsoft.ReportingServices.Library.Global.get_ResponseBufferSizeBytes(). at Microsoft.ReportingServices.WebServ...more >>

Hi I have created a basic report. Now I am looking for options to send in some parameters to the report as in a url to call from a web application, which can be applied on the query. Also rendering in pdf format. Any help would be appreciable. Thanks! Sandy ...more >>

Hello everyone! I have major performance problems with reports that I have deployed in Reporting Services. I have an Sql database with millions of rows, and I have created a cube in Analysis Services that is run against a view in the database. My reports get data from the cube and the d...more >>

Hi, I keeps getting the error "The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content and then restart the service." every two or three days. I don't ...more >>