10-03-2016 04:18 AM
Hi all VA experts
I'm not sure this problem can be solved, but maybe someone of you already deal with it and has found some workaround
We have a report in VA 7.3 (but the same applied to VA 6.4) with a dropdown menu used as a mandatory filter for a field (we can say it is country, i.e.). The filter is mandatory since data cannot be aggregate in a grand total manner.
On the same field of the table we have also a row level security applied, since some users can see all the countries, some other just some of them, and some other again just one.
At this point, when we save the report the filter menu has a value in it, lets say USA. But now, if a user that has only available Europe as country try to open the report, it has a no data available, since the report try to apply the USA filter to the data, that has only Europe available.
Is there a way solve or workaround this behaviour?
10-03-2016 11:11 AM