cross-tab (vertical to horizontal) data in dev2K ?

From: Paul Royappa <proyappa_at_ccd.harris.com>
Date: Fri, 09 Jul 1999 09:51:38 -0400
Message-ID: <3785FE6A.C4F25B2D_at_ccd.harris.com>

I'm looking for info on creating a cross-tab (matrix) type report in Developer in which a row value becomes a column heading across the top of the form. For example:

Given the table:

comp_id area price

1              A1    100
1              A2    200
2              A1    50
2              A3    25

where comp_id and area is the primary key.

I would like to display this data on a form with unqiue areas across the top:

company       A1           A2           A3
1                   100         200
2                     50                         25

Assume there are three areas max.
I know this is easy to do in Report Builder, but the data is not updatable in Report Builder reports; one reqirement is the data on the form must be updateable.

The only decent solution we have now is to create a database table that looks like the report, repeating groups and all. As a DBA I always cringe at the sight of repeating groups (0ith normal form).

Any ideas ?

Thanks ahead,

Tom Received on Fri Jul 09 1999 - 15:51:38 CEST