Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Issue re-deploying updated default parameters in SSRS report

I have an SSRS (SQL Server 2008 R2) report with several parameters. I'm having an issue where one of the parameters is not consistently choosing its default value when the report is first loaded.

Specifically, it works fine in BIDS but works intermittently (works on one server but not another) once deployed to IIS and viewed in IE. By intermittently, I mean it works on the server I deploy it to, but when I copy the RDS file to another server, the default behaviour for my parameter is broken.

Details

The parameter has a series of specified (constant) integer values specified in the Available Values section, which represent a selection of fixed reporting periods. The Default Values has a single specified value, which matches one of the Available Values.

Options: data type integer, no null values, no multiple values, parameter visible, automatically determine when to refresh.

Any ideas why I'm seeing this behaviour?

like image 348
Mark Micallef Avatar asked Sep 23 '11 04:09

Mark Micallef


People also ask

What are the different modes of deployment for SSRS?

A Reporting Services report server runs in one of two deployment modes; Native mode or SharePoint mode.

How do I select all by default in multi value parameter SSRS?

Right click on Size report parameter and click on Parameter Properties, it will open the Report Parameter Properties window. Click on the Default Values tab and make the below changes. To set "Select All" as the default value, I have made similar changes for both report parameters. Let's preview the report.

How do you pass one parameter value to another parameter in SSRS?

To set available values for the second parameter In the Report Data pane, in the Parameters folder, right-click the first parameter, and then click Parameter Properties. In Name, verify that the name of the parameter is correct. Click Available Values. Click Get values from a query.


1 Answers

That is true, once the report is deployed to the server then the parameters are controlled at the server level.
Once item to note however is if you redeploy the report with changes to the default values THEY WILL NOT be changed on the server!!! The report must be deleted and deployed for the new defaults to take effect.
If you do not wish to delete the report then change the defaults by hand on the Report Server.

like image 195
DiningPhilanderer Avatar answered Sep 23 '22 16:09

DiningPhilanderer