- custom column headers

Hi, Greetings to all of you

I'm new to the list, and since my usuals reports are very simple,
I was happy with the help files, but that changed, I've been challenged
with this problem:

The report source is the RESULTS table:

Fields: {place,test,result,...}
   place       test        result
+---------+-------------+-------+
DOWNTOWN  | AIR QUALITY |  0.3  |
DOWNTOWN  | WATER QUA   |  10.5 |
DOWNTOWN  | V. COLERAE  |  N/A  |
ORANGE ST | AIR QUALITY |  0.3  |
ORANGE ST | WATER QUA   |  1.0  |
ORANGE ST | V. COLERAE  |  N/A  |
B. PLAZA  | AIR QUALITY |  0.4  |
B. PLAZA  | WATER QUA   |  22.4 |
B. PLAZA  | V. COLERAE  |  5.4  |
...
----------+-------------+-------+

and the report should looke something like this:

+--------------------------------------------------------+
             REPORT TITLE
----------------------------------------------------------

Place       |   AIR QUALITY   |   WATER QUA  |  V. COLERA | ...
-----------------------------------------------------------
DOWNTOWN    |    0.3          |     10.5     |     N/A
ORANGE ST   |    0.3          |      1.0     |     N/A
B. PLAZA    |    0.4          |     22.4     |     5.4
...
------------------------------------------------------------


I remember that the old ReportSmith could handle this type of
reports without hassle, and maybe QuickReports too, but for now
I'm clueless about this issue.

Any input or advise is very aprecciated


Best regards
-Fernando




Fernando Flores Prior

[email protected]
Instituto Mexicano de Tecnologia del Agua