Problem in exporting report in CSV format

[Former Member]

Hi All,

I am using Crystal Reports. Following are details about it:

CR Developer

Product 8.5.0.217

*_Problem that I am facing:__*_

I can create report in .rpt format, it is working fine here. But while trying to export this report in CSV format, it gives report that doesn't contain any information.

Is it because I am missing something or it is a known issue?

Thanks and Regards,

Anand

[Former Member · Accepted solution]

Hi Anand

While exporting to .csv format check if 'Isolate Report/Page sections' and 'Isolate Group sections' is check marked.

And the best work around here is to export the report to excel format and save it as csv file.

Hope this helps you.

Please let us know if you have any further queries.

Regards

Ashwini Yadav

[Former Member · Accepted solution]

Hi,

I too am facing the same problem.

The report was made in 8.5. I have exported the report & opened it in Crystal report 12.

I can export to PDF, RTF, DOC & Tab separated Test.

However when I export this report in .csv (legacy mode) I just get the header & when I export it in .csv (Standard) I get a blanck .csv file.

I have checked 'Isolate Report/Page sections' and 'Isolate Group sections'. Still no data in the report.

refreshed it too.

I contains sub reports, but not in the page header & footer (I think) & it does not seem to have cross tabs & OLAP grids.

Any help is appreciated.

Links to Screenshots:

Main Report:

http://picasaweb.google.com/lh/photo/yM9sBexKt5jW9soqaMmHjw?feat=directlink

One of the Sub-Report:

http://picasaweb.google.com/lh/photo/0ofa5sABakvZ-nFZp-JSMw?feat=directlink

[fritzfeltus · Accepted solution]

If you have no fields in your details section, you will see nothing in the resulting CSV file when exporting.

Subreports are not supported with CSV export.

[Former Member · Accepted solution]

Hi, you mean to say if sub - reports are present in a main report & we export it to .csv it will give an error or will it create a blank .csv?

Also is there any documentation regarding this...because all I could find about .csv was a brief description about the format & that it did not support cross - tabs & OLAP grids.

Also my details sections contains info inside sub - reports. Is there any workaround for this. Coz I need the ability to export data to .csv. Will upgrading to latest version help?

[fritzfeltus · Accepted solution]

CSV export will not export any subreports, it will be blank. It doesn't matter where the subreport is placed. This is still the case for the latest version.

In order to export the data contained in the subreport, just open the subreport, and export from there.

[Former Member · Accepted solution]

Thanks....

[Former Member · Accepted solution]

Hi,

We tried to use a workaround.......Export to Excel 8 format & then convert it to *.csv using OLEDB.

However when we use the full report, the generated *.csv has only 4 columns i.e. data is missing whereas if we open the excel file, save it again & then create a *.csv file, then proper *.csv file is created.

Hence would like to know if there is a problem on the export dll side or are we missing some input parameters?

[Former Member · Accepted solution]

Hi Ganesh

We have certain limitation for exporting the report to .csv format.

Hence to export the report in excel, open it and then save it as .csv format works the best if we want ceratin functionality of reports in .csv format.

As you mentioned that you are exporting the report to excel 8 and then converting it to .csv directly, in this method we are not opening the exported report.

You can try changing the connection type as well.

Hope this helps you.

Regards

Ashwini Yadav