[Download-List] question on making a report for vendors that have 3 or more checks since a date...?

[Johnson, Keith M]

Hi all,
I have been toying with making a report that only shows vendors that have three checks since our current FY.

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...

SELECT CHECKS WITH CHK.DATE GT '07/01/11' BY CHK.VENDOR AND WITH EVAL SUM 'XCOUNTER' GE 3            # blows up

LIST CHECKS BREAK.ON CHK.VENDOR EVAL "IF (TOTAL XCOUNTER) GT 3 THEN TOTAL XCOUNTER" DET.SUP NOPAGE   # blows up


These two base lines get me my report but include the vendors with only one or more checks since my date.
=========
SELECT CHECKS WITH CHK.DATE GT '07/01/11' BY CHK.VENDOR
LIST CHECKS BREAK.ON CHK.VENDOR TOTAL XCOUNTER DET.SUP NOPAGE


Ultimately I was thinking of doing something like the download example...
DOWNLOAD.TEST.PARAGRAPH
[...]
161: DISPLAY ===============================================================
162: DISPLAY 10 Testing EVAL and COL.HDG using comma-quote output
163: SELECT DOWNLOAD.TEST.FILE \
[...]
168:   EVAL "NUMERIC.FIELD+58" \
169:   COL.HDG "New Amount" \

TIA  -KJ

Keith Johnson
Information Technology
The College of Idaho                                       kmjohnson at collegeofidaho.edu<mailto:kmjohnson at collegeofidaho.edu>
2112 Cleveland Blvd Caldwell, ID 83605           http://www.collegeofidaho.edu<http://www.collegeofidaho.edu/>
Business: 208.459.5209
Fax: 208.459.5543

CONFIDENTIALITY NOTICE: 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.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20111201/44679ecf/attachment.html>