Solved

Conditionally suppress page header in Crystal Reports

Posted on 2010-11-24
3
1,140 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

867 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

21 Experts available now in Live!

Get 1:1 Help Now