<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:m="http://schemas.microsoft.com/office/2004/12/omml" 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 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Comic Sans MS";
panose-1:3 15 7 2 3 3 2 2 2 4;}
@font-face
{font-family:"Lucida Calligraphy";
panose-1:3 1 1 1 1 1 1 1 1 1;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></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]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><i>Hi all,<o:p></o:p></i></p><p class=MsoNormal><i>I have been toying with making a report that only shows vendors that have three checks since our current FY.<o:p></o:p></i></p><p class=MsoNormal><i><o:p> </o:p></i></p><p class=MsoNormal><i>The CC XCOUNTER just returns a numeral ‘1’ per check record. Other than going in to a subr can this be done at the DB level? I think I have done it years ago but cannot think of the way it’s done…<o:p></o:p></i></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>SELECT CHECKS WITH CHK.DATE GT '07/01/11' BY CHK.VENDOR AND WITH EVAL SUM 'XCOUNTER' GE 3 <i># blows up</i><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>LIST CHECKS BREAK.ON CHK.VENDOR EVAL "IF (TOTAL XCOUNTER) GT 3 THEN TOTAL XCOUNTER" DET.SUP NOPAGE <i># blows up</i><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><i>These two base lines get me my report but include the vendors with only one or more checks since my date.<o:p></o:p></i></p><p class=MsoNormal>=========<o:p></o:p></p><p class=MsoNormal>SELECT CHECKS WITH CHK.DATE GT '07/01/11' BY CHK.VENDOR<o:p></o:p></p><p class=MsoNormal>LIST CHECKS BREAK.ON CHK.VENDOR TOTAL XCOUNTER DET.SUP NOPAGE<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><i>Ultimately I was thinking of doing something like the download example…<o:p></o:p></i></p><p class=MsoNormal>DOWNLOAD.TEST.PARAGRAPH<o:p></o:p></p><p class=MsoNormal>[…]<o:p></o:p></p><p class=MsoNormal>161: DISPLAY ===============================================================<o:p></o:p></p><p class=MsoNormal>162: DISPLAY 10 Testing EVAL and COL.HDG using comma-quote output<o:p></o:p></p><p class=MsoNormal>163: SELECT DOWNLOAD.TEST.FILE \<o:p></o:p></p><p class=MsoNormal>[…]<o:p></o:p></p><p class=MsoNormal>168<b>: EVAL "NUMERIC.FIELD+58"</b> \<o:p></o:p></p><p class=MsoNormal>169: COL.HDG "New Amount" \<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><i>TIA -KJ<o:p></o:p></i></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span style='font-size:13.5pt;font-family:"Lucida Calligraphy"'>Keith Johnson<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Comic Sans MS"'>Information Technology <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Comic Sans MS"'>The College of Idaho <a href="mailto:kmjohnson@collegeofidaho.edu"><span style='font-family:"Times New Roman","serif";color:blue'>kmjohnson@collegeofidaho.edu</span></a><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Comic Sans MS"'>2112 Cleveland Blvd Caldwell, ID 83605 <a href="http://www.collegeofidaho.edu/"><span style='font-family:"Times New Roman","serif";color:blue'>http://www.collegeofidaho.edu</span></a><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Comic Sans MS"'>Business: 208.459.5209<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Comic Sans MS"'>Fax: 208.459.5543<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Comic Sans MS"'><o:p> </o:p></span></p><p class=MsoNormal><b><span style='font-size:8.0pt;color:#1F497D'>CONFIDENTIALITY NOTICE:</span></b><span style='font-size:8.0pt;font-family:"Arial","sans-serif";color:#1F497D'> <i>This e-mail message is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you believe you have received this e-mail in error please notify the sender. </i></span><span style='font-size:8.0pt;color:#1F497D'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Comic Sans MS"'><o:p> </o:p></span></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>