March 12, 2014 at 2:43 pm
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.
March 13, 2014 at 10:00 am
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply