Topic Options
#3672 - 10/21/03 02:52 AM Re: Transfer to Excel
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Hello Louise,

Are you using Adagio Ledger or Adagio FX? Are you transfering the statement to Excel using File | Export to Excel or the ExcelDirect button? (You will often find that the ExcelDirect export is better.) Are the grand total lines formatted as "Hide when printed"? If so, then they will be exported, but the rows will be hidden in the Excel sheet.


Top
#3673 - 10/21/03 02:55 AM Re: Transfer to Excel
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11616
Loc: Vancouver, BC Canada
Hi Louise,

In the financial statement you created in Adagio FX, do you have the toolbar button 'Suppress zeroes' selected? This toolbar button looks like a red circle with diagonal line through it. The purpose of this of this button is to suppress rows where the numeric values of all columns are zero. This feature affects not only print and preview but also Export to Excel.

If you preview your report, are the grand totals similarly suppressed? If so then try again without this toolbar button toggled on.

Another similar row format is called 'Hide when Printed'. This allows information to be viewable on the report design screen but will not appear on the printed report. This also include exporting to Excel. Rows or columns with this format will have a light blue colour on the design screen. If you preview the report you should see rows like this suppressed, and similarly these rows are not exported to Excel.

If your Grand totals appear on the report Print Preview screen but are not exported to Excel, then something else unexpected is occuring.


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