Suppress Footer Based on Detail Section

[bigmerf]

Does anyone know if there is a way to suppress a FOOTER section based on a particular DETAIL section?

I have two DETAIL sections on a report with two FOOTERS. I want "Page Footer a" to only display on the page for "Details a" whereas I want "Page Footer b" to only display on the page for "Details b".

Is there a way to suppress a footer section based on other section criteria?

 

[lbass]

Create two formulas:

//{@true} to be placed in the page header and in details_b and suppressed:
whileprintingrecords;
booleanvar flag := true;

//{@false} to be placed in details_a and suppressed:
whileprintingrecords;
booleanvar flag := false;

Then go into the section expert->page footer_a->suppress->x+2 and enter:

whileprintingrecords;
booleanvar flag;
flag = true;//note no colon

Then go to page footer_b->suppress->x+2 and enter:

whileprintingrecords;
booleanvar flag;
flag = false;

-LB

 

[bigmerf]

Great, that worked! One more question, what if I have more than one(1) detail section and more than one(1) footer to display? Do I need to create multiple formula fields for the "FLAG" and reference each one?

Thanks again for the help!

 

[lbass]

The above formulas assumed two detail sections (a and b) and two page footers (a and b), so I'm confused.

-LB

 

[bigmerf]

You are correct, that works with two detail sections and two footer sections. But, what if I wanted to add an additional detail and footer section?

Thanks again!

 

[lbass]

I would probably set up a separate set of flags using a new variable flag2 or something. See if you can follow the logic above--once you have set a value to the flag, it remains that value until you set the alternative value.

-LB