cancel
Showing results for 
Search instead for 
Did you mean: 

Exporting Crystal report to csv

former_member1012208
Participant
0 Kudos

I have created a report with one line in the header section and the rest of the information is shown in detail. I have surpressed the rest of the sections. When I export this to Seperated values (CSV), for each detail line, Crystal inserts the header record. If I don't import the header, Crystal inserts many blank lines between records. Is there any way to eliminate this and print only the header once at the top of the page and print the details?

Any help is greatly appreciated.

Accepted Solutions (1)

Accepted Solutions (1)

saurabh_pathak
Active Contributor
0 Kudos

Hi,

Is this related to designer or custom app?

If this deal with .NET SDK then please go through:

/people/ludek.uher/blog/2008/11/24/what-do-i-need-to-do-to-get-the-fastest-issue-resolution

If designer you might want to post it here:

Thanks,

Saurabh

former_member183750
Active Contributor
0 Kudos

Hi Don:

Please see if the following Kbase helps:

[1586586 - Exporting to character-separated value (CSV) format, Page Header appears at the beginning of each record|http://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes_boj/sdn_oss_boj_bi/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/scn_bosap/notes%7B6163636573733d36393736354636443646363436353344333933393338323636393736354637333631373036453646373436353733354636453735364436323635373233443330333033303331333533383336333533383336%7D.do].

- Ludek

former_member1012208
Participant
0 Kudos

Thanks for the reply. I tried your suggession, but that doesn't work.

former_member183750
Active Contributor
0 Kudos

What version of CR?

What CR updates?

What version of .NET?

Web or win app?

Are you able to get the correct export from the CR designer?

- Ludek

former_member1012208
Participant
0 Kudos

Message: What version of CR?

Crystal reports 2008

What CR updates?

SP3

What version of .NET?

VS2005

Web or win app?

Web

Are you able to get the correct export from the CR designer?

No, get the same result

former_member183750
Active Contributor
0 Kudos

Perhaps this is due to report differences, etc. I have used a relatively simple report and the export for that report works in both the CR designer and CR .NET SDK.

If the report you are working with does not export correctly in the designer, then it will not export correctly using the SDK. Asking in the [Report Design|; forum why this report is behaving as it is should be the first place to start.

- Ludek

Edited by: Ludek Uher on May 12, 2011 10:35 AM

former_member1012208
Participant
0 Kudos

I think I found out what the problem was. In my report's detail section, I surpress it for certain values. When I enport this into csv, system inserts blank lines for this. If I remove the surpress option, everything wosk as they should.

Answers (0)