Informix - Reports

I have a report which prints out in the following way: AISLE WAVE SUM 012 R00 2 012 R21 3 012 R22 4 TOTAL 9 013 R01 4 013 R21 6 013 R22 4 TOTAL 14 014 R01 3 014 R21 4 014 S00 3 TOTAL 10 I need the above report to print in a vertical fashion AISLE R00 R01 R21 R22 S00 TOTAL 012 2 0 3 4 0 9 013 0 4 6 4 0 14 014 0 3 4 0 3 10 A few problems that I see are: The headers (except aisle) are part of the data. Aligning every sum under the proper aisle and waves. The approach I thought I would take was to select distinct wave from the table. and somehow have them as headers. Have them printed out at a particular column. Then select from the table and for every values of sum for a particular aisle print it out at the particular column. I was wondering if anyone else had any other suggestions to the above Thanks Vinay My email is vkg1@ra.msstate.edu -- Vinay Gidwani email vkg1@ra.msstate.edu