GRADSPEC2
Used in a JUSTDOIT to return individuals who have taken required courses.
Reporting Area(s)
Deadbeat or Transcripts
Required Parameters
Condition to count registrations (i.e. " 'MGT' $ RGCRSE" - counts all registrations for a single person that have MGT in the course code)
Numeric return value: minimum number of courses meeting above condition that individual must have taken in order to be included (i.e. 3- individual must have taken 3 02F courses to be included)
--OR--character return value "ASK" to bring up a dialog box at report run time where you can input the number of courses meeting parameter 1 condition.
Optional Parameters
- 2nd condition to count registrations (i.e. " 'COM' $ RGCRSE" - counts all registrations for a single person that have COM in the course code)
- Numeric return value: minimum number of courses meeting parameter 3 condition that individual must have taken in order to be included (i.e. 3- individual must have taken 3 02F courses to be included)
--OR--character return value "ASK" to bring up a dialog box at report run time where you can input the number of courses meeting parameter 3 condition.
- Condition to EXCLUDE courses (i.e.: "RGCRSE='09FBUS' " - don't include courses which begin with 09FBUS)
- Condition to include individual based on Interest Codes. (i.e. "MANAG" - individual must have MANAG interest code to be included)
- Interest Code Add Date (from parameter 4). Individual will only be included if add date of Interest code is =>date entered
- Logical .t. will not place 0 as marker in the cursor (so other justdoits can be added to report, if desired).
Example(s)
JUSTDOIT('=gradspec2(["MGT" $ rgcrse],2,["COM" $ rgcrse],2)') - ONLY reports names with 2 or more MGT classes and 2 or more COM classes
JUSTDOIT('=gradspec2(["MGT" $ rgcrse],"ASK",["COM" $ rgcrse],2)') - ONLY reports names with (Ask Later for #) or more MGT classes and 2 or more COM classes.
JUSTDOIT('=gradspec2(["MGT" $ rgcrse],2,["COM" $ rgcrse],2,["NMORG="GOV"])') - ONLY reports names with 2 or more MGT classes and 2 or more COM classes and EXCLUDE names with GOV org code
If conditions include grouping codes, the report can only be run from the Transcripts area:
JUSTDOIT('=gradspec2([grcode="MGTCERT"],"ASK",[grcode="COMCERT"],"ASK"," ","CERTPROG"," ",.T.)') - ONLY reports names with (Ask Later for #) or more MGTCERT courses and (Ask Later for #) COMCERT courses that also have the CERTPROG interest code and does not add the 0 as marker to cursor.
JUSTDOIT('=gradspec2([grcode="MGTCERT"],"ASK",[grcode="COMCERT"],"ASK"," ","CERTPROG","{01/01/2009}",.T.)') - ONLYreports names with (Ask Later for #) or more MGTCERT courses and (Ask Later for #) COMCERT courses that also have the CERTPROG interest code and interest code add date is => 01/01/2009, and does not add the 0 as marker to cursor.
Notes
In creating/selecting a QUERY for this type of report, you must be as inclusive as possible (i.e. include ALL registrations that might match the criteria within the justdoit).