topic Re: Use Report Level Filters in Dynamic Titles in SAS Visual Analytics

Use Report Level Filters in Dynamic Titles

SteveNZ — Tue, 22 Mar 2022 03:37:22 GMT

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

Re: Use Report Level Filters in Dynamic Titles

Madelyn_SAS — Tue, 22 Mar 2022 13:26:51 GMT

Which version of Visual Analytics are you using?

Re: Use Report Level Filters in Dynamic Titles

SteveNZ — Tue, 22 Mar 2022 19:10:28 GMT

Hiya, version is 8.5.1

Re: Use Report Level Filters in Dynamic Titles

Madelyn_SAS — Tue, 22 Mar 2022 20:07:17 GMT

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

Re: Use Report Level Filters in Dynamic Titles

SteveNZ — Tue, 22 Mar 2022 21:31:40 GMT

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?

Re: Use Report Level Filters in Dynamic Titles

Madelyn_SAS — Wed, 23 Mar 2022 14:07:40 GMT

Where are the other filters coming from? Report-level controls? Page-level? Controls on the canvas with interactions?

Re: Use Report Level Filters in Dynamic Titles

SteveNZ — Wed, 23 Mar 2022 19:16:49 GMT

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?

Re: Use Report Level Filters in Dynamic Titles

Madelyn_SAS — Wed, 23 Mar 2022 19:57:20 GMT

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?

Re: Use Report Level Filters in Dynamic Titles

SteveNZ — Thu, 24 Mar 2022 02:51:39 GMT

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:

Re: Use Report Level Filters in Dynamic Titles

Madelyn_SAS — Thu, 24 Mar 2022 14:26:41 GMT

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.

Re: Use Report Level Filters in Dynamic Titles

SteveNZ — Thu, 31 Mar 2022 20:28:19 GMT

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.