paramter in ssrs

• weston_086

  SSCommitted

  Points: 1645

  More actions

  July 12, 2012 at 12:17 pm

  #263692

  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

• Conficker

  SSCommitted

  Points: 1507

  More actions

  July 13, 2012 at 4:16 am

  #1512437

  create two different datasets

  1. Top5 handset

  SELECT Top5 Handset

  FROM tblHandSet

  ORDER BY <fieldName>

  2.

  SELECT HandSet

  FROM tblHandSet

  WHERE NOT IN (

  SELECT Top5 Handset

  FROM tblHandSet

  ORDER BY <fieldName>)

  and in yout parameters define values from queried... done