Solved

Conditionally suppress page header in Crystal Reports

Posted on 2010-11-24
3
1,207 Views
Last Modified: 2013-11-15
I have added a sub-report to a Crystal Report report footer section. As soon as the sub-report kicks in I need to suppress the page header. I have set a new page before the sub-report. How do I do this? Any help would be greatly appreciated.
0
Comment
Question by:brcs333
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 35

Accepted Solution

by:
James0628 earned 50 total points
ID: 34210929
Are there other things, like group footers or other report footer sections, that print after the last record, on separate pages?  For example, the last record prints on page 5, and then you have a group footer or another report footer that prints on page 6.  Or could the last record be on a page by itself?

 If not, you could try using OnLastRecord as the suppression formula for the page header section.  It should then be suppressed once the last record has been read.

 Otherwise, you could try inserting another report footer section above the one with the subreport, suppressing the new section, putting a formula in it that sets a variable, and checking that variable in the suppression formula for the page header section.  The theory is that CR would get to the new report footer section and the variable would be set.  Then it would go to a new page for the subreport report footer section, and the variable would tell it to suppress the page header.  No guarantees though.  Sometimes the way that CR puts together a report is not so linear.  But that might work.  Just holler if you need some details.  :-)

 James
0
 

Author Comment

by:brcs333
ID: 34211174
Thank you so much. The OnLastRecord option worked a treat.
0
 
LVL 35

Expert Comment

by:James0628
ID: 34211234
Glad to hear it.  It was the simplest option, but it would only work under the right circumstances.

 James
0

Featured Post

Enroll in June's Course of the Month

June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question