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....
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:
This should add a new prompt area to the top of your report:
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.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.