count
Michael Lee
Michael.Lee@mclsystemsinc.com
Tue, 18 Jan 2005 08:48:12 -0800
This is a multi-part message in MIME format.
--------------040907060100030602090707
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
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]On Behalf Of Kristina Carlton
> Sent: Tuesday, January 18, 2005 7:03 AM
> To: '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
>
>
>
--------------040907060100030602090707
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">
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>
<blockquote type="cite"
cite="mid7F881AB8EE5D97418624950B85E10543026773@srvrcpexchange.mcb_corp.mcbrideelectric.com">
<meta http-equiv="Content-Type" content="text/html; ">
<meta content="Word.Document" name="ProgId">
<meta content="MSHTML 6.00.2800.1479" name="GENERATOR">
<meta content="Microsoft Word 9" name="Originator">
<link href="cid:filelist.xml@01C4FD3C.75FAEAE0" rel="File-List">
<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:EnvelopeVis/>
<w:DrawingGridHorizontalSpacing>2.85 pt</w:DrawingGridHorizontalSpacing>
<w:DisplayVerticalDrawingGridEvery>2</w:DisplayVerticalDrawingGridEvery>
</w:WordDocument>
</xml><![endif]-->
<style>@font-face {
font-family: Century Gothic;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.0in 1.0in 1.0in; mso-header-margin: .5in; mso-footer-margin: .5in; mso-paper-source: 0; }
P.MsoNormal {
FONT-SIZE: 9pt; MARGIN: 0in 0in 0pt; COLOR: black; FONT-FAMILY: "Century Gothic"; mso-bidi-font-size: 12.0pt; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: Arial
}
LI.MsoNormal {
FONT-SIZE: 9pt; MARGIN: 0in 0in 0pt; COLOR: black; FONT-FAMILY: "Century Gothic"; mso-bidi-font-size: 12.0pt; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: Arial
}
DIV.MsoNormal {
FONT-SIZE: 9pt; MARGIN: 0in 0in 0pt; COLOR: black; FONT-FAMILY: "Century Gothic"; mso-bidi-font-size: 12.0pt; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: Arial
}
P.MsoAutoSig {
FONT-SIZE: 9pt; MARGIN: 0in 0in 0pt; COLOR: black; FONT-FAMILY: "Century Gothic"; mso-bidi-font-size: 12.0pt; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: Arial
}
LI.MsoAutoSig {
FONT-SIZE: 9pt; MARGIN: 0in 0in 0pt; COLOR: black; FONT-FAMILY: "Century Gothic"; mso-bidi-font-size: 12.0pt; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: Arial
}
DIV.MsoAutoSig {
FONT-SIZE: 9pt; MARGIN: 0in 0in 0pt; COLOR: black; FONT-FAMILY: "Century Gothic"; mso-bidi-font-size: 12.0pt; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: Arial
}
SPAN.EmailStyle15 {
FONT-WEIGHT: normal; COLOR: navy; FONT-STYLE: normal; mso-bidi-font-family: Arial; mso-style-type: personal-compose; mso-ansi-font-size: 9.0pt; mso-ascii-font-family: "Century Gothic"; mso-hansi-font-family: "Century Gothic"
}
SPAN.EmailStyle17 {
FONT-WEIGHT: normal; COLOR: navy; FONT-STYLE: normal; mso-bidi-font-family: Arial; mso-style-type: personal; mso-ansi-font-size: 9.0pt; mso-ascii-font-family: "Century Gothic"; mso-hansi-font-family: "Century Gothic"
}
DIV.Section1 {
page: Section1
}
</style>
<div><span class="044471615-18012005"><font face="Arial"
color="#0000ff" size="2">Kristina,</font></span></div>
<div> </div>
<div><span class="044471615-18012005"><font face="Arial"
color="#0000ff" size="2">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.</font></span></div>
<div> </div>
<div><span class="044471615-18012005"><font face="Arial"
color="#0000ff" size="2">Thanks.</font></span></div>
<div> </div>
<div><span class="044471615-18012005"><font face="Arial"
color="#0000ff" size="2">David Morrison</font></span></div>
<div><span class="044471615-18012005"><font face="Arial"
color="#0000ff" size="2">McBride Electric</font></span></div>
<blockquote dir="ltr" style="margin-right: 0px;">
<div class="OutlookMessageHeader" dir="ltr" align="left"><font
face="Tahoma" size="2">-----Original Message-----<br>
<b>From:</b> <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>On Behalf Of </b>Kristina
Carlton<br>
<b>Sent:</b> Tuesday, January 18, 2005 7:03 AM<br>
<b>To:</b> '<a class="moz-txt-link-abbreviated" href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a>'<br>
<b>Subject:</b> count<br>
<br>
</font></div>
<div class="Section1">
<p class="MsoNormal"><span class="EmailStyle17"><font
face="Century Gothic" color="navy" size="1"><span
style="font-size: 9pt;"><span style="">Hi,<o:p></o:p></span></span></font></span></p>
<p class="MsoNormal"><span class="EmailStyle17"><font
face="Century Gothic" color="navy" size="1"><span
style="font-size: 9pt;"> </span></font></span><span
class="EmailStyle17"><font color="navy" size="1"><span
style="font-size: 7.5pt;"><o:p></o:p></span></font></span></p>
<p class="MsoNormal"><span class="EmailStyle17"><font
face="Century Gothic" color="navy" size="1"><span
style="font-size: 9pt;"><span style="">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?<o:p></o:p></span></span></font></span></p>
<p class="MsoNormal"><font face="Century Gothic" color="black"
size="2"><span style="font-size: 10pt;"> <o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Century Gothic" color="black"
size="2"><span style="font-size: 10pt;">OpenVMS v7.3-2 and Quiz
V7.10.G4.</span></font><span class="EmailStyle17"><font color="navy"><o:p></o:p></font></span></p>
<p class="MsoNormal"><span class="EmailStyle15"><font
face="Century Gothic" color="navy" size="1"><span
style="font-size: 9pt;"><!--[if !supportEmptyParas]--><!--[endif]--> </span><o:p></o:p></font></span></p>
<p class="MsoNormal"><span class="EmailStyle15"><font
face="Century Gothic" color="navy" size="1"><span
style="font-size: 9pt;"><!--[if !supportEmptyParas]--><!--[endif]--> </span><o:p></o:p></font></span></p>
<p class="MsoNormal"><!--[if supportFields]><span style='mso-element:field-begin'></span><span
style="mso-spacerun: yes"> </span>AUTOTEXTLIST \s "E-mail
Signature" <span style='mso-element:field-separator'></span><![endif]--><span
class="EmailStyle15"><font color="navy">Kristina Carlton<o:p></o:p></font></span></p>
<p class="MsoNormal"><span class="EmailStyle15"><font
face="Century Gothic" color="navy" size="1"><span
style="font-size: 9pt;"><span style="">Senior Programmer/Analyst<o:p></o:p></span></span></font></span></p>
<p class="MsoNormal"><span class="EmailStyle15"><font
face="Century Gothic" color="navy" size="1"><span
style="font-size: 9pt;"><span style="">The JI Companies<o:p></o:p></span></span></font></span></p>
<p class="MsoNormal"><span class="EmailStyle15"><font
face="Century Gothic" color="navy" size="1"><span
style="font-size: 9pt;"><span style=""><a class="moz-txt-link-abbreviated" href="mailto:Kristina.Carlton@JICompanies.com">Kristina.Carlton@JICompanies.com</a><o:p></o:p></span></span></font></span></p>
<p class="MsoNormal"><!--[if supportFields]><span style='mso-element:field-end'></span><![endif]--><!--[if !supportEmptyParas]--><!--[endif]--> <o:p></o:p></p>
</div>
</blockquote>
</blockquote>
</body>
</html>
--------------040907060100030602090707--