Suppress/Change Page Header on condition

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?
CuraSAAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mlmccConnect With a Mentor Commented:

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
 
mlmccCommented:
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
 
CuraSAAuthor Commented:
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
 
CuraSAAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.