Solved

Conditionally suppress page header in Crystal Reports

Posted on 2010-11-24
3
1,127 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
  • 2
3 Comments
 
LVL 34

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 34

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

760 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now