Supress page header field if group footer present 2

[RepRider]

CRXI and SQL

I have a report that is group by supervisors and report specific data for employees under them. I have the employee name visible in the header with their data displaying on their own page. Sometimes there would be an extra page at the end of the group so I put in a formula to hide the employee name on that last page by suppessing on last record with text formatting.

Now I have added several crosstabs in group footer 1a that summarize the data that was showing in detail. Everything is working fine but I now need to hide that last employees name on this page also (sometimes 2-3 pages). Is there a formula that will suppress the last employees name of the group that is in the page header when only the group footer 1a summary is showing?? I hope I have made myself clear enough.

 

[lbass]

Visible in what header? The page header? If so, try using a formula like this:

onlastrecord or
{table.supervisor} <> next({table.supervisor})

-LB

 

[RepRider]

yes, lbass you guessed exactly right, it was the page header. Your formula modification works perfectly!! thanks!!!