<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<title>TOTALS</title>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceType"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="State"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Alan,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> I tried your suggestion and it is a
beautiful thing. Does the trick<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>quite well. Thank you very much for your
input..<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> Cheers,<o:p></o:p></span></font></p>
<div>
<p><i><font size=4 color=fuchsia face="Times New Roman"><span style='font-size:
13.5pt;color:fuchsia;font-style:italic'>Barry Rogen</span></font></i><font
color=navy><span style='color:navy'> <br>
</span></font><i><font size=4 color=fuchsia><span style='font-size:13.5pt;
color:fuchsia;font-style:italic'>PNY Technologies, Inc.</span></font></i><font
color=navy><span style='color:navy'> <br>
</span></font><i><font size=4 color=fuchsia><span style='font-size:13.5pt;
color:fuchsia;font-style:italic'>Senior Programmer/Analyst</span></font></i><font
color=navy><span style='color:navy'> <br>
</span></font><i><font size=4 color=fuchsia><span style='font-size:13.5pt;
color:fuchsia;font-style:italic'>(973) 515 - 9700 ext 5327</span></font></i><font
color=navy><span style='color:navy'> <br>
</span></font><i><font size=4 color=fuchsia><span style='font-size:13.5pt;
color:fuchsia;font-style:italic'>brogen@pny.com</span></font></i><font
color=navy><span style='color:navy'> <o:p></o:p></span></font></p>
<p><i><font size=4 color=fuchsia face="Times New Roman"><span style='font-size:
13.5pt;color:fuchsia;font-style:italic'>-----------------------------------------------------</span></font></i><font
color=navy><span style='color:navy'> <br>
</span></font><i><font color=fuchsia><span style='color:fuchsia;font-style:
italic'>Far better it is to dare mighty things, to win </span></font></i><font
color=navy><span style='color:navy'><br>
</span></font><i><font color=fuchsia><span style='color:fuchsia;font-style:
italic'>glorious triumphs even though checkered by</span></font></i><font
color=navy><span style='color:navy'> <br>
</span></font><i><font color=fuchsia><span style='color:fuchsia;font-style:
italic'>failure, than to rank with those poor spirits who</span></font></i><font
color=navy><span style='color:navy'> <br>
</span></font><i><font color=fuchsia><span style='color:fuchsia;font-style:
italic'>neither enjoy nor suffer much because they live</span></font></i><font
color=navy><span style='color:navy'> <br>
</span></font><i><font color=fuchsia><span style='color:fuchsia;font-style:
italic'>in the gray twilight that knows neither victory</span></font></i><font
color=navy><span style='color:navy'> <br>
</span></font><i><font color=fuchsia><span style='color:fuchsia;font-style:
italic'>nor
defeat.
</span></font></i><i><font size=1 color=fuchsia><span style='font-size:7.5pt;
color:fuchsia;font-style:italic'>t. <st1:place w:st="on">roosevelt</st1:place></span></font></i><font
color=navy><span style='color:navy'> <br>
</span></font><i><font color=fuchsia><span style='color:fuchsia;font-style:
italic'>----------------------------------------------------------------</span></font></i><font
color=navy><span style='color:navy'> <o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
download-list-bounces@cedarville.edu
[mailto:download-list-bounces@cedarville.edu] <b><span style='font-weight:bold'>On
Behalf Of </span></b>Alan Topal<br>
<b><span style='font-weight:bold'>Sent:</span></b> Friday, October 20, 2006
9:57 AM<br>
<b><span style='font-weight:bold'>To:</span></b> Cedarville DOWNLOAD Users<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [Download-List]
TOTALS</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>I have gotten around this by putting the
appropriate number of LITERAL entries in the FOOTING.ON command. So
something like:</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>FOOTING.ON
FINAL\ <br>
LITERAL "GRAND TOTAL"\ <br>
LITERAL
""\ <br>
LITERAL
""\ <br>
LITERAL
""\ <br>
TOTAL SALES.AMT\ </span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>Alan Topal<br>
University Applications Development<br>
University at <st1:City w:st="on"><st1:place w:st="on">Albany</st1:place></st1:City>,<br>
<st1:PlaceType w:st="on">State</st1:PlaceType> <st1:PlaceType w:st="on">University</st1:PlaceType>
of <st1:State w:st="on"><st1:place w:st="on">New York</st1:place></st1:State><br>
MSC-100<br>
phone: 518-437-3832<br>
fax: 518-437-4540</span></font><font size=2 face=Tahoma><span style='font-size:
10.0pt;font-family:Tahoma'><o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face=Tahoma><span style='font-size:12.0pt;
font-family:Tahoma'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face=Tahoma><span style='font-size:12.0pt;
font-family:Tahoma'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'> -----Original Message-----<br>
<b><span style='font-weight:bold'>From:</span></b> download-list-bounces@cedarville.edu
[mailto:download-list-bounces@cedarville.edu]<b><span style='font-weight:bold'>On
Behalf Of </span></b><st1:PersonName w:st="on">Barry Rogen</st1:PersonName><br>
<b><span style='font-weight:bold'>Sent:</span></b> Friday, October 20, 2006
9:40 AM<br>
<b><span style='font-weight:bold'>To:</span></b> download-list@cedarville.edu<br>
<b><span style='font-weight:bold'>Subject:</span></b> [Download-List] TOTALS<o:p></o:p></span></font></p>
</div>
<blockquote style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt;
margin-left:3.75pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'><!-- Converted from text/rtf format -->
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>
Dear list,</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>
I am having problems with the FOOTING.ON command to show totals. The</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>problem
is column related. When the Excel spreadsheet (HTML) report is generated</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>the
spreadsheet will show to value amounts in (lets say) the 5<sup>th</sup></span></font>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>column.
However</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>when
there is a break.on total or a grand total, the value shows in the first
column</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>and
not the fifth. see what I am trying to say below. </span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Acct
Customer
Name
Sales Amt</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>12345
A B C
Plumbing
12,500.00</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>654321
C D E Electrical
10,500.00</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Grand
Total 23,000,00</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>and
not</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Grand
Total
23,500.00</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>How
can I get the FOOTING.ON break totals to appear in the proper</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>columns.</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'> Thank
you very much, in advance for your assistance !!!</span></font><o:p></o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p><a name=""><i><font size=4 color=fuchsia face="Times New Roman"><span
style='font-size:13.5pt;color:fuchsia;font-style:italic'>Barry Rogen</span></font></i></a><o:p></o:p></p>
<p><i><font size=4 color=fuchsia face="Times New Roman"><span style='font-size:
13.5pt;color:fuchsia;font-style:italic'>PNY Technologies, Inc.</span></font></i><o:p></o:p></p>
<p><i><font size=4 color=fuchsia face="Times New Roman"><span style='font-size:
13.5pt;color:fuchsia;font-style:italic'>Senior Programmer/Analyst</span></font></i><o:p></o:p></p>
<p><i><font size=4 color=fuchsia face="Times New Roman"><span style='font-size:
13.5pt;color:fuchsia;font-style:italic'>(973) 515 - 9700 ext 5327</span></font></i><o:p></o:p></p>
<p><i><font size=4 color=fuchsia face="Times New Roman"><span style='font-size:
13.5pt;color:fuchsia;font-style:italic'>brogen@pny.com</span></font></i><o:p></o:p></p>
<p><i><font size=4 color=fuchsia face="Times New Roman"><span style='font-size:
13.5pt;color:fuchsia;font-style:italic'>-----------------------------------------------------</span></font></i><o:p></o:p></p>
<p><i><font size=3 color=fuchsia face="Times New Roman"><span style='font-size:
12.0pt;color:fuchsia;font-style:italic'>Far better it is to dare mighty things,
to win </span></font></i><o:p></o:p></p>
<p><i><font size=3 color=fuchsia face="Times New Roman"><span style='font-size:
12.0pt;color:fuchsia;font-style:italic'>glorious triumphs even though checkered
by</span></font></i><o:p></o:p></p>
<p><i><font size=3 color=fuchsia face="Times New Roman"><span style='font-size:
12.0pt;color:fuchsia;font-style:italic'>failure, than to rank with those poor
spirits who</span></font></i><o:p></o:p></p>
<p><i><font size=3 color=fuchsia face="Times New Roman"><span style='font-size:
12.0pt;color:fuchsia;font-style:italic'>neither enjoy nor suffer much because
they live</span></font></i><o:p></o:p></p>
<p><i><font size=3 color=fuchsia face="Times New Roman"><span style='font-size:
12.0pt;color:fuchsia;font-style:italic'>in the gray twilight that knows neither
victory</span></font></i><o:p></o:p></p>
<p><i><font size=3 color=fuchsia face="Times New Roman"><span style='font-size:
12.0pt;color:fuchsia;font-style:italic'>nor
defeat. </span></font>
</i><i><font size=1 color=fuchsia><span style='font-size:7.5pt;color:fuchsia;
font-style:italic'>t. <st1:place w:st="on">roosevelt</st1:place></span></font></i><o:p></o:p></p>
<p><i><font size=3 color=fuchsia face="Times New Roman"><span style='font-size:
12.0pt;color:fuchsia;font-style:italic'>----------------------------------------------------------------</span></font></i><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</blockquote>
</div>
</body>
</html>