GRADSPEC
Used in a JUSTDOIT to return individuals who have taken required courses.
Reporting Area(s)
Registrations
Required Parameters
- Condition to count registrations (i.e. "RGCRSE='02F' " - counts all registrations for a single person that start with 02F)
- Numeric return value: minimum number of courses meeting parameter 1 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 to bring up a dialog box at report run time where you can input the number of courses meeting parameter 1 condition:
"ASK": count must be equal to or greater than number entered
"EQUAL": count must exactly match number entered
"LESS": count must be less than number entered
"BETWEEN": count must be between numbers entered
Optional Parameters
- Condition to EXCLUDE courses (i.e.: "RGCRSE='02FBUS' " - don't include courses which begin with 02FBUS)
- 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('=GRADSPEC("rgcrse=[02F]",3)') returns individuals who have taken at least 3 02F courses
JUSTDOIT('=GRADSPEC("rgcrse=[02F]",3,"rgcrse=[02FBUS]","MANAG")') returns individuals who have been assigned the interest code 'MANAG' and who have taken at least 3 02F courses excluding any 02FBUS classes
JUSTDOIT('=GRADSPEC("rgcrse=[02F]",3,"rgcrse=[02FBUS]","MANAG","05/01/2005")') returns individuals who have been assigned the interest code 'MANAG' and who have taken at least 3 02F courses excluding any 02FBUS classes
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).