Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to suppress a field in a Page Header 2

Status
Not open for further replies.

RenaG

Programmer
May 3, 2011
132
US
I am working in Crystal 10.

I have a report that has an input parameter to select multiple staff. The report is grouped by staff and there are a couple of cross-tabs in the group footer. There are also a couple of cross-tabs in the report footer to display information for the entire report.

I have the staff name in the Page header. I would like to suppress this field when the Report footer prints (it starts a new page). How would I set up a conditional suppress do to this?

TIA!
~RLG
 

Right click -> Format Field

In the formula for suppress, enter:

onlastrecord

 
That worked really well...

except...

the cross-tabs I have in the group footer spans a couple of pages so on the second page of the cross-tab for the last staff, the name is suppressed. Is there a way around that?

TIA!
~RLG
 
Create two formulas:

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

//{@true} to be placed in the report footer and suppressed:
whileprintingrecords;
booleanvar flag := true;

Then right click on the name field in the page header->format field->suppress->x+2 and enter:

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

-LB
 

Works like a charm! Thanks so much!!!

~RLG
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top