suppress page if no data

[atarrqis]

CR11 & Oracle
I have Page Header/Footer a & b, 1 group and Report Header/Footer a, b & c.
In Report Footer c I have {Notes} and this section has New Page Before and Suppress Blank Section. I only want the Notes to print on the last page, if they exist. These Notes are for internal use only. They don't go to the customer so I don't want this page included in the page numbering.
I always get a last page with PH a & b, even when there are no Notes. Also, the page number is incorrect. How should I resolve these 2 issues. Thanks.

 

[lbass]

If "notes" are a database field, you can conditionally suppress the RF_c with a formula like:

isnull({table.notes})

You could add a formula like this into the New Page Before formula area for RF_c:

not isnull({table.notes})

-LB

 

[atarrqis]

I must not have made myself clear. My issue is not with suppressing the RFc - this works fine. I want to suppress PH a & b for this last page if IsNull{Notes}. Yes, this is a database field. I also don't want this last page to be included in the page count.

 

[lbass]

I understood that, but there is something on that page causing the blank space. But the page headers/footers are only appearing because of the new page before, I think. What happened when you tried these suggestions?

-LB

 

[atarrqis]

I tmade no difference. I still get the page with PH a & b even though {Notes} is null.
NotIsNull{Notes} is on the New Page Before.
IsNull{Notes} is on the RF c.

 

[lbass]

Okay, just tested this, and all that was necessary to eliminate the final page was to add a formula like this into the New Page Before formula area for RF_c:

not isnull({table.notes})

You do not have to do anything with the page headers/footers.

-LB

 

[atarrqis]

That's nice but it does not work for me. Thanks for your help.

 

[atarrqis]

I needed to add {NOTES} = ' or IsNull{Notes} to the RF c suppression.

 

[lbass]

If you are checking for nulls, it has to come first, as in:

IsNull({Notes}) or
{NOTES} = '

-LB