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

Pam Yates PYATES at kcc.edu
Mon Dec 5 09:13:16 EST 2011


Keith,

I don't know if this approach is what you had in mind but have you looked at VEN.YTD.CHECK.CTR in the VENDORS file?  It appears to be a check counter per vendor since the beginning of the fiscal year.  Would that help you?

just wondering,
Pam

Pam Yates
Information Technology Services
Kankakee Community College
Kankakee, IL
(815) 802-8918
pyates at kcc.edu<mailto:pyates at kcc.edu>


From: download-list-bounces at cedarville.edu [mailto:download-list-bounces at cedarville.edu] On Behalf Of Johnson, Keith M
Sent: Thursday, December 01, 2011 1:53 PM
To: Cedarville DOWNLOAD Users
Subject: [Download-List] question on making a report for vendors that have 3 or more checks since a date...?

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/20111205/c2536d8d/attachment.html>


More information about the download-list mailing list