Print Page | Close Window

Exporting to Excel

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
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=1156
Printed Date: 02 May 2025 at 12:28pm


Topic: Exporting to Excel
Posted By: dragon
Subject: Exporting to Excel
Date Posted: 09 Aug 2007 at 11:56pm
When programmatically exporting a CR to Excel the file created has extra blank cells, rows and columns. Does any one know how to export to an Excel file without these extra blanks? I have read some where that there is an "extended excel" format that produces a proper excel file but I don't know how to code it.
Also when I export to a pdf file the file created loses all the unicode formats, eg Chinese characters appear as rubbish. Anyone has ideas why this happens?
I am using Visual Studio .Net 2003


Replies:
Posted By: BrianBischof
Date Posted: 10 Aug 2007 at 12:08am
.NET 2003 doesn't have the new export features in CR XI. However, Excel exports get botched when things aren't lined up perfectly. It's very difficult to send report objects to a spreadsheet if it doesn't already look like a bunch of straight rows and columns. It also helps to use the guidelines and make everything snap to them. This helps keep them lined up.

Re the Chinese characters, I don't know about that.


-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Posted By: hilfy
Date Posted: 10 Aug 2007 at 1:33pm
My general rule of thumb when creating a report that I know is going to be exported to Excel is to align the left sides of the data and the column label and then to make them both the same size.  I do this by clicking on the data field, then shift-click on the column label and use the right-click menu that has options for align and size.
 
-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