Cristal reports page brake before cross tab
In Crystal Reports XI I have Report header, page header section, detail section, page footer and report footer section.
I need to show detail records in detail section and I need to show cross tab in report footer.
Problem is that I have columns titles in page header and I don’t want to show them in on pages where my cross tab is.
Cross tab is going over last three pages.
e.g. report has 35 pages I need new page brake to start after 31 page where detail records finished. And after that I do not need to see column titles on page header.
I need to show detail records in detail section and I need to show cross tab in report footer.
Problem is that I have columns titles in page header and I don’t want to show them in on pages where my cross tab is.
Cross tab is going over last three pages.
e.g. report has 35 pages I need new page brake to start after 31 page where detail records finished. And after that I do not need to see column titles on page header.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
In the section expert check the 'New Page Before' option for the page footer, in the page header section add a conditional suppression formula OnLastRecord
ASKER
Thanks mlmcc it works,
can you just tell me what is happening, ordred of those contditions how they are evaluated and when.
can you just tell me what is happening, ordred of those contditions how they are evaluated and when.
ASKER
No bother I got it
Did you try using OnLastRecord It's far simpler
GJParker,
I think you meant "check the 'New Page Before' option for the REPORT footer". Starting a new page before the page footer wouldn't make much sense (and CR 10 doesn't allow it). :-)
If so, FWIW, that's what I suggested. The NPB on the report footer would start the cross-tab on a new page, in which case OnLastRecord on the page header might work.
James
I think you meant "check the 'New Page Before' option for the REPORT footer". Starting a new page before the page footer wouldn't make much sense (and CR 10 doesn't allow it). :-)
If so, FWIW, that's what I suggested. The NPB on the report footer would start the cross-tab on a new page, in which case OnLastRecord on the page header might work.
James
OnLastRecord
I'm not sure if that will work or not. The way CR builds the report pages, sometimes things don't happen in the order I'd expect. It could also depend on the structure of your report. You'll just have to try it and see.
If that doesn't work, then you'll probably have to use formulas and variables, as mlmcc suggested. FWIW, my first thought was something like his second suggestion, with a new report footer section.
James