Report -blank pages
This is Oracle reports 10.1.2.0.2.
I have a report that I suppressed unneeded lines using a trigger (if value = 0 then return false else return true).
I did this to get rid of pages that had zeros for subtotals.
As a result, I am got a few blank pages in the report. To fix this, I added in the kicker form for the report: 'blankpages=no'.
This works, but I had to move the page numbering from the header to the detail section. If I move the page numbering to the detail section, it still counts the blank pages, so when the user sees the PDF, The adobe reader displays the correct number of pages at 25, but the report displays 'page 2 of 31'. In other words, the page count on the report is off. How do I suppress blank pages without effecting the page numbering?
Thanks in advance.