Hi, I have a main report which has some 10 tables/subreports i want hide some tables/subreports based on some condition in custom code. for this i have written a function in that the code below: If Parameters!langid.value="Chinese" then table2.visibility=hidden end if Will the above c...more >>

Hi, I have a table which displays the list of employees in my company. I am trying to display the picture of the employee alongside with the information. Is this possible in Reporting Services? The pictures will be stored in a folder and the name of the picture correspond to the name of the...more >>

Hi All, I am trying to compare two dates: actual shipping date > promise shipping date. If the sctual shipping date is greater that the promised shipping date than count that order number if not than it is null. This is in the report designer in the "edit expression" =Count(iif(Fields!...more >>

I have data that is stored by individual dates and I count to get a total of how many units are produced on a single date. I need to get weekly and monthly totals instead of daily and group the data by week and month to display in a report. I also need to keep a rolling history of 5 weeks of ...more >>

We have an instance of SQLRS on a virtual server under W2003. Recently we had cause to reset the sever due to a dramatic slowdown in response times. Upon checking we found the CPU usage was constantly around 95 to 100%. Stopping the RS and SQL services made no difference and it was only resolv...more >>

This is a new install. I access http://localhost/reports/, enter my username and password, and http://localhost/Reports/Pages/Folder.aspx give the following error message. The request failed with HTTP status 400: Bad Request. Any ideas? Thank you. ...more >>

Hi, Is it possible to grant role assignment to report server local groups in SSRS 2000? if so, how? I can't do it. Thanks Alex ...more >>

I am posting this in hopes of saving others from my fate of searching hours... days...months for a resolution to an error when rendering to excel. I have a detailed report of tables and graphs that accepts multiple parameters. For certain parameter values the report would not render to excel.....more >>

I have a dropdown parameter in my report (Sites) with the ID field as a integer and the display field as a string. How can I display the selected 'display' field on the report? I can display the ID (int) ok with = Parameters!SiteID.Value But how can I get the actual selected dropdown text? C...more >>

I have the values in percent but I want the % sign to be on the axis labels. SQL Reporing Services 2005...more >>

On a RS Server what is the recommendation for files that I need to backup besides the db? Thanks, ...more >>

Hi, I'm trying to have a report exported in a certain format, then accessed wherever it is saved. Can I do this by having a program open the url and command silently? I'm afraid that it will be difficult since the file will want to be opened or saved. Any thoughts?...more >>

I've seen some threads on this issue, but no clear resolution. Here is my procedure declare: PROCEDURE get_releases ( p_CNUMBER IN VARCHAR2, p_HIDDENSTATE IN NUMBER, p_COMPLIANCE IN NUMBER, p_OBSOLETE IN NUMBER, p_CORE IN NUMBER, p_REL_CUR O...more >>

Our IIS server hosts several websites in addition to Reporting Services. The server was knocked out by a hot fix and after several days it has been brought back online. Now it has been handed over to me to get Reporting Services running again. I am not sure what has been done to the server,...more >>

I need to re-poen this issue and would like to get immediate attention on this. Please see history below. "DragonVic" wrote: > I need to know if you've had other cases like this, and just tell me how to > fix it for Windows XP Professional, everytime I query data in the data > window and...more >>

Is it possible to have a data driven subscription that delivers the report to a file share with a dynamic name? My report has a supvervisors name parameter and I need to have the report delivered to a share with the supervisors name and then the report name....like.... JSmith_TestReprt.xls, ...more >>

What is required in order to schedule a report for email delivery? I have modified the RSReportServer.config file on SQL Server and created a subscription for a report. I can setup the subscription but it never runs. Is there another step that I have left out? ...more >>

I have an application that I have migrated to a new machine with VS 2005. The application uses the web service to access Reporting Services on another machine (running SQL 2000). When I run the app from within VS 2005 it runs, accesses RS, does its business. When I run the app outside VS on th...more >>

I posted this last week, and no one answered :-( If at first you don't succeed... ************************************************************ I am trying to use the following expression to establish the default value for a parameter: ="SELECT DefLib FROM Users WHERE (UserName = SUBSTRING('...more >>

Is there a way to remove the print button from the reporting services toolbar? I have installed sp2 and when users try to print they are prompted to download a file so that they can print. The problem is that our uses don't have permissions to do those kinds of downloads. I was hoping tha...more >>

Trying to render a report that has three groups two expand and collapse and have charts. The first attempts to render were successful but all later ones fail. And excel produces the following message: Microsoft Office Excel File Repair Log Errors were detected in file 'C:\Documents and Set...more >>

I am getting this error when trying to deploy a report. As far as I can see permissions /Authentication is all ok A connection could not be made to the report server http://Servername/ReportServer Anybody have any ideas of where to start looking? ...more >>

Hi, In Report Properties - Code Tab- i have written custom code, i want to get the report parameter value in custom code, so i have written as follows: ie assigning to a variable. strValue=Parameters!UserID.Value Is this code is correct to get the parameter value in custom code or i ne...more >>