Re: Multiple reports and the usage of columns

["Lu, Clint" <Clint.Lu@MDMNETWORK.COM>]

Chuong,

you have to define columns systax under use-report. For example,
begin-procedure print_detail
use-report detail
columns 1 23 45
  use-column 1
    print value_1    (,)
  next-column
    print value_2    (,)
  position (+1)
end-procedure ! print_detail

begin-procedure summary
use-report sum
columns 1 23 50
  use-column 1
    print sum_value (,)
end-procedure ! summary

This will work for you Chuong. Good luck

Clint Lu
clint.lu@mdmnetwork.com

-----Original Message-----
From: Pham, Chuong [mailto:CPham@INTEGRATIONWARE.COM]
Sent: Monday, December 14, 1998 10:25 AM
To: Multiple recipients of list SQR-USERS
Subject: Multiple reports and the usage of columns


Hi All,

I have a situation where I need to print out the results in multiple
reports.
The body of the main report will conditionally writes out output to
different output files.
For simplicity, the logic involves the use of columns definition and
next-column.
However, I am getting an error (see output below).
The description of the COLUMNS function on page 132 of the SQR3
Workbench mentioned that
  "The COLUMNS command applies only to the current report.  If you wish
to print columns in more than one report,
   you must specify the columns command for each report."

My question is how am I supposed to do this?
What's the syntax for defining multiple columns for multiple reports and
where do I specify this definition (i.e. setup only, heading, etc)?

Thanks,
Chuong
cpham@integrationware.com

---------------------------------------debug
trace-------------------------------------------------------------------
-----
EmplID: 174527518
Use-report 1
In PrintheaderLine
     Current Column: 1.000000

EmplID: 206469799
Use-report 1
In PrintheaderLine
     Current Column: 1.000000

EmplID: 174527519
Use-report 2
In PrintheaderLine
     Current Column: 1.000000

Error on line 337:
   (SQR 1705) Report 'rep2': Column number 1 is not defined.