Hi all,
I have a master report in VA that uses a Report Link to send the user to a detail report. When the user double clicks in the table on the master report it opens the detail report and at the top of the screen is a breadcrumbs type navigation eg:
Master Report > Detail Report and then a filter icon showing incoming filter information.
Clicking on the filter I can see all the report level filters and in particular variables I would like to use in Dynamic Titles eg Client Name. Is there any way I can get these filters into a title?
Many thanks in advance for your help
It appears in this scenario that the text box will show only those data items that can be mapped between the data source in the source report and the data source in the target report. If the data source in the target report does not include Client and Partner, then you won't be able to see those values in the text object.
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
Which version of Visual Analytics are you using?
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
Hiya, version is 8.5.1
I did some simple tests and it looks like you can use a text object in the detail report and show interactive filters. It would show all of the category values passed from the object in the source report
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
Hiya, I tried that but it just showed me the Report ID that I've used to link things up. Can I assign the other incoming filters such as Client and Partner below to make titles more descriptive?
Where are the other filters coming from? Report-level controls? Page-level? Controls on the canvas with interactions?
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
I have a report link via a table in the Master report that brings up the detail report and the variables in the image above are from the table even though I am only using the Report ID to link. Seems a bit odd we can't somehow use these dynamically in VA?
I have linked the list table in the Source report to the target report (CarsTarget)
My text object shows the same values seen the table in the target report and the same values shown in the Incoming Filters. I think your link must be defined differently. Can you provide more details about how you linked?
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
I have a table in my Master Report where I've set up a Report Link to the Detail Report and I use Report ID to link:
It appears in this scenario that the text box will show only those data items that can be mapped between the data source in the source report and the data source in the target report. If the data source in the target report does not include Client and Partner, then you won't be able to see those values in the text object.
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
Hi and sorry for late response but been offline. I think you're correct and even if client and partner were in the mapping I cant use them individually i.e. Client for one report and Partner for another. Thanks for your help, really appreciated.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.