Suppressing field in page header

[RepRider]

CRXI and SQL database

I have similar reports with varying lengths of detail pages but the last 2 pages are filled with summary crosstabs where I do not want a specific field in the page header to display.

I have tried suppressing with the following formula:

OnLastRecord
and
{vNewTicklerBase.Supervisor} <> next({vNewTicklerBase.Supervisor})

However this also suppresses on the last page of the details where I need it to show.

Is there a formula that will supress this header always on the last two pages of the report?

 

[lbass]

There are other ways of doing this, but if you are sure it will always be the last two pages, you could use a suppression formula like this:

pagenumber in totalpagecount-1 to totalpagecount

-LB

 

[RepRider]

Thank you lbass, that worked perfect for the set of reports that I working with right now.

what are the other ways? I have a similar problem with another set of reports... where the crosstab pages vary from 1 - 3 pages...

 

[lbass]

Create two formulas:

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

//{@true} to be placed in the section containing the crosstab:
whileprintingrecords;
booleanvar flag := true;

Then format the page header you want to suppress on crosstab pages by going into the section expert->page header->suppress->x+2 and entering:

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

-LB

 

[RepRider]

Will this work if its just ONE data field on the page header not the whole page header that I want to suppress on the crosstab pages?

 

[lbass]

Yes.

-LB