?
Solved

Crystal Reports Export Options in Version 9

Posted on 2006-11-16
3
Medium Priority
?
827 Views
Last Modified: 2008-02-01
In Crystal version 8.5, there was an export option for "Character Seaparted Values".  I used it to create comma separted files because it worked better than the CSV export for what I was doing.  This option is no longer available in version 9.   I need a "layered" export.  That is a header line and one or more detail lines to immediately follow.  When I export using CSV the header and detail lines appear on the same line.  When I export to excel, everything is fine.  I want to eliminate the need to export to Excel and then save as CSV.  I have downloaded and installed service pack 7 for version 9, and there is no change.

Is there a solution to my problem?

Thanks,

Mike
0
Comment
Question by:mikebrennan
[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 13

Accepted Solution

by:
TommyTupa earned 1000 total points
ID: 17970430
Welcome to the world of post 8.5 formatting. In this world you'll find mostly clouds and gray skies.  At our company we still keep a version of 8.5 handy for certain formatting tasks. Most exports for customers and executives now go to pdf. Anything else is left very plain and simple to allow for easy export.  

As far as the topic at hand.   http://suport.businessobjects.com in kbase article c2014451 suggests the following.  


To resolve this issue, you must complete all 3 steps below:

1.Replace the report page header section with a group header that acts as a page header (see below).

2. Obtain the latest separated-values exporting DLL - U2fsepv.dll (see below).

3. If they do not already exist, create the registry subkeys suggested for your version of Crystal Reports, and then set the value for those registry subkeys. The possible values are listed below.

------ REPLACE THE REPORT PAGE HEADER SECTION ------

To replace the page header section with a group header that acts as a page header, follow these steps:

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

Formula 1:
//@Fake PH
WhileReadingRecords;

1

Formula 2:
//@False Group
WhileReadingRecords;

2

2. On the 'Insert' menu, click 'Group', create a group based on the @Fake PH formula, and select the 'Repeat Group Header on Each Page' check box.

3. Insert a second group based on @False Group. Do not select the 'Repeat Group Header on Each Page' check box.

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. In Crystal Reports 8.5 and earlier, click 'Report' and then click 'Section'.

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.
0

Featured Post

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

In our personal lives, we have well-designed consumer apps to delight us and make even the most complex transactions simple. Many enterprise applications, however, are a bit behind the times. For an enterprise app to be successful in today's tech wo…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

777 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