How to transpose records results in a Query??
Posted on 2002-05-22
I am working with D6Ent, Paradox and the builtin QuickReport for the reports.
I got 2 tables, one with master records, an the seconds with details records. That is,
I need to get this report.
A A1 A2 A3
B B1 B2 B3
SUM A1+B1 A2+B2 A3+B3
Note: records on Table2 are fixed to 3 for each row in Table1, just for the example. Really they are dinamic, and you can set in a config table in which column of the report you list each value.
The only result that i get till now is a query which result is something like this:
So i think that if i can transpose each grouped record i can get something like I need (????)
Thanks you all...