Solved

Conditionally suppress page header in Crystal Reports

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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

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.
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Suggested Courses

617 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