I was trying to export to excel one of the reports from Report Manager when I encountered this error: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help Exception of type Microsoft.ReportingServices.ReportRend...more >>

I am looking for some resources on how to use reporting services to design a form. I have a paper form (with a lot of lines) that I have to recreate in reporting services. I then have to make it fillable from my application. Making it fillable from the application is the easy part. I am conce...more >>

I developed a web application and all reports were created using reporting services. What do I need to install or configure in client machine to run the reports?...more >>

Hi I've got a custom assembly which performs validation on parameters prior to submitting the query to the database. My dataset which retrieves the report data is in Text format and calls an appropriate validation method on free-text parameters, such as dates and numbers. When validation pass...more >>

Hi, Is there a way to render an Excel report having links to another Excel report, all in the same workbook ?? In other words, I need to make a report that could be viewed offline (when I put links in mi report, the links point to the report server..). Is there a way to this?? TIA, Gast...more >>

I have a report with 5 parameters. Each parameter has a default value. Using ASP.NET/C#, how can I programmatically update each parameter's default value? ...more >>

Hello, I am trying to be an early adapter to SRS for Microsoft CRM reporting. In particular, I am trying to get the activities that a lead has associated with it. I am using a subreport and am trying to pass the lead GUID to the subreport so I can run the activity report for the lead. I g...more >>

how can I output the contents or my report server to an xml file? I assume I would use some variation of ListChildren and the WriteXml method. ...more >>

I find that cascading parameters work intermittently. In addition, a report with a drop down list will sometimes attempt to execute before the user has made a selection. ...more >>

I'm working on Course 2944: Updating Your Reporting Skills to Microsoft® SQL Server™ 2005 Reporting Services When I attempt to do the lab "Designing a Report", I get this message. Any idea WHY it's not available or what I can do to fix the problem and get to the lab? -- Thanks, M...more >>

I know that this has to be possible, but my google searches have not been effective...so here goes I have create a report that runs a stored procedure that accepts parameters beginDate, endDate and LocationID and returns a dataset with LocationID, totalPeople, peopleMeetingCriteria, PCT and sh...more >>

Hi All, I'm attempting to use an indexed view from within a stored procedure that's called by RS. However, to use the Indexed View, ARITHABORT must be set to ON for the session. Within RS as a whole, within a shared datasource, or within a specific RS report, how do I do this? I need to ...more >>

I have a development box running XP pro with SQL 2005 and RS. The VS 2005 version that it comes with SQL in order to develop reports works and the connection to the local SQL server works. I can pull data from an external SQL DB and return the values into my VS report and I can view the data...more >>

Does anyone know of projects in development to create RDL files from HTML and/or PDF files? I have to think that if Microsoft has created a render from RDL to PDF that the reverse would be fairly simple to complete as well....more >>

Hi in my task manager i notice that ReportingServic process has been building up in memory consumption. Is this supposed to happen?...more >>

We currently have SERVER A which is just IIS for VS2002 applications(and some file shares). And SERVER B that has SQL 2000-Enterprise Edition. I would like to use RS 2000 and Analysis server/BI? Can I have all 3(db, rs, as) running on one box? If so, what are the requirements? But doesn't...more >>

I've got a report that works fine in development (and in production too until recently) but no longer loads in production. When I click "View Report", it just reloads the page as it is, without generating a report. I've tried deleting and reloading it clean into production, but with the ...more >>

Hi, I've got a report that allows a user to drill through to another report. I set this up by editing the properties of the Textfield that contains the data, and under the Navigation tab I set the "Hyperlink action" to "Jump to Report", where I specify the name of the second report. This w...more >>

i have set up a report package that unfortunately uses an MDB as the datasource (it will be upsized to SQL server soon); however, when any user attempts to view/generate the reports they get the following error: Reporting Services Error An error has occurred during report processing. (rsPro...more >>

Hi, I will explain the scenario and the way i am doing it. Pls suggest me on how to continue. I have a ReportA with a table with 100 rows. I have a textbox that says Filter which has a navigation to another Report, ReportB. Now this Report is like a filter report - Where all the field name...more >>

Hi all, sorry if this is in another post - I did a few searches and found nothing. We have a custom asp .net ui and are rendering our reports directly to pdf. We are running sql server stored procedures to populate our reports. What I have noticed, however, during the course of testing t...more >>

I am trying to run reporting services on a SBS 2003 Premium server and have been runninng into a lot of issues. I have installed the SQL Reporting Services Components on the server and the Visual Studio .Net components on my workstation. The goal behind installing the components in the spe...more >>

I'm running a long report from Reporting Services web site. When I run the stored procedure by itself, it executes with no problem, taking about 3 hours to complete. When I execute the report itself, it runs for exactly 60 minutes and after that I get "The page can not be displayed" message. ...more >>

How can i set reports to start on page number 2 or 3? ...more >>

Hi I have a report from which i wish to open another report in a javascript sized window. The problem is that the field i am passing can have a + sign which is not being passed in the URL. My code is as follows: ="javascript:void(window.open(' " & Globals!ReportServerUrl + "?" + Globals!Re...more >>

Hi, We have multiple reports created in the SRS 2005. What is the best approach to directly exporting (rendering) the created reports in Excel without using any report viewer control or report manager for exporting on click of the button. Thanx in advance....more >>

Hi, I'm trying to access the webservice from an ASP.NET page. For every request, I get "HTTP status 401: Unauthorized" error. I'm using integrated security for ASP.NET and the ReportServer. Both are local. I have set: "rs.Credentials = System.Net.CredentialCache.DefaultCredentials;" ...more >>