Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports .NET 2003 : Report Design
Message Icon Topic: Exporting to Excel Post Reply Post New Topic
Author Message
dragon
Newbie
Newbie


Joined: 07 Aug 2007
Location: Australia
Online Status: Offline
Posts: 2
Quote dragon Replybullet Topic: Exporting to Excel
    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
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet 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>
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet 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
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.