Solved

Conditionally suppress page header in Crystal Reports

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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
How to increase the row limit in Jasper Server.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

789 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