Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

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
Not what you were looking for? View more on this topic or Ask a question