conditional suppress

[sameer11]

Iam doing summaries in the report footer.

How can I suppress the page heading when the report is printing report footer in the last page with no details above it

for ex:

I report which prints in 3 pages but since there is no room for the report footer to print in 2 page it is printing in the 3 page in that case I have to suppress the page heading(column headings)

TIA,
Sameer

 

[sameer11]

Nevermind, I figured

PageNumber = TotalPageCount

 

[sameer11]

sorry it doesn't work ...I was little too exited that I figured....

Any idea is appreciated....Thanks!

 

[lbass]

This should work if your entire report is only three pages, with the third page showing the report footer. Please explain in what way the results are incorrect.

-LB

 

[sameer11]

As you told it works when my report is showing in 3 pages
but when the user input changes the report might be printed in just 1 page or 2 pages ...depends on the data being printed. When I test the above one it worked when 3 pages
but I didn't work when the report has 2 pages where I had details above the report footer(and had room for report footer to be printed in the page 2) where I had to seen the page heading it suppressed the PH.

 

[lbass]

Create two formulas:

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

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

Then go to the section expert->page header->suppress->x+2 and enter:

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

-LB

 

[sameer11]

It worked!!!Thank you. You rock!,LB

 

[sameer11]

But I didn't understand the logic...how it reads and check?

 

[lbass]

A field/formula placed in the page header will reflect the value of the first record on that page. So the flag formula, when checked in the page header, will be true only when the report footer is the first section on the page--because the formula setting the flag to true is placed in the report footer.

-LB