[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: [sqr-users] Creating Multiple Reports: Converting fromDeclare Printer to Declare-Printer
- Subject: Re: [sqr-users] Creating Multiple Reports: Converting fromDeclare Printer to Declare-Printer
- From: "Lynn Greene" <Lgreene@dncinc.com>
- Date: Tue, 17 Dec 2002 13:08:42 -0500
- List-id: This list is for discussion about the SQR database reporting language from Brio Software. <sqr-users.sqrug.org>
I will be out of the office until Wednesday - December 18th.
If this matter is urgent, please contact:
Eric Cummins
or
William Mourer
>>> sqr-users 12/17/02 13:01 >>>
First of all thanks in advance!!!!
I am worked with Peoplesoft and SQR for a 1 year about 4 years ago and I
am
back working with it. So my experience was limited and is rusty. So I
consider my self a rookie again.
My shop uses SQR 3.0.12.4
I am working with Financials 5.12.42
I am creating an SQR that creates multiple reports from an old report
that
creates a single report.
I am having problems creating both the .lis files and the .spf files at
the
sametime.
I am converting from an old declare printer command to the use of
Declare-Printer, Declare-Report and Declare-Layout.
Here is the declare printer that was in the old SQR:
declare printer ! Declare
printer characteristics.
! type={Laser} ! Types are
POSTSCRIPT, HPLASERJET,
left-margin=.25 top-margin=.25 ! or LINEPRINTER
font=3 ! Font number.
font-style=fixed
! symbol-set=0U
lines-inch=9 ! 6lines per
inch
point-size=6
char-size=4.32
orientation=Landscape ! Or Portrait
Here is what I have tried:
When I use this code below without commenting anything out I can create
the
.spf
files ok but the .lis files are all messed up. The format is all
overlapping.
When I comment the lines that are commented out below the .lis files are
okay and
the .spf files are not. The .spf format is all overlapping.
Begin-Setup
#Define ColR 160 !Column # referenced by Standard Headings
declare-layout Combined_Clients
left-margin = .25
top-margin = .25
orientation = Landscape
char-width = 4.32
line-height = 8
paper-size = (11,8.5)
max-lines = 58
max-columns = 177
end-declare
Declare-Report Combined_Clients
! Printer-Type = HP
Layout = Combined_Clients
End-Declare
Declare-Report Summary
! Printer-Type = HP
Layout = Combined_Clients
End-Declare
DECLARE-PRINTER CMB_CLNT
! type=hp
! font=3
! font-type=fixed
! point-size=6
init-string =
<27>E<27>(0N<27>&l1O<27>&l8D<27>&l5E<27>&l66F<27>(s16.66H
END-DECLARE
End-Setup
_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*
http://join.msn.com/?page=features/virus
_______________________________________________
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