exporting to a csv

I am trying to export out of Crystal Reports to a csv file and when I export my Report Header and Report Footer gets put on every record and I want it to just be displayed at the begining and my footer has sum totals and I want it to be displayed as the last record.   If you need more explanation I can send you the layout that I have and how I want it to be displayed.

 Caryma
carymaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mathavraConnect With a Mentor Commented:
Hope this helps!.

How can you format a report for export to CSV so the page header information appears only at the beginning of the CSV file?

NOTE:======

This resolution requires the version 8.0.0.8 of the exporting DLL 'U2fsepv.dll'. To verify your version of this file:

? Search the Windows\Crystal or Winnt\Crystal folder for 'U2fsepv.dll'.

? Right-click the filename, and then click 'Properties'. The 'Properties' dialog box appears.

? On the 'Version' tab, check the version number.

If you have a version previous to 8.0.0.8, contact Technical Support at 669-8379 to obtain version 8.0.0.8.

============


1. On the 'Insert' menu, click 'Formula Field', and create these two formulas:

//@Fake PH
   
   WhileReadingRecords;
      1



//@False Group
      WhileReadingRecords;
      2

2. On the 'Insert' menu, click 'Group', and create a group based on the @Fake PH formula.

3. Insert a second group based on @False Group.

Make sure that group# 1 is based on @Fake PH, and that group#2 is based on @False Group.

4. Move the contents of the page header section into the group header #1 section (the @Fake PH group header).

The easiest way to move several objects from one section to another is to draw a lasso around the objects with your mouse to select them. Once selected, you can move them to another section.

5. On the 'Format' menu, click 'Section'. The 'Section Expert' dialog box appears.

6. In the 'Sections' list, select the page header section, and then select the 'Suppress' checkbox.

7. Repeat step 6 for the group footer #1, group header #2, and group footer #2 sections.

8. Click 'OK' to return to the report.


The next time you export the report, this formatting ensures there is only one header line at the beginning of the CSV file.

0
 
carymaAuthor Commented:
Thanks that helped a lot but when I export my totals that are at the report footer it appends it to the last record instead of making it the last record.  It is still better than before cause it was appending it to every record.  Is there somewhere I should place those fields as well?

caryma
0
 
DRRYAN3Commented:
caryma

Do you still have this problem?  Do you need additional information?  Let us know.

DRRYAN3
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.