Solved

Suppress/Change Page Header on condition

Posted on 2011-09-21
4
276 Views
Last Modified: 2012-05-12
I have a report with a Sub-Report and I need to change something in the Page Header

The thing is the page number on what the header needs to change/suppress is not always the same.  Depending on the amount of data the user enters it might shift to the next page.

Attached you will see a Header with the word "Motto"

I need to change that word (This is a normal label field) to something else only on the page where I have the sub-report and anything after that should go back to the original Page Header.

So I need to Either suppress the entire page header for this page (but no page number formula will work as the page isn't always the same number) or I need to suppress this label field and un-suppress the label that I have to show.

How can I do this?
0
Comment
Question by:CuraSA
  • 2
  • 2
4 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 36578320
Here is an idea.

You may need to change your report layout a little

Original report layout - assumes agroup with the subreport in the group footer

RH
PH
GH1
Details
GF1 - Subreport


Right click the section with the subreport in the left margin
Click INSERT SECTION BELOW
Repeat
Drag one of the new sections so it is above the one with the subreport

Now it will look like

RH
PH
GH1
Details
GF1a
GF1b - Subreport
GF1c

Add a formula to the report header
WhilePrintingRecords;
Global BooleanVar SuppressMotto;
SuppressMotto := False;
""

Add a formula to GF1a
WhilePrintingRecords;
Global BooleanVar SuppressMotto;
SuppressMotto := True;
""

Add a formula to GF1c
WhilePrintingRecords;
Global BooleanVar SuppressMotto;
SuppressMotto := False;
""

Suppress the field with
WhilePrintingRecords;
Global BooleanVar SuppressMotto;
SuppressMotto

mlmcc
0
 

Author Comment

by:CuraSA
ID: 36578752
Hi mlmcc

I made the changes to have 3 GF in my report.  I opened my section expert and pasted the above formula's in the "Suppress if blank" window.  Is this correct?

If this is correct then it doesn't work.  There's report looks the same :(
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 300 total points
ID: 36580509

The suppression formula goes in the SUPPRESS of the section expert to suppress the entire page header or it should go on the suppression formula of the field itself.

mlmcc
0
 

Author Closing Comment

by:CuraSA
ID: 36903601
I ended up removing the details in the heading and made the PH a bit smaller.  Then when I needed to I created the Appendix1 ect. on the page I was working on.
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

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. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

895 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

19 Experts available now in Live!

Get 1:1 Help Now