problem with multi value input parameter

• rajn.knit07

  Right there with Babe

  Points: 714

  More actions

  April 2, 2012 at 3:14 am

  #391920

  Hi,

  I have two multi value parameter Country and States. I have created dataset for these two and state dataset result depend upon the selection of country values.At initial run the selection of parameters work fine. When I select some country it shows the state accordingly. But again when I select all countries, the state input parameter shows all states but the checkbox against the state name are not selected. Only few check box are selected in state which I have selected in previous parameter selections.

  Is theer any solution for this to select all by default.

  In parameter section of Report data in default value I have selected the dataset for the corresponding parameter and its value.

  I am using ssrs 2008.

  Thanks

  Rajneesh

• Koen Verbeeck

  SSC Guru

  Points: 259165

  More actions

  April 2, 2012 at 5:12 am

  #1467567

  What is the source? SQL Server, Analysis Services?

  Can you show us both queries?

  Maybe try a Reporting Services forum, this one is actually for Integration Services.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP