[sqr-users] How to have dynamic column headers based on a selectfrom a table

["Joe" <jej1216@hotmail.com>]

Greetings,

I need to select all the COMPANY's from a COMPANY_TBL and use each value as
a column header in an SQR report.

There are presently 6 companies in COMPANY_TBL.

I need to have 6 columns on a report that goes after additional data related
to those companies.

Select COMPANY
>From PS_COMPANY_TBL;

Comp1
Comp2
Comp3
Comp4
Comp5
Comp6

I need to create a report that has this (Code values will come from another
select):

Code    Comp1     Comp2     Comp3    Comp4    Comp5   Comp6  Total
34        600.89      100.00      000 00   2000.00   300.00    000.00
3000.89
48        100.00      000.00      050.00    000.00    150.00    000.50
300.50
Totals   700.89      100.00      050.00   2000.00   450.00    000.50
3301.39

Thanks in advance,

Joe Johnson
jej1216@hotmail.com

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users