Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditionally Suppressing a Page Header 1

Status
Not open for further replies.

Deanna

Technical User
Mar 16, 2000
4
US
I am using Crystal Reports 8.

I have designed an invoice that uses two different page headers. The first page of the invoice has different information than the rest of the pages for that invoice. I can get the first invoice to print correctly, including the second and third pages but the second invoice prints both headers on the first page. In the Section Expert for the Page Header I have checked the Suppress(No Drill Down) box and in the Formula Editor I have OnFirstRecord.

Thanks in advance for the help.

 
I have used (for footers) 2 formula fields. Use an if statement. If you don't want to show the header, send "" to the field. if you do want to see the header, send it the desired text. Do the same for the other heading...
I hope this helps and answers your question,
Brett Please visit my websites!
 
Instead of OnFirstRecord, put in
PreviousIsNull({InvoiceNumber}) OR Previous({InvoiceNumber}) <> {InvoiceNumber}
This checks to see if you are on the first record (the previous is null part) or if you have just switched from one invoice number to another, by comparing the previous and current invoice numbers. Malcolm
Remember, if it wasn't for electricity, we'd be surfing the net by candlelight.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top