Question Re: Problem in exporting report in CSV format in Technology Q&A

Problem in exporting report in CSV format

Former Member — Fri, 12 Dec 2008 11:06:04 GMT

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

Re: Problem in exporting report in CSV format

Former Member — Fri, 12 Dec 2008 14:32:55 GMT

Hi Anand,

Make sure that the report is refreshed at least once so that the data is fetched into the report.

Observe the behavior by exporting to the other formats like PDF and word as well.

The csv format can not be used to exports with cross-tabs or OLAP grids, nor can it be used to export reports with sub-reports in Page Header or Page Footer sections.

Hope this helps

Regards,

Aditya Joshi

Re: Problem in exporting report in CSV format

Former Member — Fri, 12 Dec 2008 14:40:14 GMT

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

Re: Problem in exporting report in CSV format

Former Member — Fri, 19 Dec 2008 06:14:22 GMT

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

Re: Problem in exporting report in CSV format

fritzfeltus — Fri, 19 Dec 2008 12:17:53 GMT

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.

Re: Problem in exporting report in CSV format

Former Member — Sat, 20 Dec 2008 04:58:31 GMT

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?

Re: Problem in exporting report in CSV format

fritzfeltus — Mon, 22 Dec 2008 11:59:38 GMT

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.

Re: Problem in exporting report in CSV format

Former Member — Mon, 22 Dec 2008 15:36:12 GMT

Thanks....

Re: Problem in exporting report in CSV format

Former Member — Tue, 27 Jan 2009 13:29:36 GMT

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?

Re: Problem in exporting report in CSV format

Former Member — Tue, 27 Jan 2009 13:41:10 GMT

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