count
Michael Lee
Michael.Lee@mclsystemsinc.com
Tue, 18 Jan 2005 09:03:24 -0800
This is a multi-part message in MIME format.
--------------070905070807080202040009
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
You are right Eric, but in Kristina's case the program is sorting on a
value that is always '1' and therefore she should not need NORESET. She
seems to have found the problem though and all is well.
Regards,
Michael Lee
MCL Systems Inc.
Hurworth, Erik wrote:
> Hi all,
>
>
>
> You DO need NORESET otherwise the SUBTOTAL will automatically reset in
> accordance with the AT option
>
> on the SUBFILE statement,
>
>
>
> Regards
>
>
>
> Erik A. Hurworth
>
> Customer Support
>
> Cognos Ltd.
>
>
>
> ------------------------------------------------------------------------
>
> From: powerh-l-admin@lists.sowder.com
> [mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Michael Lee
> Sent: 18 January 2005 16:48
> To: David Morrison - Corporate
> Cc: Kristina Carlton; powerh-l@lists.sowder.com
> Subject: Re: count
>
>
>
> Hi Kristina,
>
> I think you do only want one record to be written to the 'CREATEDT'
> file though. If the file DWDTL has 55 records then the KOUNT should
> have '55' in it. Perhaps it's a bug of some sort. Perhaps you could
> try adding NORESET after the "KOUNT SUBTOTAL NORESET" and see if that
> does the trick. You shouldn't have to but one never knows...
>
>
> Regards,
>
>
> Michael Lee
> MCL Systems Inc.
>
> David Morrison - Corporate wrote:
>
> Kristina,
>
>
>
> The last step defines D_SORT as a constant 1. So, if you output (SET
> SUBFILE) at D_SORT, you're only going to output to your Report Summary
> table once.
>
>
>
> Thanks.
>
>
>
> David Morrison
>
> McBride Electric
>
> -----Original Message-----
> From: powerh-l-admin@lists.sowder.com
> <mailto:powerh-l-admin@lists.sowder.com>
> [mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Kristina Carlton
> Sent: Tuesday, January 18, 2005 7:03 AM
> To: 'powerh-l@lists.sowder.com <mailto:powerh-l@lists.sowder.com>'
> Subject: count
>
> Hi,
>
>
>
> Could someone take a look at the attached Quiz extract and tell me
> what I am doing wrong. I am trying to get the count I have
> extracted in the first part at the bottom of the extract. Although
> my file has 55 records in it, or more, the count is 1 each time. I
> am doing this for all my other files and it works fine. What am I
> missing?
>
>
>
> OpenVMS v7.3-2 and Quiz V7.10.G4.
>
>
>
>
>
> Kristina Carlton
>
> Senior Programmer/Analyst
>
> The JI Companies
>
> Kristina.Carlton@JICompanies.com
> <mailto:Kristina.Carlton@JICompanies.com>
>
>
>
>
>
> This message may contain privileged and/or confidential
> information. If you have received this e-mail in error or are not the
> intended recipient, you may not use, copy, disseminate or distribute
> it; do not open any attachments, delete it immediately from your
> system and notify the sender promptly by e-mail that you have done so.
> Thank You.
>
>
>
>
>
>
--------------070905070807080202040009
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
You are right Eric, but in Kristina's case the program is sorting on a
value that is always '1' and therefore she should not need NORESET. She
seems to have found the problem though and all is well.<br>
<br>
<br>
Regards,<br>
<br>
Michael Lee<br>
MCL Systems Inc.<br>
<br>
<br>
Hurworth, Erik wrote:<br>
<blockquote type="cite"
cite="mid7D10775889AE184A8BED5827BE0D16E10B0C607C@SBRAEMAIL1.ent.ad.cognos.com">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-16">
<meta http-equiv="Content-Type" content="text/html; ">
<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]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Century Gothic";
panose-1:2 11 5 2 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:9.0pt;
font-family:"Century Gothic";
color:black;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0cm;
margin-bottom:.0001pt;
font-size:9.0pt;
font-family:"Century Gothic";
color:black;}
span.EmailStyle16
{mso-style-type:personal;
font-family:"Century Gothic";
color:navy;
font-weight:normal;
font-style:normal;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Century Gothic";
color:navy;
font-weight:normal;
font-style:normal;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{page:Section1;}
-->
</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div>
<div class="Section1">
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span
style="font-size: 10pt; font-family: Arial; color: navy;">Hi all,<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span
style="font-size: 10pt; 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: 10pt; font-family: Arial; color: navy;">You DO need
NORESET otherwise the SUBTOTAL
will automatically reset in accordance with the AT option<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span
style="font-size: 10pt; font-family: Arial; color: navy;">on the
SUBFILE statement,<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span
style="font-size: 10pt; 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: 10pt; font-family: Arial; color: navy;">Regards<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span
style="font-size: 10pt; 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: 10pt; font-family: Arial; color: navy;">Erik A.
Hurworth<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span
style="font-size: 10pt; font-family: Arial; color: navy;">Customer
Support<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span
style="font-size: 10pt; font-family: Arial; color: navy;">Cognos Ltd.<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span
style="font-size: 10pt; 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" color="black" face="Times New Roman"><span
style="font-size: 12pt; font-family: "Times New Roman"; color: windowtext;">
<hr size="2" width="100%" align="center" tabindex="-1"></span></font></div>
<p class="MsoNormal"><b><font size="2" color="black" face="Tahoma"><span
style="font-size: 10pt; font-family: Tahoma; color: windowtext; font-weight: bold;">From:</span></font></b><font
size="2" color="black" face="Tahoma"><span
style="font-size: 10pt; font-family: Tahoma; color: windowtext;">
<a class="moz-txt-link-abbreviated" href="mailto:powerh-l-admin@lists.sowder.com">powerh-l-admin@lists.sowder.com</a>
[<a class="moz-txt-link-freetext" href="mailto:powerh-l-admin@lists.sowder.com">mailto:powerh-l-admin@lists.sowder.com</a>] <b><span
style="font-weight: bold;">On
Behalf Of </span></b>Michael Lee<br>
<b><span style="font-weight: bold;">Sent:</span></b> 18 January 2005
16:48<br>
<b><span style="font-weight: bold;">To:</span></b> David Morrison -
Corporate<br>
<b><span style="font-weight: bold;">Cc:</span></b> Kristina Carlton;
<a class="moz-txt-link-abbreviated" href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>
<b><span style="font-weight: bold;">Subject:</span></b> Re: count</span></font><font
size="3" color="black" face="Times New Roman"><span
style="font-size: 12pt; font-family: "Times New Roman"; color: windowtext;"><o:p></o:p></span></font></p>
</div>
<p class="MsoNormal"><font size="1" color="black"
face="Century Gothic"><o:p> </o:p></font></p>
<p class="MsoNormal"><font size="1" color="black"
face="Century Gothic"><span style="font-size: 9pt;">Hi Kristina,<br>
<br>
I think you do only want one record to be written to the 'CREATEDT'
file
though. If the file DWDTL has 55 records then the KOUNT should have
'55' in it.
Perhaps it's a bug of some sort. Perhaps you could try adding NORESET
after the
"KOUNT SUBTOTAL NORESET" and see if that does the trick. You
shouldn't have to but one never knows...<br>
<br>
<br>
Regards,<br>
<br>
<br>
Michael Lee<br>
MCL Systems Inc.<br>
<br>
David Morrison - Corporate wrote:<br>
<br>
<o:p></o:p></span></font></p>
<div>
<p class="MsoNormal"><font size="2" color="blue" face="Arial"><span
style="font-size: 10pt; font-family: Arial; color: blue;"><!--[if gte mso 9]><xml>
<u1:OfficeDocumentSettings>
<u1:DoNotRelyOnCSS/>
</u1:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<u2:WordDocument>
<u2:View>Normal</u2:View>
<u2:Zoom>0</u2:Zoom>
<u2:DocumentKind>DocumentEmail</u2:DocumentKind>
<u2:EnvelopeVis/>
<u2:DrawingGridHorizontalSpacing>2.85 pt</u2:DrawingGridHorizontalSpacing>
<u2:DisplayVerticalDrawingGridEvery>2</u2:DisplayVerticalDrawingGridEvery>
</u2:WordDocument>
</xml><![endif]-->Kristina,</span></font><font
size="3" face="Times New Roman"><span
style="font-size: 12pt; font-family: "Times New Roman";"><o:p></o:p></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" color="black"
face="Times New Roman"><span
style="font-size: 12pt; font-family: "Times New Roman";"> <o:p></o:p></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="2" color="blue" face="Arial"><span
style="font-size: 10pt; font-family: Arial; color: blue;">The last
step defines D_SORT as a constant
1. So, if you output (SET SUBFILE) at D_SORT, you're only going to
output
to your Report Summary table once.</span></font><font size="3"
face="Times New Roman"><span
style="font-size: 12pt; font-family: "Times New Roman";"><o:p></o:p></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" color="black"
face="Times New Roman"><span
style="font-size: 12pt; font-family: "Times New Roman";"> <o:p></o:p></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="2" color="blue" face="Arial"><span
style="font-size: 10pt; font-family: Arial; color: blue;">Thanks.</span></font><font
size="3" face="Times New Roman"><span
style="font-size: 12pt; font-family: "Times New Roman";"><o:p></o:p></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" color="black"
face="Times New Roman"><span
style="font-size: 12pt; font-family: "Times New Roman";"> <o:p></o:p></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="2" color="blue" face="Arial"><span
style="font-size: 10pt; font-family: Arial; color: blue;">David
Morrison</span></font><font size="3" face="Times New Roman"><span
style="font-size: 12pt; font-family: "Times New Roman";"><o:p></o:p></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="2" color="blue" face="Arial"><span
style="font-size: 10pt; font-family: Arial; color: blue;">McBride
Electric</span></font><font size="3" face="Times New Roman"><span
style="font-size: 12pt; font-family: "Times New Roman";"><o:p></o:p></span></font></p>
</div>
<blockquote
style="margin-top: 5pt; margin-right: 0cm; margin-bottom: 5pt;">
<p class="MsoNormal" style="margin-bottom: 12pt;"><font size="2"
color="black" face="Tahoma"><span
style="font-size: 10pt; font-family: Tahoma;">-----Original
Message-----<br>
<b><span style="font-weight: bold;">From:</span></b> <a
href="mailto:powerh-l-admin@lists.sowder.com">powerh-l-admin@lists.sowder.com</a>
[<a href="mailto:powerh-l-admin@lists.sowder.com">mailto:powerh-l-admin@lists.sowder.com</a>]<b><span
style="font-weight: bold;">On Behalf Of </span></b>Kristina Carlton<br>
<b><span style="font-weight: bold;">Sent:</span></b> Tuesday,
January 18, 2005
7:03 AM<br>
<b><span style="font-weight: bold;">To:</span></b> '<a
href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a>'<br>
<b><span style="font-weight: bold;">Subject:</span></b> count</span></font><font
size="3" face="Times New Roman"><span
style="font-size: 12pt; font-family: "Times New Roman";"><o:p></o:p></span></font></p>
<p class="MsoNormal"><span class="EmailStyle17"><font size="1"
color="navy" face="Century Gothic"><span style="font-size: 9pt;">Hi,<u3:p></u3:p></span></font></span><o:p></o:p></p>
<p class="MsoNormal"><span class="EmailStyle17"><font size="1"
color="navy" face="Century Gothic"><span style="font-size: 9pt;"> </span></font></span><o:p></o:p></p>
<u3:p></u3:p>
<p class="MsoNormal"><span class="EmailStyle17"><font size="1"
color="navy" face="Century Gothic"><span style="font-size: 9pt;">Could
someone take a look
at the attached Quiz extract and tell me what I am doing wrong. I am
trying to
get the count I have extracted in the first part at the bottom of the
extract.
Although my file has 55 records in it, or more, the count is 1 each
time. I am
doing this for all my other files and it works fine. What am I missing?<u3:p></u3:p></span></font></span><o:p></o:p></p>
<p class="MsoNormal"><font size="2" color="black"
face="Century Gothic"><span style="font-size: 10pt;"> <u3:p></u3:p></span></font><o:p></o:p></p>
<p class="MsoNormal"><font size="2" color="black"
face="Century Gothic"><span style="font-size: 10pt;">OpenVMS v7.3-2
and Quiz V7.10.G4.</span></font><o:p></o:p></p>
<u3:p></u3:p>
<p class="MsoNormal"><span class="EmailStyle16"><font size="1"
color="navy" face="Century Gothic"><span style="font-size: 9pt;"> </span><u3:p></u3:p></font></span><o:p></o:p></p>
<p class="MsoNormal"><span class="EmailStyle16"><font size="1"
color="navy" face="Century Gothic"><span style="font-size: 9pt;"> </span><u3:p></u3:p></font></span><o:p></o:p></p>
<p class="MsoNormal"><span class="EmailStyle16"><font color="navy"
face="Century Gothic">Kristina Carlton<u3:p></u3:p></font></span><o:p></o:p></p>
<p class="MsoNormal"><span class="EmailStyle16"><font size="1"
color="navy" face="Century Gothic"><span style="font-size: 9pt;">Senior
Programmer/Analyst<u3:p></u3:p></span></font></span><o:p></o:p></p>
<p class="MsoNormal"><span class="EmailStyle16"><font size="1"
color="navy" face="Century Gothic"><span style="font-size: 9pt;">The
JI Companies<u3:p></u3:p></span></font></span><o:p></o:p></p>
<p class="MsoNormal"><span class="EmailStyle16"><font size="1"
color="navy" face="Century Gothic"><span style="font-size: 9pt;"><a
href="mailto:Kristina.Carlton@JICompanies.com">Kristina.Carlton@JICompanies.com</a><u3:p></u3:p></span></font></span><o:p></o:p></p>
<p class="MsoNormal"> <u3:p></u3:p><o:p></o:p></p>
</blockquote>
</div>
</div>
<div> </div>
<div> </div>
<div>
<font face="Arial" size="2"> This message may contain
privileged and/or confidential information. If you have received this
e-mail in error or are not the intended recipient, you may not use,
copy, disseminate or distribute it; do not open any attachments, delete
it immediately from your system and notify the sender promptly by
e-mail that you have done so. Thank You.</font>
</div>
<div> </div>
<div> </div>
<div>
<font face="Arial" size="2"></font> </div>
<div style="font-size: 9pt; font-family: Courier New;"> </div>
<div style="font-size: 9pt; font-family: Courier New;"> </div>
<div style="font-size: 9pt; font-family: Courier New;">
<font face="Arial" size="2"></font> </div>
</blockquote>
</body>
</html>
--------------070905070807080202040009--