Joined: 02 Nov 2011
Online Status: Offline
Posts: 24
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!
Joined: 08 Nov 2011
Location: United States
Online Status: Offline
Posts: 53
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.
Joined: 08 Nov 2011
Location: United States
Online Status: Offline
Posts: 53
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.
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
IP Logged
