Active TopicsMemberlistSearchHelpRegisterLogin

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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.