reporting services - Is it possible to use SSRS data set name as a parameter? -

is there way use data set name parameter ?

thank you

create text data type parameter, in report parameter properties window, go available values tab , select specify values radio button.

add label , value per dataset, create dataset , use parameter conditionally run query based on selected dataset.

for example:

if @datasetselection = 'report1' select * table --select statement report1 else   begin     if @datasetselection = 'report2'       select * table --select statement report2     else       if @datasetselection = 'report3'         select * table --select statement report3       else         if @datasetselection = 'report4'           select * table --select statement report4   end    

also mentioned wei_dba in comments can wrap logic in sp , pass ssrs parameter value sp.