Concatenating multi rows

[ililal]

Here is the Result Set.

----------------------------
ID_NUM | Name | Description |
----------------------------
1 |Al |Reporter |
1 |Al |Developer |
1 |Al |DBA |
-----------------------------

Desired result
Report
ID_NUM Name Description
1 Al Reporter, Developer, DBA


I've also tried suppressing the data; however, my reports look like.
ID_NUM Name Description
1 Al Reporter
Reporter, Developer
Reporter, Developer, DBA

Thanks,
Al

 

[IdoMillet]

Looks like you already used a string variable approach and managed to concatenate the values in a detail-level formula.

Now just place a formula in the Group Footer that simply displays the variable and suppress the detail section.

Remember to reset the variable in a Group Header formula.

- Ido



view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[ililal]

Thanks, it works. Now, I'm trying to alternate color.
My color formula is:

if remainder(RecordNumber, 2) > 0 then silver
else
white;

Also, it is placed in the group footer section.
However, it only prints white lines. Any suggestions?

 

[IdoMillet]

Use GroupNumber instead of RecordNumber.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com