Concatenate Multiple Rows in Crystal Reports 2008

Hi James,

Thanks for now, Please let me know some more details. I ill try tomorrow and let u know.

But along with these fields I also have 5 different columns, so is it applicable to place all these fields along with the above formula in the group header.

Date, Type, Purpose, Outcome, Author, Entered Date, Last Change Date, User Name, staff credits

FOR EACH AUTHOR THERE ARE MORE THAN ONE STAFF CREDITS 1,2,3....
with reference to above example
CONTACT REPORT ID......> AUTHOR INFORMATION
REPORT_NM ......> STAFF  CREDITS INFORMATION

*** EVERY THING SHOULD APPEAR IN ONE SECTION ***
========================
Date       Type      Purpose            Outcome                  Unit
------------------------------------------------------------------------
5/1/2010       Meeting       Cultivation   Move to Proposal       A

Author: Name (On Behlaf Of if not blank and not the same as Unit)
Staff Credited 1, Staff Credited 2, Staff Credited 3...................................(.this is what needed )

Text
Entered by: User Name on Date
Last Changed by: User Name on Date
=======================
3/10/2010      Phone Call      Cultivation      Cultivation      A
Author:Name
Staff Credited 1, Staff Credited 2, Staff Credited 3

Text

Entered on: Date
Last Changed by: User Name on Date
====================================================


Thanks in Advance
PVRAO

You can't use the solution that I described in the group header.  The values will be added to the variable as the records are read, so you won't have the final value until the group footer.  But that's probably not a problem.  Anything else that you had in the group header will probably work just as well in the group footer, so you can probably just move everything from the header to the footer.

 If your other fields are the same for every record in the group, then you can just put those fields in the group footer.  If any of the other fields could have multiple values for the records in a group, then it's a question of how you want to handle those.

 James

Here only Staff Credit have multiple values for each author, and I need to display side by side in CSV format.
Since only staff credit have distinct values
Rest of the columns have same data for each group of author.

i,e I am getting 3 set of records for each author, with only distinct field "staff credit"
to avoid multiple set of records and show only one row for each author, I need to concatenate
 "staff credit"

Please let me know whether the above logic works here by place all fields in Group Footer?

I assume you already have the SQL to generate the staff list and you just need to add the CSV list part.

Did you look at the link I provided?

I can't help with the Crystal Report itself but can help with the SQL you need.  If you can't get the XMLAGG working please post table defs, sample data and expected results and I'll try to come up with the SQL.

I can't see any reason why you couldn't do this in the group footer.

 James

I used the Crystal Report Logic, but by the way I got to know some oracle concept of concatenation.

Thanks Again !!

You're welcome.  Glad I could help.

 James