Blank lines in export to Excel
Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=11065
Printed Date: 05 May 2024 at 3:58am
Topic: Blank lines in export to Excel
Posted By: bazzerp
Subject: Blank lines in export to Excel
Date 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?
|
Replies:
Posted By: Emir_W
Date 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 |
Posted By: bazzerp
Date 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.
|