Topic Options
#8468 - 02/22/07 01:10 PM Export To Excel
Anonymous
Unregistered


When using AR, I export an Aged trial balance report into Microsoft Excel but the columns are all messed up.

Customer name is out by 2 columns as well as many other problems.

Is this a known issue?
What version of excel will give me the desired output?
Thanks

Top
#8470 - 02/22/07 03:49 PM Re: Export To Excel [Re: ]
Bruce Gardner Online   content
Adagio Wizard

Registered: 06/15/04
Posts: 3646
Loc: Toronto ON, Canada
Printing a report to Excel is never guaranteed to be perfect. If you picture a printed report, the Detail section lends itself to Excel reasonably well because it is mostly a series of columns. But the header and footer are not columnar. When Crystal inserts those sections, the columns in Excel start to become disorganized.

If you need to work with the data in organized columns, GridView does a much better job.
_________________________
Bruce Gardner
ARX Business Solutions Inc.

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 267 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1873 Members
5 Forums
14552 Topics
71029 Posts

Max Online: 432 @ 01/20/25 10:17 PM
October
Su M Tu W Th F Sa
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31