RE: [sqr-users] How to have dynamic column headers based on aselectfrom a table

["Paul Hoyte" <paul.hoyte@sharidionne.com>]

Joe:

You may want to use the column printing capability of sqr using the
use-column/next-column commands.  For each company that you select, get the
detail and print the detail down the page.  Then for the next company,
reposition to the first line of the second column after switching to that
column, and then start the process over again.  If you are using precision
printing then don't use the next-listing command since that will reposition
you on the next logical page thereby killing the ability to re-position to
the starting line for the next column.   


Paul Hoyte
Sharidionne Inc.
(248) 752-6970
paul.hoyte@sharidionne.com
 

-----Original Message-----
From: sqr-users-bounces+paul.hoyte=sharidionne.com@sqrug.org
[mailto:sqr-users-bounces+paul.hoyte=sharidionne.com@sqrug.org] On Behalf Of
Joe
Sent: Friday, June 11, 2004 11:20 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] How to have dynamic column headers based on a
selectfrom a table

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



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