Print Page | Close Window

Formatting in 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=7568
Printed Date: 14 May 2024 at 9:02am


Topic: Formatting in Excel
Posted By: cwhitmore
Subject: Formatting in Excel
Date Posted: 02 Sep 2009 at 9:02am
Hi ,
 
I created a report with CR 8.5 that is exported to excel. the problem i have is when i open the report in excel extra rows appear. The design of the report has four field line vertically under each other. There are no spaces between the fields. But whe i open report in excel there is an extra space between the 2nd and 3rd field. So in CR it loks like
Field1
Field2
Field3
Field4
 
But in excel it looks like
 
Field1
Field2
 
Field3
Field4
 
Any ideas on how to get rid of the extra line?
 
Thanks,
 
Cecil


Replies:
Posted By: hilfy
Date Posted: 02 Sep 2009 at 3:54pm
The Excel Export in Crystal has always been problematic.  Try making sure that all of your fields are aligned on the left and that they are all exactly the same width, with CanGrow turned off.  This may or may not help, but it's a technique I've found that is pretty reliable for this kind of export.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window