topic Re: Report Banding - Suppress Pages in QlikView

Report Banding - Suppress Pages

michaelfentondata — Thu, 26 Jun 2014 06:15:13 GMT

I have a report that is looping over possible values in a field. The problem is that not all values have data associated with them for the objects I am displaying.

Is it possible to suppress pages where there is no data to display?

Re: Report Banding - Suppress Pages

joggiek — Wed, 09 Jul 2014 09:33:43 GMT

Hi,

Did you get this figured out? I'm struggling with the same issue.

I tried adding a calculation condition to the table but then get the "Calculation Condition not met" printed on the "empty" page.

The I tried the same as the above but with no Caption, same result as above, except now without table headings.

Then I added a Conditional Show expression on the Layout tab for every item on the report, that resulted in the same number of pages, but now the ones I wanted to be suppressed were printing blank.

This could be a solution if you are not using page numbers and remove the blank pages from the printed report (atleast you can reuse those pages again ).

Will keep on trying and let you know if I get it figured out...

Let me know if you get to suppress the "empty" pages

Cheers

Re: Report Banding - Suppress Pages

michaelfentondata — Thu, 10 Jul 2014 05:14:52 GMT

Thanks Joggie.

That might work for us because, after producing the report, the user splits the PDF document into separate pages to send each one to the relevant stakeholder.