Re: SQLPLUS and computed totals

[Quoted] i hate seeing a "nothing you can do" so here's a clunky solution for you:
skip the breaks and computes, at the end of the report compute the sum yourself.
select count(carbno), count(dte_comp), count(*) from table;

of course, if the data is changing during report run, this won't be accurate.

HTH
janet

Eric Givler wrote:
>
> 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 Tue Jan 21 1997 - 00:00:00 CET