Menu
I have 7 parameters (3 multi select of string, 1 DateTime, 3 string values) in my SSRS 2008 report, and I have set all the parameters as null in the default value.
It's working fine in my preview window of Visual Studio 2008. But after deployment to my report server, the "NULL" checkbox for the parameter is not checked, causing the report not to get loaded at initially.
611
You can pass report parameters to a report by including them in a paginated report URL. All query parameters can have corresponding report parameters. Therefore, you pass a query parameter to a report by passing the corresponding report parameter.
In Report Builder or Report Designer in SQL Server Data Tools (SSDT), in the Report Data pane, right-click the Parameters node and click Add Parameter. The Report Parameter Properties dialog box opens. In Name, type the name of the parameter or accept the default name.
By Uploading RDL file in Report Server. Open SSRS Server from webportal URL. There, you will see the upload button. Click the upload option and browse the rdl file of the report from the location. It uploads your report to the report server.
This is "by design":
When you first deploy reports, parameters are uploaded with all their settings.
Administrators of those reports are then allowed to tweak the way report parameters function in the report web manager: change whether they accept null values, defaults, etc.
If you redeploy reports later, nothing is changed to existing parameters (the system doesn't want to "overwerite" changes made by report admins).
Solutions:
135
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
