BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
elkinsbe
Obsidian | Level 7

on page 1 of my report, I have drop down menus for Country, State, County and City... and I want the selections to interact with all the objects on all the pages of the report..... How do I do that??? Thanks in advance for everyone's assistance....

1 ACCEPTED SOLUTION

Accepted Solutions
Sam_SAS
SAS Employee
The advantage to using parameters is that you can control which content is affected by the prompt.

If you make a report prompt, then everything will be filtered by that prompt.

View solution in original post

2 REPLIES 2
HunterT_SAS
SAS Employee

There are two ways to do this.

The first way, which is the easiest - If you haven't done this already, from the main Options menu (three dot menu in the upper right corner), select Expand Report Controls:

HunterT_SAS_0-1680523599792.png

 

This should add a new prompt area to the top of your report:

HunterT_SAS_1-1680523654824.png

 

Any prompt or control you set here will automatically filter content on every page in the report, provided the same data is used in the prompts and report objects OR if different datasources are used then they are appropriately mapped.

 

Another tip here - if you need to use a List Control then you first have to place a Prompt Container here, then put your List Control inside of the prompt container.

 

 

The second way is a little more complicated. You would need to create a Parameter for each prompt, and then use the parameter in a local filter against whatever object on whatever page you wanted. Using your example, with a drop down list on page 1 and a line chart on page 2, I would create a parameter and assign it to the Parameter role of the Drop Down list. Then I would add a Filter to the Line Chart using that parameter (e.g. MyDataItem = MyParameter), and then repeat for all prompts and report objects that matter. 

Sam_SAS
SAS Employee
The advantage to using parameters is that you can control which content is affected by the prompt.

If you make a report prompt, then everything will be filtered by that prompt.

sas-innovate-2024.png

 

Time is running out to save with the early bird rate. Register by Friday, March 1 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 2 replies
  • 428 views
  • 3 likes
  • 3 in conversation