how to convert the multiple row into the single row ?

[CrystalReports9]

Current Result
-----------------
<GH> Department 10
<Detail>
Employee ID
------------
12
13 [ Multiple Rows ]
43
54

Required Output:
---------------------
<GH> Department 10
<Detail>
Employee ID
12,13,43,54 [Single Row]

 

[lbass]

Use three formulas:

//{@reset} to be placed in the Department group header:
whileprintingrecords;
stringvar x := "";

//{@accum} to be placed in the detail section:
whileprintingrecords;
stringvar x := x + totext({table.employeeID},0,"")+", ";

//{@display} to be placed in the department group footer:
whileprintingrecords;
stringvar x;
left(x,len(x)-2);

-LB

 

[CrystalReports9]

Weldone LB.... Excellent....

Before submit the post, I was finding difficulties with the 'group footer'.

Now your TIPS helps me.... Thank you... Much.

 

[CrystalReports9]

At same time in the <Detail Section> the data come like

12,
12,13
12,13,43
12,13,43,54


If i place the formula {@accum} in the <FOOTER SETION> then i am getting only one row 12,13,43,54 .

How to overcome this ?

 

[lbass]

You should suppress the details section and display only the group footer. Use the {@display} formula in the group footer, not {@accum}.

-LB