Page Header once per group

[dev1212]

Hi,

I have a group on {ACCNT_NMBR} field. There is a page header which i want to display just once per account number. And want to suppress this page header on last page.

How to do that..? Any help would be greatly appreciated.

Thanks

 

[lbass]

Use a suppression formula on the page header like this:

pagenumber = totalpagecount or
{table.acctnumber} = previous({table.acctnumber})

-LB

 

[dev1212]

Thanks LB. It works fine for all but first page. The page header displays once every group for all other groups but not for first group. Page header is suppressed for first {ACCNT_NMBR} group.

 

[IanWaterman]

Probably because previous({table.acctnumber}) is a null

try

pagenumber = totalpagecount or
(not onfirstrecord and {table.acctnumber} = previous({table.acctnumber}))

Ian

 

[dev1212]

LB, it doesnt work.

 

[dev1212]

I see the same behavior, i.e., page header displays once every group for all other groups but not for first group. Page header is suppressed for first {ACCNT_NMBR} group.

 

[lbass]

Remove the check mark from the box and just leave the conditional formula in the x+2 formula area.

-LB

 

[dev1212]

There is no check mark on the box, i unchecked it already when i was writing this formula, its just the conditional formula in x+2 formula area.

 

[dev1212]

One more point i would like to say, There is a report header that is of size one page followed by this page header if that helps.

RH - One page length
PH - Just headers text objects
GH - Account number details

 

[lbass]

Please post the exact formula you are using in the section expert->page header->x+2 area. I tested my formula and it works.

-LB