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

Hello,

 

I have a SAS VA 7.4 report with 2 tabs. Each tab has a list table, each with its own data source.

 

These tables are linked together so when a record in Tab 1-List Table 1 gets clicked, it drills down to Tab 2-List Table 2 and displays a record.

 

The issue that I am having is that when the report first loads, it loads every record in the data source in both List Tables. This is expected behavior, however, I would prefer that List Table 2 on tab 2 NOT load every record. i want List Table 2 to be empty unless someone clicks on a row in List Table 1.

 

Is this possible?

1 ACCEPTED SOLUTION

Accepted Solutions
Madelyn_SAS
SAS Super FREQ

Have you considered making the section with the second list table an Info Window? The Info Window would only display when the user makes a selection in the first list table.

 

View solution in original post

3 REPLIES 3
Madelyn_SAS
SAS Super FREQ

Have you considered making the section with the second list table an Info Window? The Info Window would only display when the user makes a selection in the first list table.

 

eslna
Obsidian | Level 7

This definitely works better than any other option I thought of. Thanks!!

KeithM
SAS Employee

If you have a prompt on the report then you can add a parameter to the report.  Typically when a report opens, the parameter value is missing.  Thus, you could add a filter to both List table that looks something like:

 

If MyParameter Missing then

1=0

else

1=1

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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
  • 3 replies
  • 1038 views
  • 0 likes
  • 3 in conversation