Cross-tabs

[Gemba Service <gemba@TIP.NL>]

Hi,

I'm quite new to SQR, setting up simple programs is no problem. At the moment however I'm trying a report with a crosstable. I've found some information regarding this on the older mail. This didn't do me much good since it was mostly for Oracle.

My table consists of the following information:

WONUM      TRANSTYPE        REGULARHRS
========== ================ ==========
1277            LOG                        3.5
1488            WORK                         3
1638            WORK                         1
1695            LOG                          4
2362            WORK                         3
2861            WORK                      1.5
3038            WORK                         3
3432            WORK                         1
3838            LOG                          4
4233            PREP                        .5
4557            WORK                         1


>From this data I would like to generate a report which shows the total hours for each wonum(row) and transaction type(column). Anyone can give me a sample how to solve this problem. I'm working with a SQLbase database, the solution must be compatible with different kind of databases if possible.


Jack


p.s. Anyone knows a good reference guide for SQR, and where can I find it?