How to export to CSV file from Crystal Report 2008
Posted on 2009-04-08
I have a CR 2008 report which selects a record for 'parents contact details' from a SQL view. Details section Da will display father details and details section Db will display mother details from the one record in the view. Detail section a or b are conditionally suppressed if there are no details for either father or mother so no blank records are exported to the CSV file.
Two problems here, when I export to CSV file the Db section will be on the same line as the Da section instead of on the next line. Also for each section that has been suppressed I still get the comma seperators eg: ,,,, for each field on that suppressed record. I rushed out to buy CR 2008 because I was told this would do the export to CSV much better than CR10, this is becoming critical and I still have problems .
thanks for any assistance you can give.....