<@ASSIGN NAME="local$sumhours" VALUE="@@resultset" > <@COMMENT> <@ASSIGN NAME="local$getdata" VALUE="@@resultset" > <@FOR start=1 stop=<@NUMROWS ARRAY=local$getdata>> <@ADDROWS local$comp <@TOKENIZE VALUE="<@VAR sumhours[<@CURROW>7]>" CHARS=" ">> <@ROWS> <@IF EXPR='<@CALC EXPR="SUM(@@local$sumhours[*,9])">>1'> <@ELSEIF EXPR='<@CALC EXPR="SUM(@@local$sumhours[*,9])">=1'> <@ELSE>
Dates and Times and Compensation for <@COLUMN 'Courses.Title'>
Date Time Act 48 Hours Compensation
<@COLUMN 'Course_CrossLink.Course_Date' FORMAT='Datetime:%A, %B %d, %Y'> <@COLUMN 'Course_Times.Course_Time'> <@COLUMN 'Course_CrossLink.Act48Hours'> <@COLUMN 'Compensation.Compensation_Description'>
Totals <@CALC EXPR="SUM(@@local$sumhours[*,8])"><@CALC EXPR="SUM(@@local$sumhours[*,9])"> Days<@CALC EXPR="SUM(@@local$sumhours[*,9])"> Day

Close Widow