Concatenate Multiple Rows 1

[kcoleman26]

Crystal 2008
I have a report grouped by ID# some ID's have 1 contract some ID's have multiple contracts.

I want a single field display of all of the contracts for the ID#.

Example:
ID 1
Contract #1

ID 2
Contract #1
Contract #2
Contract #3

ID 3
Contract #1
Contract #2

What I want it to display like this in the Group/Header or Footer:
(2 Columns)
ID# CONTRACT#'s
ID 1 Contract#1
ID 2 Contract#1, Contract#2, Contract#3
ID 3 Contract#1, Contract#2

Thanks,
KC

 

[ianoctdec]

Hello KC,

You can display it on the group footer, you'll need three formulas:

//place in groupheader section
@ResetVar
whileprintingrecords;
stringvar vcontractlist := ''

//place in detail section
@ContractsList
whileprintinrecords;
stringvar vcontractlist := vcontractlist + table.contractID + ', '

//place in group footer section
@DispList
whileprintingrecords;
stringvar vcontractlist;
left(vcontractlist, len(vcontractlist) - 2

 

[kcoleman26]

Thanks ianoctdec that worked perfectly

KC