Print Page | Close Window

Blank lines after every record.

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
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=6035
Printed Date: 02 May 2024 at 4:19am


Topic: Blank lines after every record.
Posted By: sireev
Subject: Blank lines after every record.
Date Posted: 08 Apr 2009 at 1:31pm
Hi,
 
I am using Crystal 8.5 and created a report.When I export it to Excel,I see a blank line after every record.How can I get rid of these blank lines after every record.
 
Please note that I do not have the Microsoft Excel 97-2000(XLS) and Microsoft Excel 97-2000(Data Only) (XLS) options as I am on an older version of crystal.I ahve only Excel 5.0, Excel 5.0(Extended),Excel 7.0, Excel 7.0(Extended),Excel 8.0, Excel 8.0(Extended)
 
Any suggestions?
 



Replies:
Posted By: SDB2
Date Posted: 08 Apr 2009 at 2:32pm
I've had this happen because of the space after the details section. Try dragging the line directly below the details section in the design view of your report. If not, try suppressing any group footers, etc that might be displaying in your report


Posted By: ashisahb
Date Posted: 08 Apr 2009 at 11:05pm
Hi....
 
Drag your details section a bit up side so that the width must be (-.030) to( -.040) , your problem will go for sure.


-------------
Regards,
Ashish


Posted By: sireev
Date Posted: 09 Apr 2009 at 6:48am
Thank you folks.That worked.I had an extra detail section that I failed to see somehow.Once I removed it and moved up my footer a little bit,the blank lines have gone away.
 
I appreciate your help and suggestions.
 
Thank you,
Sireesha.



Print Page | Close Window