>I have a report here which lists draws, returns, and voids of a
>magazine, over the course of 18 issues. It also does a percentage sold
>in each detail line by calculating (d1 - r1 - v1) / (d1 - v1) * 100.
>It is trivial to total up the draws etc. at the end of the report, but
>how do I get the grand total percent? I can do it by using report
>variables to get the individual totals, but that's a _lot_ of typing
>over the course of 18 issues....
>--
>Garrett Fitzgerald
>Software R&D
>MicroKnowledge, Inc.
>Bangor, ME

You could try making the SQL do the calculations for each item. (I have never tried such complicated calcs in SQL, but it _should_ work. This would give you a percentage associated with each month in the cursor. Then you could just put the total of that field in the footer.

select d1, r1, v1, (d1-r1-v1)/(d1-v1) as perc_sold from table blah blah blah...

Just an idea...