SSRS - Reporting parameters - Need help on passing one

• Tamrak

  SSC Eights!

  Points: 902

  More actions

  March 12, 2014 at 2:43 pm

  #286705

  I am using SSRS - 2008, Release 2

  I inserted the photo for your review.

  

  What I try to do:

  1. The first parameter, option, has three (3) values; Airport, Bus Station and Shipyard.

  2. The second parameter, airport, comes from the datasets query that generate information regarding the airports. I had a dataset built, called Prompt_AirportCode

  3. When a user select the 1st parameter with the option of 'Airport', it will activate the 2nd parameter. However, if the user selects something else, this parameter will be blanked or disabled or do not show any value.

  I tried to write the Datasets query, Prompt_AirportCode, that can loop to the 1st parameter, but it was unsuccessful.

  Does anyone have suggestions of how I can do this?

  I think I can do something at the Dataset Properties, such as at the Filters. There are expression that can generate but I have not used them that much.

  All suggestions are welcome. Thanks.

• sql Sarah

  SSCrazy

  Points: 2081

  More actions

  March 13, 2014 at 10:00 am

  #1696858

  What is the code behind the Airport dataset?

  It should be something like:

  Select Airport_Code, Airport_Name

  from Airport

  where @Option = 'Airport'

  See if that works.

  Sarah