Rather than have the SQL Server hit many times during the day when people look at the report, I was wondering how to run the report once, at night, and save the output as html Then, when users look at the report during the day, they see the static results of the over night run. Faster respon...more >>

I'm having problems getting a dynamic query with a multi-valued parameter. I have a report parameter, defined as multi-value, called deployment_id. I want to have a dynamic query built with it (because I am eventually going to also send in a parameter for the WHERE clause). This works: S...more >>

why am I getting the error "Argument Not Specified For parameter 'TruePart' of 'Public Function IIf(Expression as Boolean, TruePart as Object, FalsePart as Object) as Object' from the following textbox expression in reporting services 2005? =IIF(Sum(Fields!ElapsedRunSeconds.Value)is Nothing...more >>

Hello everyone, Here is what I would like to accomplish: I have a table on my report. For every row in this table, I would like a sub-table, whose data relies on a value in the parent row . . . the only way I can think of to accomplish this is to have a parameter that is reset on every row in...more >>

Hello, Is it possible to overwrite a text control in reporting services, so that I can add two additional properties to it? If possible, do you have any links/point to resources? Thanks /Peter ...more >>

Both the old and new SQL server versions were SQL 2005 (no SP1) with the same @@version info. After backing up and restoring the versions according to the KB article http://support.microsoft.com/kb/842425, I am getting errors trying to work with existing subscriptions (new ones are ok): ...more >>

Hi all, I have a report with a subreport. I also created an aspx page with a reportviewer that displays the report. In the code I pass a parameter to the report. The report is located on the MS CRM server where I created the report for. Now, when I run the page on my localhost it works fine...more >>

I working on a forecast report where I am pulling a date from a table and the client wants to grab the date and subtract 10 days from the date. I tried the expression =date.value-10, but this obviously didn't work....more >>

Is there a way to make the page footer visible only when printing or exporting to pdf files? ...more >>

Hello. I need to have my matrix dynamically create the row group and column group in my matrix, but I need my dynamic columns to show for each row in the matrix group for rows. A B C D E F B B C D E F C B C D E F D B C D E F E B C D E F F B C D E F The horizontal " B C D E F " is the...more >>

for my query in dataset after join few tables, i got following data: ItemNo Area Barcode Total 1 J 12345 15 1 J 2222 15 in report, i use hide duplicate and displayed like: ItemNo Area Barcode...more >>

I'm am trying to produce a report which has a parameter value in its url. as I understand it http://reports.server.local/Reports/Pages/Report.aspx?ItemPath=%2fdrift%2fjob_details&job_name=PAPERLESS should produce the job_details report for the job named "PAPERLESS". but all I get is the exa...more >>

Hello I would like to print all selected labels of a multivalued parameter on a report. If however all values of the multivalued parameter were selected, the selected parameters should not appear on the report. E.g.: [ ] select all [X] User 1 [ ] User 2 [X] User 3 -> Users: User...more >>