SHOWWORK

Returns workshops taken by particular registrant, with or without instructor name and options to select specific fields.

Reporting Area(s):

Registrations

Required Parameters:

  1. Course # (i.e. cocrse, rgcrse, pycrse)
  2. Name ID (i.e. nmid, rgid, wiid)

Optional Parameters:

  1. Logical .t. print workshop instructor, .f. don't print
  2. Delimiter to place between fields (i.e.: " ", ",", Chr(9))
  3. Field from Workshop Master Record to return (i.e.: "wmtitle", wmleader", "wmnote"). Default is Title Note Leader. If you want to return a field from the Workshop Individual Record, you must preface the field name with WKSHPIND. (i.e. WKSHPIND.wigrade)
  4. Delimiter to place between workshop records (i.e. "-", " ", CHR(13) carriage return (default))
  5. Logical .t. don't show message indicating orphan workshop code (i.e. 'NO MASTER WK RECORD:'), .f. show message (default)
  6. Condition to show workshop records (i.e. "wmcode='A' ")

Example(s):

SHOWWORK(rgcrse, rgid) returns Workshop Title, Workshop Note, Leader

SHOWWORK(rgcrse, rgid, .F., "", "wmtitle") returns Workshop Title only

SHOWWORK(pycrse,pyid,.f.,"","dtoc(wmdate)+chr(9)+wmtime+chr(9)+trim(wmtitle)+chr(9)+'$'+str(wmfeeamt,6,2)") returns Workshop date, time, title and fee amount separated by tabs

SHOWWORK(rgcrse, rgid, .F., "","WKSHPIND.wigrade") returns the Workshop Grade

 

Related Topics Link IconRelated Topics