Make a table of contents/list

[wanzek1]

I would like to create change the format of the following:

Group Header 4 = Phase Code - 1100.1
Group Header 5 = Equipment - 18270
Group Header 5 = Equipment - 18500
Group Header 5 = Equipment - 18600
Group Header 5 = Equipment - 19000
Group Header 5 = Equipment - 19001

to

Group Header 4 = Phase Code - 1100.1..............Group Header 5 = Equipment - 18270,18500,18600,19000,19001

The words group header are not needed but I wanted you to know the location.

Thanks!

 

[wanzek1]

I was able to get this to work using the following but there is still one issue:

Formula 1 (located in detail section but suppressed):
whileprintingrecords;

global stringvar sRemarks:=sRemarks & if next({EMRD.JCPhase})={EMRD.JCPhase}

or previous({EMRD.JCPhase})={EMRD.JCPhase}

then {EMRD.Equipment} & ','

else '';
sRemarks;

Formula 2 (located in group header 4):
Whileprintingrecords;

global stringvar sRemarks:=''

Formual 3 (located in detail section):
whileprintingrecords;

global stringvar sRemarks;

Formula 4 (located in suppress section of detail section) :
{EMRD.JCPhase}=next({EMRD.JCPhase})

Groups are:
EMRD.EMCo
JCMP.Name
EMRD.Job
EMRD.JCPhase

There can sometimes be a piece of equipment that will show up multiple times under a JCPhase. How can I only show that piece of equipment once?

1100.1 ---------10104, 171407, 173025, 173025, 173028