SQL Server 2012 Reporting Services Tips, Tricks, and Troubleshooting

SQL Server 2012 Reporting Services Tips, Tricks, and Troubleshooting

Set a text "Select values" in the parameter list at the start up of a report.


A report with  multiple value parameter and a string "select values" to be kept in the list control at the start up of the  report.
The report will be shown like below.

In Reporting Services, by default, the textbox displays”<Select a Value>” text before selecting values in a single parameter drop-down list. But nothing would be shown in the start up of  multivalue parameter list. This is by design.

To work around this issue, we can specify the Available Values from the batchId field in the following dataset:
select 'select any value' as batchId
union all
select distinct  CAST(batchId AS VARCHAR(1)) from  dbo.Table1  
Then specify the 'select any value' as the Default Values for the multiple parameter. In this way, we should change the values in the drop-down list when we render the report.

Hope this helps.

Sort by: Published Date | Most Recent | Most Useful
  • Richard Mueller edited Revision 14. Comment: Fix heading lines in HTML to improve the TOC

  • Craig Guyer - MSFT edited Revision 15. Comment: removing older references to pre-release version

  • How can i change ssrs report server database to a new one using powershell?

  • I'm not aware of a PowerShell command that enables you to change the report server database.  However, you can use PowerShell to access two WMI classes that are used for administration of Native mode report server instances. One of the class methods (GenerateDatabaseCreationScript Method (WMI MSReportServer_ConfigurationSetting), enables you to generate a SQL Script that can be used to create a report server database.

    Information about using PowerShell to access the classes, is available at msdn.microsoft.com/.../html. Examples are included.

    Information about the above method is available at msdn.microsoft.com/.../ms152823.aspx .

Page 1 of 1 (4 items)