[Download-List] TOTALS

[Barry Rogen]

   Dear   list,

        I am having problems with the FOOTING.ON  command to show
totals. The
problem is column related. When the Excel spreadsheet (HTML)  report is
generated
the spreadsheet will show to value amounts in (lets say)  the 5th
column. However
when  there is a break.on total  or a grand total, the value shows in
the first column
and not the fifth. see what I am trying to say below. 

Acct   Customer Name                                        Sales Amt
12345  A B C  Plumbing                                      12,500.00
654321 C D E  Electrical                                      10,500.00
Grand Total  23,000,00

and not
Grand Total
23,500.00


How can I get the FOOTING.ON  break totals to appear in the proper
columns.

 Thank you very much, in advance for your assistance !!!



Barry  Rogen
PNY Technologies, Inc.
Senior  Programmer/Analyst
(973)  515 - 9700  ext 5327
brogen at pny.com

-----------------------------------------------------
Far better it is to dare mighty things, to win 
glorious triumphs even though checkered by
failure, than to rank with those poor spirits who
neither enjoy nor suffer much because they live
in the gray twilight that knows neither victory
nor defeat.                t. roosevelt
----------------------------------------------------------------



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20061020/29bb6635/attachment.html>