Iteration-pages with visibility agent
Hi all,
I have a problem when I add an iteration to a report, that also contains a visibility agent.
When I add an iteration to the report, it creates all the iteration-pages, but most of the pages are blank, because there also is a visibility agent on the report, so that the table/data is only displayed if it's within a given interval. The problem is, that the iteration-pages are created even though they are blank. They should not be created if they are blank. Are there anyone that have experienced something similar and have found a way to solve this? I haven't managed to find a proper solution.
As you can see on the first picture below, there is data for CZ_NL1 in the iteration-editor, but because the number is within the interval of the visibility agent, it gets blank on the iteration-page when printing the report (picture 2). The report shouldn't include the blank pages (as the one on picture 2 for example).
Comments
Hi Michael
I think you can add the visibility agent to the iteration table (the same one as in the report) and that should fix the issue.
br/Niels
Hi Niels,
Thanks for your answer.
I have tried to add the same visibility agent on the iteration table as on the report itself, but it still creates the pages even though they are blank. They are blank because of the visibility agent, but the visibility agent doesn't help me get rid of the blank pages / pages with no data.
/Michael
I think I get it now :-)
If you have a page with a chart that has a visibility agent applied which is part of an iteration loop, I think the visibility agent belongs (only) in the iteration loop.
Let's say you have a chart like this on a page of your report
now you have a visibility agent saying something like sum(d1,0,m1) < 500.000.
The action on this visibility agent is to hide the year.
No years will be hidden though - since all values are above 500.000.
However - if you then iterate this page through Salespersons - then the years are split into salespeople.
I tried to set up the iteration table to show this:
When this iteration is actually rendered, my former visibility agent will hide all the values of Justen Cartwright and Parvaiz Bradshaw - since the years are less than 500.000 - in other words my initial visibility agent means something different in the iteration loop.
To make sure you get the result you want - I think the solution should be to have a visibility agent on the iteration table only, when an iteration is involved.
Please sign in to leave a comment.