How to Create a Repeating/Conditional Group Header

[CRadel]

Hi. This forum was so helpful yesterday, so I'm hoping for another dose of good luck today!

I have a report where the data in some of my groups spill over onto multiple pages. I'd like the group headers to repeat on any additional pages, with the word "continued". So the group header on the first page would be "Members" and then on any additional pages it would say "Members (continued)".

Can anyone help me with a formula to do this, in language a fairly new user can understand?

Thanks so much in advance!

Carol (a grateful newbie)

 

[lbass]

Replace the groupname with a formula:

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

-LB

 

[CRadel]

Thanks lbass, but something is still not working.

I have the following:

if inrepeatedgroupheader then {CR__Membership_Monthly_Counts.Mem_Cur_Category_description} + " (continued)" else {CR__Membership_Monthly_Counts.Mem_Cur_Category_description}

Can you tell from this what is wrong?

Thanks!

 

[lbass]

What isn't working? If you didn't do it when you set up the group, go into the report->group expert->group->options and check "Repeat group headers on each page".

-LB

 

[CRadel]

Thank you! That was it - now it's perfect!

It's hard being new at something like this - I really appreciate your help!

Carol