CODEWITHSUNDEEP
sql-serverreporting-servicesssrs-2008
CodeNinja
CodeNinja

Reputation: 3278

How to set your own ssrs default parameter

I am using a SSRS Parameter for my reports.

The parameter is populated by a Dataset - sql query. 

select ProductName from  Product

I set these values using the 'Available Values' option

I want to set the Default Values as "Select"

When I select the No Default Value , the output message I see is is * select a value"

But my requirement is to see only "Select"

I dont see any other properties that I can set . is it possible to set your own default parameter ?

Upvotes: 0

Views: 13227

Answers (1)

StevenWhite
StevenWhite

Reputation: 6024

The Available values determine what will be in the drop-down list. If you want "Select" to be in the list you will have to union that with your product names in the dataset query. The Default Values determine what is selected before you touch it. So your settings should look like this:

enter image description here

enter image description here

Upvotes: 1

Related Questions