CODEWITHSUNDEEP
reporting-servicesvisual-studio-2017rdlcrdlssrs-2017
oula alshiekh
oula alshiekh

Reputation: 893

making specific value as default in a parameter ssrs(rdl)

iam using visual studio 2017 and make an rdl report

and i have a parameter (drop down)that takes it's values from the query

select column1 from table1

suppose that there are five elements A,B,C,D,E in column1 of table1

how to set first value which appears form available values to be selected as default in order to not obligate the user to select a value

i mean i don't want to see the phrase instead i want first value to be selected

Upvotes: 0

Views: 1768

Answers (1)

niktrs
niktrs

Reputation: 10066

For single select values this is the default behaviour.

For multi select you can create another dataset using TOP and set it as the dataset for the parameter default values 

select TOP(1) column1 from table1

enter image description here

Upvotes: 1

Related Questions