Multi Parameter

• JC-310972

  Grasshopper

  Points: 10

  More actions

  March 16, 2006 at 7:38 am

  #112386

  I want to  use a dropdown parameter to actually populate another dropdown parameter ? As in department dropdown parameter populates the division dropdown parameter. Is it possible to do this in SQL Reporting Services 2000 ?

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  March 16, 2006 at 8:12 am

  #627030

  Sure, but you'll have to put the relationships into a table, or inside of a stored procedure so you can use the query value.

  This tutorial does it, but its example is in RS2005,

  http://msdn2.microsoft.com/en-us/library/ms166931.aspx

  But I think (Fingers crossed) it works in RS 2000

• moe_mayne

  SSCommitted

  Points: 1933

  More actions

  March 16, 2006 at 2:56 pm

  #627168

  SQL Reporting Services 2005 only supports Multi Parameter querys ....

  
  Moe C

• Dave Klug

  SSCertifiable

  Points: 5811

  More actions

  March 17, 2006 at 3:56 am

  #627230

  Yes, what you're trying to do is know as a cascading parameter.  Check the following...

  http://msdn2.microsoft.com/en-US/library/ms155917.aspx.