Hi All, In my report, i've 3 groups and i want to hide a group footer by comparing a textbox value in group1 and a textbox value in group2, for eg., i've Sum(Fields!Amount.Value,"table1_group1") in one of group1 footer's textbox and Sum(Fields!Amount.Value,"table1_group2") in one of group2 fo...more >>

I'm calling an RS report from a web browser control embedded in a VB6 app. I want to render the report directly to a PDF file, then email that file out. Is there a way to craft a URL that will tell Reporting Services to just render the report to PDF using a filename I pass without displayi...more >>

I wish to create a scatterplot in which the data points are connected by a line. My recordset is as follows and contains up to 20 records. (there is an input parameter which limits the dataset to a small # of records.) ID, X, Y1, Y2 I want the graph to plot the following pairs (X,Y1) and...more >>

I am building a matrix report that has fiscal quarters as the column group. I have multiple data columns within the group. I am trying to allow the report user to choose which data is displayed by using a parameter. I am able to hide the columns of data that are not selected but the fiscal qua...more >>

Hi all, Is there way in reporting service programming to give the sql select query for a report during runtime. Thanks rsuser...more >>

I have a problem where have a report that uses a shared datasource that references a SQL Server. My dataset called a stored procedure that builds a sql string and passes in the string to an openquery() command that queries a DB2 database that is a linked server on that same SQL Server. The r...more >>

We are having a problem with a report that is scheduled to be emailed only works sometimes. Other time it fails with a "Reporting Services Failure sending mail: Cannot access a closed file" error message. The report is running off a snapshot that is generated every half hour and a subscription...more >>

I installed the report server on the web server, and the report server database is hosted using a remote SQL server instance. Everything used to work. A few days ago, I got the following error message in the System log of the web server: Source: Service Control Manager. The ReportServer servic...more >>

Hi, I have the report which is run in the morning and shows all records submitted during the previous day. I have created the email subscription to send that report to users. Is there any way to input the date (only the date) the records were submitted on in title/subject of that email? ...more >>

I've noticed that SP:s that are more complex than just a simple SELECT-statement don't work correctly when creating new datasets. The dataset can't seem to populate the Fields when the SP does some additional work before the SELECT. I know it's possible to create all the Fields manually, but...more >>

I am connected to an oracle database and wish to allow the users enter a ProdID, normally in SQL the criteria in the dataset would be =@ProdID and this would be passed onto the report. In oracle it sees this as a text and encloses parameter in quotes '=@ProdID' Is it possible to use this e...more >>

Hi, One of my reports (all others are fine) generates an exception when exporting to excel: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help Exception of type Microsoft.ReportingServices.ReportRender...more >>

Hi, is it possible to toggle the visibillity of a char data item? Because if the value is zero or null i dont want the column in the chart to be displayed. Thanks alot Florian...more >>

Hi, I'm looking to set up a method for producing PDF outputs from a website I'm working on (ASP.NET/C#). The requirement is that the user will be able to either view a standard "printer friendly" page of result data or generate a PDF document containing several pages worth of data. The data...more >>

I have the following problem. The system setup is as follows. IIS and sqlserver are on the same server and I'm using windows integrated security. I initially created a windows login user (userA). I then in the reporting services(RS) admin area, set the security permissions for a direct...more >>

Hi! I'm just curious if anyone has thought of any workaround for the 256 column limitation of Excel. In some of the reports I've done for Excel with the Excel API and interop, I create new worksheets when columns exceed 256. Am kind of hoping for a "page-break" feature or something in that...more >>

Hi All, I use a dataset from storedprocedure with 2 parameters: GetItemsList (@ItemCount as int , @CategoryId as int) In the dataset I write : exec GetItemsList In the dataset parameter I connect the repotr parameter to the storedprocedure parmeters. If I set default value to the storedpro...more >>