Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CSV export ignores conditional suppression

Status
Not open for further replies.

Madawc

Programmer
Sep 5, 2002
7,628
GB
I have a report that I need to export as CSV, for further processing. I decided to use a standard trick, use a parameter to define two modes of running. One has headers and is readable, suitable to be exported in its readable form for future reference. The other mode suppresses headers and is suitable for CSV, without including the headers on every single row.

Unfortunately, CSV ignored the conditional suppression and included the headers. Not what I was after.

Obviously I could overcome this by having two separate versions of the report, or by exporting as Text rather than CSV. But is there any simpler way round?

I use Crystal 10 from an SQL database on a Windows XP Professional machine.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Seems there is no simpler way, and I've now found a document that lists it as one of the limits of Crystal 10 exports to CSV.

I got round it by creating one big field that shows the fields separated by commas. Exported as text, it can be used much like a comma-delimited file.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top