Cross-tab Reports

[Bob Hearon <Robert_B._Hearon@AEP.COM>]

     Ray's suggestion is a good one for complex reports, but one thing you
may want to be aware of is an Oracle 7.3 feature (assuming you have Oracle)
that makes for pretty simple cross-tab reporting.  Most of the work is done
in the SQL statement, observe:

begin-select
tot_gross_amt,
tot_freight
from (select sum(gross_amt) as tot_gross_amt,
  sum(freight_amt) as tot_freight
     from ps_voucher)
end-select

     This will give you two numbers in a horizontal (cross tab) fashion.
Of course, this is a simple example and you could further enhance the sql
with group by, min(), max() yada yada yada.  Other databases may have a
similar technique.