[Download-List] EVAL with TOTAL

[George W Ohlandt]

We have recently upgraded from 6.02 to 7.10 and I'm trying to take advantage of the new EVAL feature to 
DOWNLOAD-ize some of our reports.  Can you use the EVAL with TOTAL as you can in a LIST statement?  It 
doesn't seem to work as expected.

---Simple example with LIST---
SELECT APPLICATIONS WITH APPL.START.TERM EQ '04/SU' SAMPLE 50 BY APPL.ACAD.PROGRAM
LIST APPLICATIONS BREAK.ON APPL.ACAD.PROGRAM TOTAL EVAL "IF APPL.GENDER = 'F' THEN 1 ELSE 0" TOTAL EVAL 
"IF APPL.GENDER = 'M' THEN 1 ELSE 0" DET.SUP COL.SUP

DD.DMD               16         16
HM.MHA.EXEC          0          1
HM.PA                9          2
HM.RHCS              3          0
HM.RHPT              3          0
                    ========== ==========
TOTAL                31         19

---Equivalent with DOWNLOAD---
SELECT APPLICATIONS WITH APPL.START.TERM EQ '04/SU' SAMPLE 50 BY APPL.ACAD.PROGRAM
DOWNLOAD APPLICATIONS BREAK.ON APPL.ACAD.PROGRAM TOTAL EVAL "IF APPL.GENDER = 'F' THEN 1 ELSE 0" TOTAL 
EVAL "IF APPL.GENDER = 'M' THEN 1 ELSE 0" DET.SUP

"DD.DMD","0","1"
"HM.MHA.EXEC","0","1"
"HM.PA","1","0"
"HM.RHCS","1","0"
"HM.RHPT","1","0"
"HM.RHPT","1","0"

If I replace the EVALs with I-descriptors with the same logic, totals are calculated correctly, but that 
kind of defeats much of my purpose in using EVALs.

Any ideas?

Thanks,
George W. Ohlandt
Director of Admissions
Office of Enrollment Services
Medical University of South Carolina
843.792.3813
ohlandtg at musc.edu