Export to CSV Format

[techie2]

Hi,

Using CR 8.5, CE 8.5, SQL Server 2000.

Written a report which points to SP in SQL Server.

When exported (With some data in report) in CSV format, it works fine.

When exported (When there is no data in report), it display 1 line like following:
"","","","","","",""

I have tried couple of things but can not get rid of this line for empty report.

Report pulls 0 records but still it exports as "","","","","","","".

I have also tried "supress blank sections".

When exporting, I have selected both the check boxes "Same number formats" and same date formats".

I am using the CMC to schedule report which exports to CSV format FTPing to specific location. Output of these reports become the source of an automated programme.

Same scenario is happening both in CR and CE.

I have also tried following:
I did try File->Report Options->Suppress Printing If No Records, but it did not help.
Also, I am using "," as the Charater Seperetaed value and " as delimiter in CMC while scheduling.

Any thoughts.

V

 

[SomeHelp]

I have had problems using Crystal's CSV export and have found the best way around these types of problems is to manually create comma separated values using Crystal's Text export along with a formula in the report. You can create a formula field in your report which appends all fields of your report together as follows field1+","+field2+","+ ... fieldn. This will create your CSV file, but you will be using the Text export driver which does not have some of the side effects the CSV export driver does.

I hope this helps...

 

[techie2]

Thanks.

V