Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: exporting to Excel - messy Post Reply Post New Topic
Author Message
aaml216
Newbie
Newbie
Avatar

Joined: 02 Nov 2011
Online Status: Offline
Posts: 24
Quote aaml216 Replybullet Topic: exporting to Excel - messy
    Posted: 21 Dec 2011 at 5:59am

When I export a basic report to Excel (say, 10 fields), it takes some work to get it into a nice clean spreadsheet for further analysis.  I have to unmerge the columns (not sure why), delete empty columns, and sort by the ID to push all the many interspersed empty rows to the bottom.  Is there something I can be doing in Design mode to make for a cleaner export?  Thanks!
Amanda from the Mid-Atlantic
IP IP Logged
kostya1122
Senior Member
Senior Member
Avatar

Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Quote kostya1122 Replybullet Posted: 21 Dec 2011 at 1:04pm
TRY EXPORTING USING DATA ONLY (XLS) OPTION
IP IP Logged
aaml216
Newbie
Newbie
Avatar

Joined: 02 Nov 2011
Online Status: Offline
Posts: 24
Quote aaml216 Replybullet Posted: 22 Dec 2011 at 5:25am
Thank you!!!
Amanda from the Mid-Atlantic
IP IP Logged
dbodell
Groupie
Groupie
Avatar

Joined: 08 Nov 2011
Location: United States
Online Status: Offline
Posts: 53
Quote dbodell Replybullet Posted: 24 Jan 2012 at 6:40am
Actually instead of exporting as a CSV, what you want to do is to carefully align all of your fields to a grid using the ruler and alignment markers. So if you have a report with multiple columns of numbers, for example, you would have a field starting at the left edge and going to about 1.5 inches. Then you would have your second column start at 1.5 inches and go to 3 inches and so forth. If you need space between two columns, add an empty text field that takes up the space and put it between the two alignment markers. All headings and footers should also have their fields aligned to specific markers. It works beautifully that way (if you can call excel exports beautiful) and allows you to export the report looking like a report with all the formatting.  If you need help or an example, please don't hesitate to ask. It really is pretty straightforward.
Thanks,
D. Bodell
IP IP Logged
aaml216
Newbie
Newbie
Avatar

Joined: 02 Nov 2011
Online Status: Offline
Posts: 24
Quote aaml216 Replybullet Posted: 24 Jan 2012 at 6:56am
An example would be great, thanks!!
Amanda from the Mid-Atlantic
IP IP Logged
dbodell
Groupie
Groupie
Avatar

Joined: 08 Nov 2011
Location: United States
Online Status: Offline
Posts: 53
Quote dbodell Replybullet Posted: 24 Jan 2012 at 9:31am
Amanda, please send me an email where I can send instructions. I am having trouble posting pictures into my reply here. My email is dbodell@innovativecg.com.
 


 


 




Edited by dbodell - 24 Jan 2012 at 9:31am
Thanks,
D. Bodell
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.