Print Page | Close Window

Column headers shift when exporting

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=12827
Printed Date: 05 May 2024 at 8:54pm


Topic: Column headers shift when exporting
Posted By: rbescos
Subject: Column headers shift when exporting
Date Posted: 06 Apr 2011 at 7:07am

Whenever I insert a field between two existing fields in my report, my column headers seem to shift when I export to Excel (data only).  Is there any way to prevent this from happening?


Replies:
Posted By: hilfy
Date Posted: 06 Apr 2011 at 9:42am
In order to export to Excel cleanly, your column headers and column data MUST be the exact same width AND the left side of everything in the column MUST line up.  Any deviation in either size or position means you risk your data not lining up when exported.
 
-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