Hello,
I am trying to write a report that is by Long_Title and creates an average of requests, registered, variance. My code is producing the following:

AVE REQS AVE REG AVE VAR LONG_TITLE TERM_CD ……….. REQUESTS REGISTERED VARIANCE
20.00 15.00 5.00 Latin America, 1820-Present* 201002 20.00 15.00 5.00

However I need something like this:

LONG_TITLE TERM_CD ……….. REQUESTS REGISTERED VARIANCE
Latin America, 1820-Present* 201002 20.00 15.00 5.00
Latin America, 1820-Present* 201002 15:00 10:00 5.00
Average 17.50 12.50 5.00

How do I need to change my code?

TABLE FILE SQLOUT
SUM AVE.REQUESTS AS 'AVE REQS' AVE.REGISTERED AS 'AVE REG' AVE.VARIANCE AS 'AVE VAR' BY LONG_TITLE
PRINT
LONG_TITLE
TERM_CD
CRN
SEQ
INSTRUCTOR
SUBJ
CRS_NBR
DIVS_DESC
DEPT_DESC
REQUESTS
REGISTERED
VARIANCE
HEADING
"New College of Florida Course Request System Historical Metrics as of <+0>&DATEtrMDYY <+0> "
" "
FOOTING
""
BY LONG_TITLE NOPRINT
ON LONG_TITLE SUBTOTAL AS ' '
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,

you're using 2 verbs, which is fine.
but BOTH of your verbs have the same BY field.
so you might want to take the BY LONG_TITLE off the SUM statement.
then you'll get some meaningful values.
If that works for you, then you might want to put these averages into a heading, instead of taking up so much space in the first 3 cols of your report. would look nice.