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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I only display Report Header B when on the Report Footer

Status
Not open for further replies.

bkrav

MIS
Jul 26, 2006
19
US
Crystal 10
I have Page Header A displaying a GroupBy variable, and I have a summary crosstab in the report footer, so when looking at the report footer I want to display Page Header B, that says the Total. I tried putting the OnLastRecord in the suppress formula but then it would display the 'Totals' header on the last group as well.
 
Try comairing PageNumber to TotalPageCount. This should tell you when you are on the last page.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
The thing is the total crosstab located in the report footer is sometimes 2-3 pages, so starting it on a specific page will not always work. Perhaps I could just place a title in the crosstab that displays on every page? The whole idea heree is that this one report can just be updated and then printed and results in several different reports, with their own page numbers. Thanks for your reply!
 
If the crosstab is formatted to start on a new page, you could just use the following for your conditional suppression of the page header_a:

onlastrecord

For suppression of page header_b use:

not onlastrecord

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top