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 Offline
Adagio Wizard

Registered: 06/15/04
Posts: 3641
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 (), 80 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1872 Members
5 Forums
14527 Topics
70937 Posts

Max Online: 432 @ 01/20/25 10:17 PM
August
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