"ALL" wildcard in dynamic parameter

[abc567]

Hi,

I want to add "ALL" wildcard in dynamic parameter. So that if user selects a region as "IL" and in next prompt he should see all cities in that region in drop down list and a wildcard "ALL". And when ALL is selected, data of all the cities in that region should be displayed on the report..

 

[lbass]

You are talking about a dynamic cascading parameter. If they want the data for all cities, they should move all cities to the right using >>.

-LB

 

[abc567]

Offcourse i can do that by using >> . But i wanna use 'ALL' as a wildcard character.

Anyways i told them that i am using static prompts.. so they just kept quiet.
And i can use wildcard character with static prompts.