I need to find out how to concatina

[surad]

I need to find out how to concatinate data in one cell. I am trying to put all the caseid field data to appear one cell when export to excel rather showing seperate rows. For example, 43443
24302
20303
I would like them to appear as 43443, 24302, 20303 in one line. I pulling this data from casetypes of all the caseids reported in certain period of time.

Thank you

 

[MJRBIM]

If you use the 3 formulas below you can create a string of up to 254 Characters.

REPORT HEADER

Name : {@ResetCaseTypeList}
Formula : Shared stringVar CaseTypeList := "";

DEATIL

Name : {@AddCaseTypeList}
Formula : Shared stringVar CaseTypeList := CaseTypeList + (Replace (ToText ({Table.CaseType}),".00" ,"" )) + "; ";

REPORT FOOTER

Name : {@DisplayCaseTypeList}
Formula : Shared stringVar CaseTypeList := Replace (CaseTypeList,"," ,"" )


Data will display as...

CaseId CaseType AddCaseTypeList
========================================================
1 43443 43,443;
2 24302 43,443; 24,302;
3 20303 43,443; 24,302; 20,303;
========================================================
DisplayCaseTypeList - 43443; 24302; 20303;
========================================================