topic Re: Report control on Page Control drop-down list with more than 500 variables in SAS Visual Analytics

Report control on Page Control drop-down list with more than 500 variables

Stephanvd — Sun, 30 Aug 2020 08:33:41 GMT

I use a control (filter) on 2 layers:
- Report control filter
- Page control filter

The page filter is a drop down list with more than 500 variables, so the limit has been exceeded.
The report filter must first filter this page filter, then the number of variables is never more than 500.

In Report Designer this works as it should,
but in Report Viewer the drop down on the page filter doesn't want to filter. 

VA version: 7.5 release (9.4m6)

Does anyone know a way to fix this problem?, it would be nice to keep the drop down list on the page controls.

Re: Report control on Page Control drop-down list with more than 500 variables

Madelyn_SAS — Fri, 28 Aug 2020 20:38:14 GMT

Which version of Visual Analytics is this?

Re: Report control on Page Control drop-down list with more than 500 variables

Stephanvd — Sun, 30 Aug 2020 08:32:01 GMT

Dear Madelyn,

It is the 7.5 Release (9.4m6) with the new html5 base.

Regards,
Stephan

Re: Report control on Page Control drop-down list with more than 500 variables

MClay — Fri, 04 Sep 2020 18:40:21 GMT

Hi Stephan - are you using different data sources for the report and page filter? Also, I'm not sure if report-level filters support Actions but you could try setting up a filtering action between the report and page filters.

Re: Report control on Page Control drop-down list with more than 500 variables

Stephanvd — Wed, 09 Sep 2020 06:53:05 GMT

Hi MClay,

thanks for your reply.
I use different data sources that I have mapped.
It works in the report designer, so there is a filter action between the report level filter and the page filter.
But in the report viewer, the action does not work.

I cannot set a filter action between the report and page filter, this is set by definition.