<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7650.28">
<TITLE>TOTALS</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<BR>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial"> Dear list,</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial"> I am having problems with the FOOTING.ON command to show totals. The</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">problem is column related. When the Excel spreadsheet (HTML) report is generated</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">the spreadsheet will show to value amounts in (lets say) the 5</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><SUP><FONT SIZE=2 FACE="Arial">th</FONT></SUP></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial"></FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"> <FONT SIZE=2 FACE="Arial">column. However</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">when there is a break.on total or a grand total, the value shows in the first column</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">and not the fifth. see what I am trying to say below. </FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">Acct Customer Name Sales Amt</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">12345 A B C Plumbing 12,500.00</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">654321 C D E Electrical 10,500.00</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">Grand Total 23,000,00</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">and not</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">Grand Total 23,500.00</FONT></SPAN></P>
<BR>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">How can I get the FOOTING.ON break totals to appear in the proper</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">columns.</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial"> Thank you very much, in advance for your assistance !!!</FONT></SPAN></P>
<BR>
<BR>
<P ALIGN=LEFT><I><SPAN LANG="en-us"></SPAN></I><A NAME=""><I><SPAN LANG="en-us"><FONT COLOR="#FF00FF" SIZE=4>Barry Rogen</FONT></SPAN></I></A></P>
<P ALIGN=LEFT><I><SPAN LANG="en-us"><FONT COLOR="#FF00FF" SIZE=4>PNY Technologies, Inc.</FONT></SPAN></I></P>
<P ALIGN=LEFT><I><SPAN LANG="en-us"><FONT COLOR="#FF00FF" SIZE=4>Senior Programmer/Analyst</FONT></SPAN></I></P>
<P ALIGN=LEFT><I><SPAN LANG="en-us"><FONT COLOR="#FF00FF" SIZE=4>(973) 515 - 9700 ext 5327</FONT></SPAN></I></P>
<P ALIGN=LEFT><I><SPAN LANG="en-us"><FONT COLOR="#FF00FF" SIZE=4>brogen@pny.com</FONT></SPAN></I></P>
<P ALIGN=LEFT><I><SPAN LANG="en-us"><FONT COLOR="#FF00FF" SIZE=4>-----------------------------------------------------</FONT></SPAN></I></P>
<P ALIGN=LEFT><I><SPAN LANG="en-us"><FONT COLOR="#FF00FF">Far better it is to dare mighty things, to win </FONT></SPAN></I></P>
<P ALIGN=LEFT><I><SPAN LANG="en-us"><FONT COLOR="#FF00FF">glorious triumphs even though checkered by</FONT></SPAN></I></P>
<P ALIGN=LEFT><I><SPAN LANG="en-us"><FONT COLOR="#FF00FF">failure, than to rank with those poor spirits who</FONT></SPAN></I></P>
<P ALIGN=LEFT><I><SPAN LANG="en-us"><FONT COLOR="#FF00FF">neither enjoy nor suffer much because they live</FONT></SPAN></I></P>
<P ALIGN=LEFT><I><SPAN LANG="en-us"><FONT COLOR="#FF00FF">in the gray twilight that knows neither victory</FONT></SPAN></I></P>
<P ALIGN=LEFT><I><SPAN LANG="en-us"><FONT COLOR="#FF00FF">nor defeat. </FONT></SPAN></I><SPAN LANG="en-us"><I></I></SPAN><SPAN LANG="en-us"><I></I></SPAN><I><SPAN LANG="en-us"> <FONT COLOR="#FF00FF" SIZE=1>t. roosevelt</FONT></SPAN></I></P>
<P ALIGN=LEFT><I><SPAN LANG="en-us"><FONT COLOR="#FF00FF">----------------------------------------------------------------</FONT></SPAN></I></P>
<BR>
<P ALIGN=LEFT><SPAN LANG="en-us"></SPAN></P>
</BODY>
</HTML>