
Crystal Reports 8.5 - printing data as a comma separated list
Quote:
> Are you trying to create a crosstab report?
The main report is just columns of data from a single data table:
FieldA FieldB FieldC FieldD
--------- --------- --------- --------
Record1
Record2
Record3
I would like to show a "FieldE" that has data from another table.
This data would be all of the values from a single field that relate
to each record on the main report, in comma-separated format. For
example, if I did a SQL statement to get the related data:
"SELECT DataField FROM RelatedDataTable WHERE FieldA = 'Record1'"
It would return:
DataField
---------
x
y
z
And I would like to display this data in the main report like this:
FieldA FieldB FieldC FieldD FieldE
--------- --------- --------- --------- ------------
Record1 x, y, z
Record2
Record3