duplicates

Tue, 28 Sep 2004 14:31:09 -0400

This is a multi-part message in MIME format.

------_=_NextPart_001_01C4A589.532F18C1
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

SET NODUPLICATES applies to the report line not the record complex data.
As the manual states, if the report detail line is identical to the
preceding detail line, then it doesn't print if SET NODUPLICATES is
specified. If you have a calculated value or a subtotal, this can cause
the lines to be different even though the data is the same.
Bob Deskin             =20
Senior Product Manager, Application Development Tools, Cognos Inc.=20
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178=20
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA=20
	-----Original Message-----
	From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Kristina Carlton
	Sent: September 28, 2004 2:19 PM
	To: 'powerh-l@lists.sowder.com'
	Subject: duplicates
=09
=09
	Hi,
	=20
	I am running a Quiz extract and I am using the SET NODUPLICATES
command. However, I am getting duplicates anyhow. What might I be doing
wrong?
	=20
	To clarify further, I run an extract with claim detail
information. The claim detail information has the treating physician's
FEIN. I access the subfile that is created and link it to our physician
file to get detailed physician info. There could be multiple entries in
the claim file for each physician obviously, but I was hoping they would
not be duplicated in my physician detail extract. Actually, it works for
all but one physician (this is a small sample only). I checked that
database and do not have duplicates in the physician table.
	=20
	Thanks,
	-Kristina
	Ext. 2459=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.=20
=20

------_=_NextPart_001_01C4A589.532F18C1
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<HTML xmlns:eXclaimer=3D"http://www.exclaimer.co.uk">
<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=3DUTF-16"><TITLE>Message</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3DWord.Document name=3DProgId>
<META content=3D"MSHTML 6.00.2800.1458" name=3DGENERATOR>
<META content=3D"Microsoft Word 9" name=3DOriginator><LINK=20
href=3D"cid:filelist.xml@01C4A55D.C0841640" rel=3DFile-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; 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: "Courier New"
}
LI.MsoNormal {
	FONT-SIZE: 9pt; MARGIN: 0in 0in 0pt; 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: "Courier New"
}
DIV.MsoNormal {
	FONT-SIZE: 9pt; MARGIN: 0in 0in 0pt; 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: "Courier New"
}
P.MsoAutoSig {
	FONT-SIZE: 9pt; MARGIN: 0in 0in 0pt; 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: =
"Courier New"
}
LI.MsoAutoSig {
	FONT-SIZE: 9pt; MARGIN: 0in 0in 0pt; 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: =
"Courier New"
}
DIV.MsoAutoSig {
	FONT-SIZE: 9pt; MARGIN: 0in 0in 0pt; 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: =
"Courier New"
}
SPAN.EmailStyle15 {
	COLOR: #333399; mso-bidi-font-family: Arial; mso-style-type: =
personal-compose; mso-ansi-font-size: 10.0pt; mso-ascii-font-family: =
"Century Gothic"; mso-hansi-font-family: "Century Gothic"
}
DIV.Section1 {
	page: Section1
}
</STYLE>
</HEAD><BODY lang=3DEN-US style=3D"tab-interval: .5in"><DIV>
<DIV><SPAN class=3D401582818-28092004><FONT face=3DArial color=3D#0000ff =
size=3D2>SET=20
NODUPLICATES applies to the report line not the record complex data. As =
the=20
manual states, if the report detail line is identical to the preceding =
detail=20
line, then it doesn't print if SET NODUPLICATES is specified. If you =
have a=20
calculated value or a subtotal, this can cause the lines to be different =
even=20
though the data is the same.</FONT></SPAN></DIV>
<DIV><SPAN class=3D401582818-28092004><!-- Converted from text/rtf =
format -->
<P><SPAN lang=3Den-us><FONT face=3DArial size=3D2>Bob=20
Deskin&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;=20
</FONT></SPAN><BR><SPAN lang=3Den-us><FONT face=3DArial size=3D2>Senior =
Product=20
Manager, Application Development Tools, Cognos Inc.</FONT></SPAN> =
<BR><SPAN=20
lang=3Den-us><FONT face=3DArial size=3D2>bob.deskin@cognos.com (613) =
738-1338 ext 7268=20
FAX: (613) 727-1178</FONT></SPAN> <BR><SPAN lang=3Den-us><FONT =
face=3DArial=20
size=3D2>3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9=20
CANADA</FONT></SPAN> </P></SPAN></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
  <DIV></DIV>
  <DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr =
align=3Dleft><FONT=20
  face=3DTahoma size=3D2>-----Original Message-----<BR><B>From:</B>=20
  powerh-l-admin@lists.sowder.com =
[mailto:powerh-l-admin@lists.sowder.com] <B>On=20
  Behalf Of </B>Kristina Carlton<BR><B>Sent:</B> September 28, 2004 2:19 =

PM To: 'powerh-l@lists.sowder.com' Subject:=20
 duplicates </DIV>
 <DIV class=3DSection1>
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: =
12.0pt">Hi,<o:p></o:p>
 <SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"><![if =
!supportEmptyParas]><![endif]>&nbsp;<o:p></o:p>
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">I am running a =
Quiz=20
 extract and I am using the SET NODUPLICATES command. However, I am =
getting=20
 duplicates anyhow. What might I be doing=20
 wrong?<o:p></o:p>
 <SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"><![if =
!supportEmptyParas]><![endif]>&nbsp;<o:p></o:p>
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">To clarify =
further, I run=20
 an extract with claim detail information. The claim detail information =
has the=20
 treating physician&#8217;s FEIN. I access the subfile that is created =
and link it to=20
 our physician file to get detailed physician info. There could be =
multiple=20
 entries in the claim file for each physician obviously, but I was =
hoping they=20
 would not be duplicated in my physician detail extract. Actually, it =
works for=20
 all but one physician (this is a small sample only). I checked that =
database=20
 and do not have duplicates in the physician=20
 table.<o:p></o:p>
 <SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"><![if =
!supportEmptyParas]><![endif]>&nbsp;<o:p></o:p>
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: =
12.0pt">Thanks,<o:p></o:p>
 <S=
PAN=20
 class=3DEmailStyle15><SPAN=20
 style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: =
12.0pt">-Kristina<o:p></o:p>
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">Ext.=20
 2459<SPAN=20
 style=3D"COLOR: #333399; mso-color-alt: =
windowtext"><o:p></o:p>
 <FONT=20
 color=3D#333399><![if =
!supportEmptyParas]><![endif]>&nbsp;<FONT=20
 color=3D#333399><SPAN=20
 style=3D"COLOR: #333399; mso-color-alt: =
windowtext"><o:p></o:p></DIV></BLOCKQUOTE></DIV>
<DIV>&nbsp;</DIV>
<DIV>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;This message may contain privileged and/or confidential =
information.&nbsp; 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.&nbsp; =
Thank you.

</DIV></BODY></HTML>

------_=_NextPart_001_01C4A589.532F18C1--