Print Page | Close Window

exporting to Excel - messy

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=15209
Printed Date: 02 May 2024 at 7:28am


Topic: exporting to Excel - messy
Posted By: aaml216
Subject: exporting to Excel - messy
Date 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


Replies:
Posted By: kostya1122
Date Posted: 21 Dec 2011 at 1:04pm
TRY EXPORTING USING DATA ONLY (XLS) OPTION

Posted By: aaml216
Date Posted: 22 Dec 2011 at 5:25am
Thank you!!!

-------------
Amanda from the Mid-Atlantic

Posted By: dbodell
Date 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

Posted By: aaml216
Date Posted: 24 Jan 2012 at 6:56am
An example would be great, thanks!!

-------------
Amanda from the Mid-Atlantic

Posted By: dbodell
Date 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 mailto:dbodell@innovativecg.com - dbodell@innovativecg.com .
 


 


 




-------------
Thanks,
D. Bodell


Print Page | Close Window