SQLPLUS and computed totals

[Quoted] [Quoted] I have a sql*plus script that I'd like to produce totals for the ENTIRE report. The report is about 250 pages long. At the end I'd like a count of all rows, rows with a date entered, and rows with a carb# entered.

in the query, i have these fields:

 decode(carbno,null,0,1) carb_cnt,
 decode(dte_comp,null,0,1) comp_cnt,
 1 overall_cnt

before the report, I have:

 column carb_cnt noprint
 column comp_cnt noprint
 column overall_cnt noprint
 break on report
 compute sum of carb_cnt comp_cnt overall_cnt on report

Nothing shows up at the end. I have headers on and a pagesize of 60. If I don't turn these columns off, then they print fine, but I don't want them appearing. Any ideas? Received on Sat Jan 18 1997 - 00:00:00 CET