Print Page | Close Window

Exporting to Excel in Crystal Reports

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=18037
Printed Date: 03 May 2024 at 7:12am


Topic: Exporting to Excel in Crystal Reports
Posted By: Madhansamy
Subject: Exporting to Excel in Crystal Reports
Date Posted: 20 Nov 2012 at 1:51am
During the crystal report design, the text fields are arranged one after the another with proper line spacing. when we export to Excel format,the alignment in the Excel is having the line spacing that was given in Desing as an Empty Row each with different heights.How to make the report more professional by proper line spacing between each sections in the crystal report.Please recommend the possible ways to avoid this formatting issue in Excel.


Replies:
Posted By: hilfy
Date Posted: 28 Nov 2012 at 3:53am
If you have access to Facebook, see the note that I wrote on this subject here:
 
http://on.fb.me/RddYL9 - http://on.fb.me/RddYL9
 
Basically, not only do you have to line up your columns, you also have to make sure that all of your objects in a section are lined up and are the same height.  If you need spaces between rows, use an separate blank section in Crystal.
 
-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