paramter in ssrs
I have paramter named "Handset".I want that by default report should display top 5 handset but at same time i want to have option to "select different " handet or any handset
in my parameter which are not top 5 handset.How i can set default top 5 and select * or different handset in my paramter values?.do i need to create seperate dataset for top 5 and select * handset or i can use same dataset for the both condition for this handset
paramter?.
Thanks
July 12th, 2012 3:16pm
Hi,
Yes, you need to create the second dataset for selectinf 5 values and need to use that dataset for setting defaults.- Chintak (My Blog)
Free Windows Admin Tool Kit Click here and download it now
July 12th, 2012 3:22pm
You will have 2 datasets in this case. In the first data set (say, DS1), you can have something like:
Select Handsets From Table1.
Then, in your 2nd dataset(say DS2), you can have something like:
Select TOP 5 Handsets From Table 2.
Now, navigate to your parameter (say, p1). Go to its available values, then "Get values from a query", then in Dataset, you'll have DS1 and have the value and label.
Then, in the default values of your parameter, you'll "Get values from a query" and select your "DS2" as dataset and the expressions as value and label field.
July 12th, 2012 3:35pm
You will have 2 datasets in this case. In the first data set (say, DS1), you can have something like:
Select Handsets From Table1.
Then, in your 2nd dataset(say DS2), you can have something like:
Select TOP 5 Handsets From Table 2.
Now, navigate to your parameter (say, p1). Go to its available values, then "Get values from a query", then in Dataset, you'll have DS1 and have the value and label.
Then, in the default values of your parameter, you'll "Get values from a query" and select your "DS2" as dataset and the expressions as value and label field.
Guys, a minor correction: the first query should have distinct
Handsets from Table1. Rest everything is cool.
Thanks, Khilit
http://www.bigator.com
Free Windows Admin Tool Kit Click here and download it now
July 13th, 2012 11:49am