I created 3 drop downs in my report that are dependent on each other through parameters. The variables are Region, District, and Territory.
So if Region is picked it only shows the Districts for that Region. Then I pick a district and it only shows me the territoires for that district.
Works great : except, if I pick a region, then a district, then a territory and i "clear" the region it retains the value of district and territory even though it is not showing. So if i move to the next section the values are off but it doesn' tell me its that district or territory only.
So My quesiton: is there a way to have it clear the selection of district and territory when I "clear" Region? At the moment i have to clear each independently which is confusing to other users.
thanks in advance.
Are you associating parameters with drop-down lists in the body of a section so that you can filter across sections and use interactions between the drop-down list (cascading prompts)? If so, you can create an advanced data source filter (global) from the left panel that includes nested IF ELSE RETURN logic to test if the region parameter is missing. If not missing, filter the region data item by the region parameter value and then test if the district parameter is missing in a nested IF ELSE RETURN, and so on. If the region parameter is missing, then return 1 = 1 in the advanced filter expression, so that no regions, districts, or territories are filtered for any section.
SAS is planning to include cascading filter prompts at the report and section level in a future release so you wouldn't have to do this.
Dave, I hope that make sense and helps.
It's been awhile since this post. I have tried many times to get something like this to work but i am afraid i may be on the wrong track.
Do you have or know where I can find any examples of what you proposed?
I have three variables: region, district, and territory. They cascade fine (using parameters), but i can't seem to get them to clear.
Thanks for any help you can give.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.