<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>TOTALS</TITLE>
<META content="MSHTML 6.00.2800.1561" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=953465013-20102006><FONT face=Arial color=#0000ff size=2>I have
gotten around this by putting the appropriate number of LITERAL entries in
the FOOTING.ON command. So something like:</FONT></SPAN></DIV>
<DIV><SPAN class=953465013-20102006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=953465013-20102006><FONT face=Arial color=#0000ff
size=2>FOOTING.ON
FINAL\ <BR>
LITERAL "GRAND
TOTAL"\ <BR>
LITERAL
""\ <BR>
LITERAL
""\ <BR>
LITERAL
""\ <BR>
TOTAL SALES.AMT\ </FONT></SPAN></DIV>
<DIV><FONT face=Tahoma><FONT size=2><FONT face=Arial
color=#0000ff></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Tahoma><FONT size=2><FONT face=Arial
color=#0000ff></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Tahoma><FONT size=2><FONT face=Arial color=#0000ff>Alan
Topal<BR>University Applications Development<BR>University at Albany,<BR>State
University of New York<BR>MSC-100<BR>phone: 518-437-3832<BR>fax:
518-437-4540<BR></FONT></DIV></FONT>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT size=2><SPAN class=953465013-20102006></SPAN></FONT> </DIV>
<DIV><FONT size=2><SPAN class=953465013-20102006> </SPAN>-----Original
Message-----<BR><B>From:</B> download-list-bounces@cedarville.edu
[mailto:download-list-bounces@cedarville.edu]<B>On Behalf Of </B>Barry
Rogen<BR><B>Sent:</B> Friday, October 20, 2006 9:40 AM<BR><B>To:</B>
download-list@cedarville.edu<BR><B>Subject:</B> [Download-List]
TOTALS<BR><BR></DIV></FONT></FONT>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px"><!-- Converted from text/rtf format --><BR>
<P align=left><SPAN lang=en-us><FONT face=Arial size=2>
Dear list,</FONT></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial
size=2> I am having problems with
the FOOTING.ON command to show totals. The</FONT></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial size=2>problem is column
related. When the Excel spreadsheet (HTML) report is
generated</FONT></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial size=2>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 face=Arial
size=2>th</FONT></SUP></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT
face=Arial size=2></FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us>
<FONT face=Arial size=2>column. However</FONT></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial size=2>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 face=Arial size=2>and not the fifth. see
what I am trying to say below. </FONT></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial size=2>Acct
Customer
Name
Sales Amt</FONT></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial size=2>12345 A B C
Plumbing
12,500.00</FONT></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial size=2>654321 C D E
Electrical
10,500.00</FONT></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial size=2>Grand Total
23,000,00</FONT></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial size=2>and
not</FONT></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial size=2>Grand
Total
23,500.00</FONT></SPAN></P><BR>
<P align=left><SPAN lang=en-us><FONT face=Arial size=2>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 face=Arial
size=2>columns.</FONT></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial size=2> 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></BLOCKQUOTE></BODY></HTML>