Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Exporting report to CSV in Crystal Report XI - too many headers

Status
Not open for further replies.

handle1134

Programmer
Jul 20, 2006
24
RO
Hi

When I export in CSV format (read with Excel), from Crystal Reports XI (11.5) I get the Report Header and Page Header for every record.

ReportHeader, PageHeader, "Column1", "Column2", "Value11", "Value12"
ReportHeader, PageHeader, "Column1", "Column2", "Value21", "Value22"
ReportHeader, PageHeader, "Column1", "Column2", "Value31", "Value32"

And all I need is:

ReportHeader
PageHeader
"Column1", "Column2"
"Value11", "Value12"
"Value21", "Value22"
"Value31", "Value32"
...and so on

On the forum I've seen this problem several times, including the link:


where they say this behavior occurs when using u2fsepv.dll version 9.2.1.32.
I did all it says (setting up the page and group fake headers, and registry keys) and still nothing has changed. And my u2fsepv.dll version is 11.5.0.313, and I couldnt find anything newer.

Do you have any u2fsepv.dll higher than 11.5?
Or, if this is not the issue, how can i solve this?

10x

Crystal Reports XI
Microsoft Office Excel 2003
JDBC on Oracle 10
Windows XP
 
Why are you creating a CSV to be read by Excel?

A CSV is a standard format which may or may not have a SINGLE header, and then all of the data.

WHat you seek is a custom text output with multiple headers, so just export to Excel format, it'll be much simpler.

-k
 
I mentioned Excel because I use it to see if the csv file displays corectly. The CSV format is required by the report specifications.
The problem is that the csv file generated by Excel (I export first to Excel, xls format, and after that save as csv file) is not the same with the csv exported directly by Crystal Reports.
In obtaining the CSV format (the one with only one header, in case there are some other types), its unusual to use Excel as an intermediate step. I simply want Crystal Reports to export the CSV file as needed (as shown before), with a single header.
Is this possible? Can I choose between multiple CSV formats?
The given options are delimiter, separator, mode (standard/legacy) and export the report and page sections.
Is there any combinations of these generates the desired format?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top