I have the following filter expression on a dataset. Under the Filter tab on the dataset Expression: =iif(CStr(Parameters!Bill_ID.Value) <> "All", CStr(Fields!Bill_ID.Value) = CStr(Parameters!Bill_ID.Value),True) Operator: = Value: True My report parameter Bill_ID is String dataty...more >>

As I understand it, once you snapshot a report, any changes to the RDL of the report will not affect the snapshot. Let's say (using a purely hypothetical situation ;-) that I misspelled the text of a column header. Has anyone looked into messing with the stuff in the ChunkData table to go chan...more >>

Hi, How do i set the startDate and EndDate parameters in the subscription page to the previous date? The default for this is the last 30 days but some users want to have it send to them everyday and the report collects data the previous day: StartDate = 2/3/2005 12:00:00 AM and EndDate = 2...more >>

Hi, I've got a simple bar chart that I'm having difficulty with. I am displaying data point labels on the bar chart. There are 5 different bars on this particular chart, and the first four display the labels correctly, but the fifth bar doesn't show a label - it doesn't matter what I do. ...more >>

I have a report that includes a group that I have hidden. the group becomes visible using a toggle on a textbox in the group header. I would like to place a column heading in the header row for the group detail. I want this header to only appear when the detail is visible. I can use the visib...more >>

Is there a place where I can put custom code so that all reports in a solution can access the same code? I now copy the code into every new report I create ...more >>

Hi I'm having problems manually activating the report server after installation on Windows 2000 server sp4 , SQL Server 2000 sp3 and Reporting Services sp1. I have followed other fixes I have seen but still get the same error "The Report Server Web service has not generated a publi...more >>

SQL Server 2000, SP3. Reporting Services SP1, Office 2003 - Excel SP1 (11.6355.6360). Had a report that summarizes payments by type across a date range. Deployed to RM, set up parameters and subscriptions, checked rendering, trial export to Excel, opened workbook in Excel 2003 - ALL OK. C...more >>

Hello, We have a number of different reports (all separate RDLs). We want to allow the users to select one or more reports to generate. Basically, we want the user to select a number of different reports into a report group, and then generate the entire group of reports. First question: is ...more >>

Is there any other then "Data Extension process" way to manipulate a Dataset ? Is it a good idea to edit dataset from SQL server using "Data Extension process" ? Thanks, Josh...more >>

I am trying to format a database field to a Year format and check the results against a Year value (the 2002 would become a paramater entered by the user). Then if the results are true, then format the database field to display month year. Below is the iif statement: =iif(format(Fields!CR...more >>

I have written a custom assembly which is utilized by a report. I have referenced the assembly in the designer and copied the dll over to both the correct designer and server rs folders. The assembly is strongly named and I have added the public key to the code group for my dll. The assembly i...more >>

Hi, I am very new to reporting services.And i did't work on any reporting tool b4 this. (1): Now my problem is how can i hide subreports and datasource in ReportServer browser? (2): I am sending http://myservername/Reportserver to all the end users. is it correct way or is there ...more >>

Hi all, We have just published a collection of reports for external customers who we have given restrictive user permissions on the report server. When openeing up the home page, the correct folders are visible to the relevant customers. However, when they try to run the reports it gives th...more >>

A report has embedded images in it. They display fine in ReportDesigner. However, they do not display after being deployed to the ReportServer when viewed in ReportManager. They do display if the report is exported to pdf format. However, the requirement is simply to display the report in ...more >>

Hello, I have a matrix for Turnover that looks like this: Rows: Department Columns: Status Data: Count of employees It runs beautifully to look like this: Department Active Terminated ________________________________ Cleaners 6 2 Maintenance 5 ...more >>

Hi, I want to hide/show some text in a textbox based on a condition. It works fine , but the problem is when the text is hidden it also hides the borders (top, left, right, bottom) with it. Is there a way to hide only text and not the borders. Thankyou. ...more >>

Hello, I am trying to color negative detail lines with the following. =iif((Fields!Amt1.Value-Fields!Amt2.Value)<=0,"Red","Black")} It is working if the value is not zero. Some 0.00 values are black but some of them are red. It happens in both detail and group rows. what might the problem be?...more >>

Hello All, Is there any way that I can know what is the username used for the reportserver connection. I am aware that it is stored in the rsReportserver.config but there it is in encrypted form. Any suggestions will be appreciated. Cheers, siaj...more >>

Hello, I am using report viewer component embedded to my asp.net application. My problem is: when users set 800 by 600 screen area in their desktop, because of the size of reportviewer component, the scroll bars on the report viewer component goes beyond the screen size and users have to deal...more >>