Crystal Reports 8.5 - printing data as a comma separated list 
Author Message
 Crystal Reports 8.5 - printing data as a comma separated list

I am using Crystal Reports 8.5 and would like to show the data in a
subreport as a comma separated list instead of individual records.

If the data returned looks like this:
x
y
z

I would like to print it on one line like this:
x, y, z

How can I achieve this?



Mon, 09 May 2005 04:47:13 GMT  
 Crystal Reports 8.5 - printing data as a comma separated list

Quote:

> I am using Crystal Reports 8.5 and would like to show the data in a
> subreport as a comma separated list instead of individual records.

> If the data returned looks like this:
> x
> y
> z

> I would like to print it on one line like this:
> x, y, z

> How can I achieve this?

the only idea i have is to create a formulafield like this:

{mytable,myfirstfield} + "," + {mytable,mysecondfield} + "," +
{mytable,mythirdfield} + ","     .... and so on

if you place that formulafield in the details-section of a
drilldown-report you will get CSV datasets, but each dataset in one line.
i suppose its impossible to get a "real" CSV list from a drilldown-
report, perhaps you can try to use the export function for that.

good luck



Mon, 09 May 2005 05:17:09 GMT  
 Crystal Reports 8.5 - printing data as a comma separated list
Are you trying to create a crosstab report?


Quote:
> I am using Crystal Reports 8.5 and would like to show the data in a
> subreport as a comma separated list instead of individual records.

> If the data returned looks like this:
> x
> y
> z

> I would like to print it on one line like this:
> x, y, z

> How can I achieve this?



Mon, 09 May 2005 10:03:04 GMT  
 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



Mon, 09 May 2005 23:10:50 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. Using Crystal 8.5 and VB6 -- need to get a list of fields available to the report

2. Crystal Reports 8.5 (VB6) to Crystal Reports NET (VB.NET) conversion

3. vb .net crystal reports not compatible with Crystal Reports 8.5

4. Crystal Reports 8.5 Runtime File List for VB packaging

5. Invert print order in Crystal Reports 8.5...

6. Crystal reports 8.5 and ODBC Data sources

7. ASP+Crystal Reports 8.5 Changing data source problem

8. printing without crystal report or data report for non data base reports

9. Running Crystal 8.5 Reports on Crystal 9 RAS

10. Help - Trending report in the Drill-Down style in Crystal Reports 8.5

11. how can I transfer the report from Access2000 to crystal report 8.5 or VB6.0

12. Create execution file for report of Crystal Report 8.5

 

 
Powered by phpBB® Forum Software