Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jun 23, 2010 at 06:19 PM

    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

    Add comment
    10|10000 characters needed characters exceeded