Can we Cascade parameters in SSRS vertically?

• santhu_smily

  Say Hey Kid

  Points: 696

  More actions

  November 3, 2008 at 8:07 am

  #383286

  Hi,

  I have to create report in which i have to cascade 2 parameters based on parent parameter.

  Ex 1: (for selection of parameters)

  Country1: State1: City1:

  Country2: State2: City2:

  As the SSRS will allow only two parameters in one online to choose at 'View Report' page, my selection appears as:

  Ex 2:

  Country1: State1:

  City1: Country2:

  State2: City2:

  So,

  I tried the arrangement of parameters in this fashion

  Ex 3:

  Country1: Country2:

  State1: State2:

  City1: City2:

  But to my surprise, SSRS is allowing the parameters to choose only in "Horizontal fashion" ,not vertically i.e., i have to choose Country1 and State1 and then City1 vertically.

  But it is allowing me to select in this order: Country1,Country2,State1,State2,City1,City2.

  Is there any need to change in config files to get my requirement(Ex1 or Ex3) or any workaround for this?

  Please help me in this regard...

  Thanks in advance,

  santhu.

• mRainey

  Right there with Babe

  Points: 796

  More actions

  December 23, 2008 at 1:15 pm

  #917060

  This may lead you to a potential solution:

  http://www.eggheadcafe.com/software/aspnet/29369563/hack-to-prevent-report-fr.aspx

  The article is a pure hack on how to stop a report from running automatically, but one of the comments mentions it was used to reorganize parameters.

  Hope this helps!

  Enjoy!

  Michael R.