Print Page | Close Window

Problem with Export To Excel functionality.

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Writing Code
Forum Discription: .NET programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19842
Printed Date: 30 Apr 2024 at 2:53pm


Topic: Problem with Export To Excel functionality.
Posted By: Bhanu Prakash T
Subject: Problem with Export To Excel functionality.
Date Posted: 01 Aug 2013 at 12:47am
Hi,

We are using Visual Studio 2008 Crystal Reports. "Export to PDF" is generated correct but while doing "Export to Excel" some of the columns / column headings in the generated excel sheet are displayed incorrect or interchanged like
1. 6th column heading is displayed in 10th column heading
2. 4th column heading is displayed in 5th column heading

We are using "CrystalDecisions.Shared.ExportFormatType.ExcelRecord" format.

Any solution to this problem ?


Thanks
Bhanu.


Replies:
Posted By: hilfy
Date Posted: 07 Aug 2013 at 5:05am
The Excel export is VERY picky about formatting.  A couple years ago I wrote an article for the SAP Crystal Reports and Dashboard Design Facebook page on how to format a report for exporting to Excel.  You can find it here:
 
https://www.facebook.com/#!/notes/sap-crystal-reports-and-dashboard-solutions/formatting-a-crystal-report-for-export-to-ms-excel/431695651872 - https://www.facebook.com/#!/notes/sap-crystal-reports-and-dashboard-solutions/formatting-a-crystal-report-for-export-to-ms-excel/431695651872
 
-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