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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CRXI: change Group name if on second page 2

Status
Not open for further replies.

glyrocks

Technical User
Nov 16, 2006
57
US
I'm in need of a little assistance creating a formula to change the group name if the group continues across a page break. I need to add "(CONTINUED)" to the group name and I'm not sure what condition to check for in an IF THEN kind of statement. Thanks!

dylan
 
The basic formula starts with:
If InRepeatedGroupHeader Then ..........

This is only true if the group goes on to page 2+.
 

I'm not sure what you mean by "this is only true if the group goes on to page 2+." Does that mean this only works if there are more than two pages with the same group? Thanks,

dylan
 
If you have formatted the group to "repeat group header on each page", then you can use the formula:

if inrepeatedgroupheader then
{table.groupfield} + " (Continued)" else
{table.groupfield}

Use this formula instead of the groupname in the group header.

-LB
 
Thank you both, those work perfectly for two different reports!

dylan
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top