Blank pages in reports 6i with page break before/after property
I am developing a report with two independent queries, Q1 and Q2. Q1 returns
more than one vale and each value should be displayed on a new page. Q2 returns
only one value and this has to be diaplayed on a new page too, and I have some
default text fields which are displayed on all the pages.
I have set page break before property of Q2 to 'yes'. If Q1 and Q2 returns a
value then there is no problem ,if only Q2 returns a value then the first page
is blank. I used anchoring too.
My question is, how to suppress the blank page?.
I have tried setting the maximum records per page to 1, but it is
not working.
It works with in the query, what I mean is if Q1 returns multiple values then
each value is displayed on different page, but if Q2 also returns a value then
last page has two values one of Q1 and other of Q2, it is not displaying Q2 on
a different page.
thank you
saritha
I am developing a report with two independent queries, Q1 and Q2. Q1 returns
more than one vale and each value should be displayed on a new page. Q2 returns
only one value and this has to be diaplayed on a new page too, and I have some
default text fields which are displayed on all the pages.
I have set page break before property of Q2 to 'yes'. If Q1 and Q2 returns a
value then there is no problem ,if only Q2 returns a value then the first page
is blank. I used anchoring too.
My question is, how to suppress the blank page?.
I have tried setting the maximum records per page to 1, but it is
not working.
It works with in the query, what I mean is if Q1 returns multiple values then
each value is displayed on different page, but if Q2 also returns a value then
last page has two values one of Q1 and other of Q2, it is not displaying Q2 on
a different page.
thank you
saritha