Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Export report to Excel without header Post Reply Post New Topic
Author Message
sophieTaureau
Newbie
Newbie


Joined: 26 Jan 2012
Online Status: Offline
Posts: 17
Quote sophieTaureau Replybullet Topic: Export report to Excel without header
     Posted: 01 Feb 2012 at 3:16am
Hi
I want to know how I can export the CR report into Excel with juste one time header, not repeat header each 20 rows
 
Thanks very much
IP IP Logged
sgtjim
Newbie
Newbie
Avatar

Joined: 23 Aug 2011
Online Status: Offline
Posts: 32
Quote sgtjim Replybullet Posted: 01 Feb 2012 at 5:30am
Fist make sure that you header text formula or whatever is either in the report header or a page header. If what you want to display is in a group header then it will repeat.

Then go File > Export > Export Report
Use;
Format: Microsoft Excel (97-2003) Data Only

Excel Format: "Custom: Data is exported according to selected options"

Then only have these two boxes checked at the bottom of the "Excel Format Options"
"Export Object Formatting"
&
"Export page headers and page footer."

A couple of tips when formatting for excel. Have a blank header between the "header" section and your data. Your data header and data should all be the same width and line up, this makes things a lot easier for the export to come out looking decent.

Header Info ------------------
(Blank Header)
Customer Name Customer ID   Price
------------- ------------- ------------
IP IP Logged
sophieTaureau
Newbie
Newbie


Joined: 26 Jan 2012
Online Status: Offline
Posts: 17
Quote sophieTaureau Replybullet Posted: 01 Feb 2012 at 11:37pm

Thank you very much, sgtjim it's good idea

IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum