March 24, 2011 at 10:05 pm
Hello all,
i am new to reporting services.
i have a requirement where i need to display the report based on filter condition below.
i need to display the report for the particular region for the corresponding country and state.
when i select the particular region the countries corresponding to those regions only need to displayed as drill down rather then displaying all the countries.
so how to give the dependency between these report parameters.
i have drop down has region-country-state.
March 25, 2011 at 10:00 am
You have a dataset for Region. Build another dataset for country with a
WHERE Region = @Region (where @Region is the value selected in your parameter)
or
WHERE Region IN (@Region) if @Region is a multi select parameter
Return the Country from this query to a Parameter for @Country so the user can select it.
Put a WHERE Country = @Country ( or IN (@Country)) in your main dataset query
March 28, 2011 at 2:47 am
great!
it helped me thank you .....
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply