Help on creating this report (any method)

I have to create a tabular quarterly summary report, based on 4 different queries, but all are grouped by the same columns.  Any suggestions on how to accomplish this - sql report etc.    Thanks a lot.

Type    category    Col1   Col2    Col3     Col4

Elec      Fac           500      100          200        400

Elec     Rates         300     200           50         450

Elec     Fran          200     100         50         250

Gas      Fac           700       300        200         800

Gas     Rates        900     100         600        400

Gas   Fran           400      100          300        100

Col1 is count of open cases at start of quarter grouped by type and category

Col1 query is:

select type, category, count(*) form case where status='Open' and date_filed<'01-Jul-02' group by type, category;

Col2 query is:

select type, category, count(*)  from case where date_filed>='01-Jul-02' group by type, category;

Col3 query is

select type, category, count(*) form case where status='Closed' and date_closed>='01-Jul-02' and date_closed<='03-Sep-02' group by type, category;

Col4 query is

select type, category, count(*) form case where status='Open' group by type, category;