Concatenate text fields under each group but keep adding other group text

[Former Member]

I have a sub report shows Note Type (in Group Header)

and Note_Text.

This report should show concatenated Note Text records under each Note_Type.

I set up formulas like this.

(Group Header #1)

Note_Type @HeadG

WhilePrintingRecords;

Global StringVar ConCat ;

if not inrepeatedgroupheader then ConCat := "";

(Details ) Suppress

(Group Footer #1)

@Test1

WhileReadingRecords;

Global StringVar ConCat;

if not IsNull({VW_CHANGE_NOTES.NOTE_TEXT}) then

(

ConCat := (ConCat + {VW_CHANGE_NOTES.NOTE_TEXT});

)

Database table is like this

Note_Type Note_Text

-

---

-

---

DOC aaaa

DOC bbbb

EST cccc

REV dddd

Report should look like this

DOC

aaaabbbb

EST

cccc

REV

dddd

But now the report shows like this

DOC

aaaabbbb

EST

aaaabbbbcccc

REV

aaaabbbbccccdddd

How can I separate Note_Text just each Note_Type?

Thank you.

[Former Member]

Create a formula

Shared StringVar ConCat;

ConCat := (ConCat + {VW_CHANGE_NOTES.NOTE_TEXT});

and put it in the Detail line. (Suppress it )

Then put a formula in the Group Footer that says

Shared stringvar ConCat;

put a formula in the Group Header that says

Shared StringVar ConCat ;

ConCat := '';

Then Uncheck "Keep Object together" at Group Footer