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

3. Logical .t. print workshop instructor, .f. don't print
4. Delimiter to place between fields (i.e.: " ", ",", Chr(9))
5. 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)
6. Delimiter to place between workshop records (i.e. "-", " ", CHR(13) carriage return (default))
7. Logical .t. don't show message indicating orphan workshop code (i.e. 'NO MASTER WK RECORD:'), .f. show message (default)
8. 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 Functions

ADDWKCODE
ADDWORK
CTWORK
CURSWORK
CUSTWKCD
LISTWORK
QUIKWORK
SELEWORK
SELEWORK2
SHOWWKMS
STAMPWORK
SUMWORK