Solved

exporting to a csv

Posted on 2001-07-09
3
870 Views
Last Modified: 2008-02-01
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
0
Comment
Question by:caryma
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 3

Accepted Solution

by:
mathavra earned 30 total points
ID: 6267040
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
 

Author Comment

by:caryma
ID: 6269152
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
 
LVL 12

Expert Comment

by:DRRYAN3
ID: 6325196
caryma

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

DRRYAN3
0

Featured Post

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question