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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics