[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 from Declare Printer to Declare-Printer
- Subject: RE: [sqr-users] Creating Multiple Reports: Converting from Declare Printer to Declare-Printer
- From: "Katchur, Ken SS" <Ken.Katchur@govmail.gov.sk.ca>
- Date: Wed, 18 Dec 2002 09:18:27 -0600
- List-id: This list is for discussion about the SQR database reporting language from Brio Software. <sqr-users.sqrug.org>
Hi All,
Steve, I commented out only this line:
! init-string =
<27>E<27>(0N<27>&l1O<27>&l8D<27>&l5E<27>&l66F<27>(s16.66H
and I added this line:
alter-printer point-size=6 font=3
I got the same results where the characters are overlapping/printing
over top of each other in the LIS files. The SPF files are okay. Maybe I
have problems with my column size????
Thanks Ken
From: Steve Cavill <steve.cavill@infoclarity.com.au> on 12/18/2002
02:57 AM
Please respond to sqr-users@sqrug.org@SMTP@Exchange
To: sqr-users@sqrug.org@SMTP@Exchange
cc:
Subject: RE: [sqr-users] Creating Multiple Reports:
Converting from Declare Printer to Declare-Printer
Hi Ken,
I would look carefully at the HP init-string. the command <27>&l8D
sets your
printer to 8 lines per inch. (i.e. each line is 72/8 = 9 points
high), But
your grid says each line is 8 points high ( line-height = 8, or
in the
old code lines-inch=9). When you specify point-size=6 you won't
see the
problem, but when you comment that out then you see the problem.
You should make your SQR grid size match your PCL code. Ideally you
should
remove the init-string, and let SQR control the printer, I can't see
anything in that init string that can't be controlled by SQR, (but I
may be
wrong about that, PCL is a bit hard to read!)
You could also add
alter-printer point-size=6 font=3
to the beginning of your program to force all output to use 6 point
font,
then you should get the same results for the SPF and the PCL.
Cheers, Steve.
-----Original Message-----
From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On
Behalf Of Ken Katchur
Sent: Wednesday, 18 December 2002 5:02 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Creating Multiple Reports: Converting from
Declare
Printer to Declare-Printer
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
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users