Issue with CSV format

[priyanthan]

I have a report with a subreport, where i'm bringing a value from the sub report to the main report by using the shared variables. Everything works fine but when i export to csv format, all values are present expect the the value that i brought from the sub report.
Its works fine with other export formats.
Can anyone help me with this.

working with DB2 and CR 8.5

Thanks

 

[Madawc]

I've had trouble before with cvs export, though not the same trouble as you report. One option is to have a single large formula field that strings together all of the values and puts commas between them. The result can be exported as text, but then treated as a CVS file.

Does this help?

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[priyanthan]

thanks for replaying,

the idea kind if works but the issue is,i have a lot of fields in my reports and the string is not completely showing up in the text file that i'm exporting. I guess i cannot do this way.

any other thoughts?

 

[chelseatech]

Our Grid UFL can build a CSV file while the report is procesing. You have total control over every cell (column/row) in the file.

And it works well with subreports.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm