Getting rid of extraneous information in Page Header 1

[melburstein]

My report is exactly what the user wants but needs one cosmetic change. My Group Footer 1 and Report Totals each print on separate pages. The only thing on these pages is the standard Page Header information and a total line.

One of the things that prints on the standard page header is {AMASSET.ASSET_TYPE}. The user does not want to see this on those pages that contain the Group 1 Footers and the Grand Total (remember only the totals appear on these pages).

How do I supress the printing of this single element of Page Header information when the page is a Group 1 Footer or Report Total?

Your help is greatly appreciated.

 

[lbass]

Create two formulas:

//{@false} to be placed in the group #1 header:
whileprintingrecords;
booleanvar flag := false;

//{@true} to be placed in the group #1 footer:
whileprintingrecords;
booleanvar flag := true;

Then right click on the field you want to conditionally suppress->format field->common->suppress->x+2 and enter:

whileprintingrecords;
booleanvar flag;
flag = true

-LB

 

[melburstein]

Lbass,

Thank you for your reply. I thought that I understood it, until I tried to do it. My question concerns creating and placing the two formulas. Do I create them as new formulas? How do I place them in the group #1 header and group #1 footer.

Thank You

Mel

 

[lbass]

Go to insert->field explorer->formula fields->new and create them there. Then drag each of them from the field explorer to the correct position on the report. You can then right click on each of them->format field->common->suppress, so that they don't appear.

-LB

 

[melburstein]

lbass,

Thank you for your PROMPT reply. Your solution worked PERFECTLY! I don't understand how it works, but I am very grateful for your help.

Mel

 

[lbass]

As an explanation, the formulas toggle the value of true/false. If {@false} is placed in the group header, then the value of the flag will stay false until the formula is set to true--in this case, when the group footer occurs. The page header takes on the value of the first record/section on the page, and since you have group footers set to new page before and after, when the group footer occurs, the formatting formula of the field in the page header will read the value as true and suppress the field.

-LB