CRMRPT

Returns summary information for all or selected records from the CRM log file for the specified registrant.

Reporting Area(s):

Courses

Required Parameters:

1. Course # (i.e. cocrse, rgcrse, pycrse)
2. Field from CRM table to return (i.e. "CRTYPE", "CRUSER")

Optional Parameters:

3. Delimiter to place between values (i.e. "/",chr(9), chr(13) ). Default is a space.
4. Condition to return value (i.e. "CRTYPE='E'").

Example(s):

CRMRPT(cocrse,"CRTYPE") returns list of all types assigned to the registrant in a specified course, summarized by the contact type.

CRMRPT(cocrse,"CRTYPE","/","CRTYPE='E'") returns list of 'E' type contacts for registrants in specified course.

Notes:

Requires the CRM module.

 

Related Topics