Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Blank lines in export to Excel Post Reply Post New Topic
Author Message
bazzerp
Newbie
Newbie


Joined: 23 Jan 2009
Location: United Kingdom
Online Status: Offline
Posts: 9
Quote bazzerp Replybullet Topic: Blank lines in export to Excel
    Posted: 08 Sep 2010 at 6:02am
I have a Crystal report which has the detail section suppressed - there is nothing in it anyway. I have a group footer with some summary data. It is this data the users are interested in. This footer is repeated for every change of the group value (obviously!).
 
When I run the report it looks lovely!
 
However when I export to Excel there is a blank line before every summary line.
 
How can I prevent this blank line in the export?
 
 
IP IP Logged
Emir_W
Senior Member
Senior Member
Avatar

Joined: 25 Apr 2010
Online Status: Offline
Posts: 228
Quote Emir_W Replybullet Posted: 08 Sep 2010 at 9:27pm
- make sure other section are suppressed/hide
- when you export to excel, you can select 'Minimal' or 'Custom' (e.g.: Export object formatting, Maintain column alignment, etc)
 
 
 
hope it help.
Emir W
IP IP Logged
bazzerp
Newbie
Newbie


Joined: 23 Jan 2009
Location: United Kingdom
Online Status: Offline
Posts: 9
Quote bazzerp Replybullet Posted: 10 Sep 2010 at 12:29am
Thanks for that.
 
I had the problem because I wasn't using the 'Excel data-only' option.
 
In this case it solves the issue as the users are happy to forego the formatting and pretty header.
 
I guess there is no solution if they did want the formatting.
IP IP Logged
Post Reply Post New Topic
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



This page was generated in 0.031 seconds.