count
Hurworth, Erik
Erik.Hurworth@cognos.com
Tue, 18 Jan 2005 16:59:50 -0000
This is a multi-part message in MIME format.
------_=_NextPart_001_01C4FD7F.1F65F9C0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Hi all,
=20
You DO need NORESET otherwise the SUBTOTAL will automatically reset in
accordance with the AT option
on the SUBFILE statement,
=20
Regards
=20
Erik A. Hurworth
Customer Support
Cognos Ltd.
=20
________________________________
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
=20
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,
=20
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.
=20
Thanks.
=20
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,
=20
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?
=20
OpenVMS v7.3-2 and Quiz V7.10.G4.
=20
=20
Kristina Carlton
Senior Programmer/Analyst
The JI Companies
Kristina.Carlton@JICompanies.com
=20
=20
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.
------_=_NextPart_001_01C4FD7F.1F65F9C0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<HTML xmlns:eXclaimer=3D"http://www.exclaimer.co.uk" =
xmlns:msxsl=3D"urn:schemas-microsoft-com:xslt" =
xmlns:exc=3D"http://www.exclaimer.co.uk/rtf">
<HEAD>
<META http-equiv=3D"Content-Type" content=3D"text/html; =
charset=3DUTF-16">
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"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=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</HEAD>
<BODY bgcolor=3Dwhite lang=3DEN-US link=3Dblue vlink=3Dblue>
<DIV>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Hi =
all,<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;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=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>on the SUBFILE =
statement,<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Regards<o:p></o:p></span></font></p>=
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Erik A. =
Hurworth<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Customer =
Support<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Cognos =
Ltd.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font =
size=3D3
color=3Dblack face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt;font-family:
"Times New Roman";color:windowtext'>
<hr size=3D2 width=3D"100%" align=3Dcenter tabindex=3D-1>
</span></font></div>
<p class=3DMsoNormal><b><font size=3D2 color=3Dblack face=3DTahoma><span
style=3D'font-size:10.0pt;font-family:Tahoma;color:windowtext;font-weight=
:bold'>From:</span></font></b><font
size=3D2 color=3Dblack face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma;
color:windowtext'> powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] <b><span =
style=3D'font-weight:bold'>On
Behalf Of </span></b>Michael Lee<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> 18 January 2005 =
16:48<br>
<b><span style=3D'font-weight:bold'>To:</span></b> David Morrison - =
Corporate<br>
<b><span style=3D'font-weight:bold'>Cc:</span></b> Kristina Carlton;
powerh-l@lists.sowder.com<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> Re: =
count</span></font><font
size=3D3 color=3Dblack face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt;
font-family:"Times New =
Roman";color:windowtext'><o:p></o:p></span></font></p>
</div>
<p class=3DMsoNormal><font size=3D1 color=3Dblack face=3D"Century =
Gothic"><o:p> </o:p></font></p>
<p class=3DMsoNormal><font size=3D1 color=3Dblack face=3D"Century =
Gothic"><span
style=3D'font-size:9.0pt'>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=3DMsoNormal><font size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:
10.0pt;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=3D3 face=3D"Times =
New Roman"><span
style=3D'font-size:12.0pt;font-family:"Times New =
Roman"'><o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D3 color=3Dblack face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt;font-family:"Times New =
Roman"'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:
10.0pt;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=3D3
face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt;font-family:"Times New =
Roman"'><o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D3 color=3Dblack face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt;font-family:"Times New =
Roman"'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:blue'>Thanks.</span></font><font size=3D3
face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt;font-family:"Times New =
Roman"'><o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D3 color=3Dblack face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt;font-family:"Times New =
Roman"'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:blue'>David Morrison</span></font><font =
size=3D3
face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt;font-family:"Times New =
Roman"'><o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:blue'>McBride Electric</span></font><font
size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt;font-family:"Times New =
Roman"'><o:p></o:p></span></font></p>
</div>
<blockquote =
style=3D'margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt'>
<p class=3DMsoNormal style=3D'margin-bottom:12.0pt'><font size=3D2 =
color=3Dblack
face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma'>-----Original
Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b> <a
href=3D"mailto:powerh-l-admin@lists.sowder.com">powerh-l-admin@lists.sowd=
er.com</a>
[<a =
href=3D"mailto:powerh-l-admin@lists.sowder.com">mailto:powerh-l-admin@lis=
ts.sowder.com</a>]<b><span
style=3D'font-weight:bold'>On Behalf Of </span></b>Kristina Carlton<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> Tuesday, January =
18, 2005
7:03 AM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> '<a
href=3D"mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a>'<=
br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> =
count</span></font><font
size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt;font-family:"Times New =
Roman"'><o:p></o:p></span></font></p>
<p class=3DMsoNormal><span class=3DEmailStyle17><font size=3D1 =
color=3Dnavy
face=3D"Century Gothic"><span =
style=3D'font-size:9.0pt'>Hi,<u3:p></u3:p></span></font></span><o:p></o:p=
></p>
<p class=3DMsoNormal><span class=3DEmailStyle17><font size=3D1 =
color=3Dnavy
face=3D"Century Gothic"><span =
style=3D'font-size:9.0pt'> </span></font></span><o:p></o:p></p>
<u3:p></u3:p>
<p class=3DMsoNormal><span class=3DEmailStyle17><font size=3D1 =
color=3Dnavy
face=3D"Century Gothic"><span style=3D'font-size:9.0pt'>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=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Century =
Gothic"><span
style=3D'font-size:10.0pt'> <u3:p></u3:p></span></font><o:p></o:p></=
p>
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Century =
Gothic"><span
style=3D'font-size:10.0pt'>OpenVMS v7.3-2 and Quiz =
V7.10.G4.</span></font><o:p></o:p></p>
<u3:p></u3:p>
<p class=3DMsoNormal><span class=3DEmailStyle16><font size=3D1 =
color=3Dnavy
face=3D"Century Gothic"><span =
style=3D'font-size:9.0pt'> </span><u3:p></u3:p></font></span><o:p></=
o:p></p>
<p class=3DMsoNormal><span class=3DEmailStyle16><font size=3D1 =
color=3Dnavy
face=3D"Century Gothic"><span =
style=3D'font-size:9.0pt'> </span><u3:p></u3:p></font></span><o:p></=
o:p></p>
<p class=3DMsoNormal><span
class=3DEmailStyle16><font color=3Dnavy face=3D"Century Gothic">Kristina =
Carlton<u3:p></u3:p></font></span><o:p></o:p></p>
<p class=3DMsoNormal><span class=3DEmailStyle16><font size=3D1 =
color=3Dnavy
face=3D"Century Gothic"><span style=3D'font-size:9.0pt'>Senior =
Programmer/Analyst<u3:p></u3:p></span></font></span><o:p></o:p></p>
<p class=3DMsoNormal><span class=3DEmailStyle16><font size=3D1 =
color=3Dnavy
face=3D"Century Gothic"><span style=3D'font-size:9.0pt'>The JI =
Companies<u3:p></u3:p></span></font></span><o:p></o:p></p>
<p class=3DMsoNormal><span class=3DEmailStyle16><font size=3D1 =
color=3Dnavy
face=3D"Century Gothic"><span style=3D'font-size:9.0pt'><a
href=3D"mailto:Kristina.Carlton@JICompanies.com">Kristina.Carlton@JICompa=
nies.com</a><u3:p></u3:p></span></font></span><o:p></o:p></p>
<p class=3DMsoNormal> <u3:p></u3:p><o:p></o:p></p>
</blockquote>
</div>
</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>
<FONT FACE=3D"Arial" SIZE=3D"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=3D"Arial" SIZE=3D"2">
</FONT> </DIV>
<DIV STYLE=3D"FONT-SIZE: 9pt; FONT-FAMILY: Courier New"> </DIV>
<DIV STYLE=3D"FONT-SIZE: 9pt; FONT-FAMILY: Courier New"> </DIV>
<DIV STYLE=3D"FONT-SIZE: 9pt; FONT-FAMILY: Courier New">
<FONT FACE=3D"Arial" SIZE=3D"2">
</FONT> </DIV></BODY></HTML>
------_=_NextPart_001_01C4FD7F.1F65F9C0--