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.
Secure your spot at the must-attend AI and analytics event of 2024: SAS Innovate 2024! Get ready for a jam-packed agenda featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.
Register by March 1 to snag the Early Bird rate of just $695! Don't miss out on this exclusive offer.