Hi, I have a report with startdate as a string report parameter formatted MM/dd/yyyy. It works fine on the computer with regional setting to English (United Stated) where its date formatted as MM/dd/yyyy. However, the report parameter changes to dd/MM/yyyy on another computer with regional ...more >>

In my report project, I used many subreport in my master report. Each subreport was put in a rectangle area so that I could setup PageBreakAtEnd or PageBreakAtStart. In the meantime I also need to set the Hidden property which is based on the parameters or conditional expression for showing/hidd...more >>

I'd like to setup variables (just like you would in a web.config file in a normal .net application). I then need to access the value of the variable and use it in various parts of the report. How is this done? As a specific example: I have a column on my report and I want it to be a hyperlink,...more >>

Hi, I am trying to format a column of varchar which has decimal values..Since it is varchar I was not able to format it directlyu, so had to mulitply and divide each value by 100 and then apply formatting..Not all the rows of the table have data, some are blank..and these show up as "#Error" ...more >>

I have a report that contains a report jump that calls another report, which contains several report parameters. When deployed on the report server, even though the parameters are enabled on the "jumped to" report, these can not be seen. Any ideas as to how to fix this? Thanks, Nigel...more >>

I'm trying to build a somewhat complex report and to do it requires a number of queries. Can anyone help me figure out how to run multiple queries in a single report? Do I need to break it out into sub reports to do it? If so, how can I pass a parameter to a sub report during "runtime". Th...more >>

I have what I thought was a pretty simple report, but have encountered two issues. I have three groups in this report. 1. When using sum on my detail row I am getting what appears to be a running total in one of the columns. When I don't use sum then I get either the first or last value...more >>

I've got a report of peoples' SSN's and Names. The SSN is stored as a string (nvarchar(9)). I need to display the SSN in the common way: ###-##-####; IOW, with hyphens. In my report, the expression to display the data looks like: =Fields!SSN.Value When I try to format it like this... ...more >>

Hi, I'm installing the eval copy on Windows 2003 Enterprise with latest SP and fixes. The reporting services install goes well. I can even hit the https://myserver//reportserver url. However, I get the following: a.. The report server installation is not initialized. Check the documentat...more >>

I am trying to connect my reporting services server to a DB2 server - What drivers / info do i need to accomplish this. I cant seem to figure out how to get this to work. Any help would be appreciated....more >>

I'm trying to generate two reports from one reporting services URL, so I created a "master report" that simploy contains two sub-reports. When I run it in the preview browser, one subreport runs, and not the 2nd. In the RS Manager, both subreports say nothing but "Error: Subreport could not...more >>

We have a couple of dropdown boxes and a text field as parameters to a report. The options in the second dropdown box depends on the selection of the first one, so I'm happy with the fact that a post back occurs when the selected option in dropdown box 1 is changed. However the value enter...more >>

I found this: "Microsoft also announced reporting enhancements for that product, including the release of SQL Server 2000 Reporting Services Service Pack 2 (SP2) " on http://www.sswug.org/see/22358 If it is really released, where we can get it? I have checked MSDN, it is not there. V...more >>

Hi all, I want to simulate the "Render this report from an execution snapshot" and "Create a snapshot of the report when the apply button is selected" functionality from as .rss file. Any ideas? Thanks. Q...more >>

We have a bunch of reports that take a parameter from outside the normal reporting services parameter window. I understand that for security reason we cannot pass that parameter on the querystring unless a reportparameter is defined. I therefore had to display a drop down box with all the p...more >>