[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] Need help with a PeopleSoft sqr
- Subject: RE: [sqr-users] Need help with a PeopleSoft sqr
- From: "Alexander, Steve" <Steven.Alexander@sanjoseca.gov>
- Date: Mon, 20 Dec 2004 11:57:31 -0800
- Delivery-date: Mon, 20 Dec 2004 15:00:05 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Do the print statements use absolute positions (print $stuff (5, 1)) or
relative positions (print $stuff (+1,1))? If it's relative, just change the
first one from "(+1, 1)" to "(+3, 1)".
-----Original Message-----
From: sqr-users-bounces+steven.alexander=sanjoseca.gov@sqrug.org
[mailto:sqr-users-bounces+steven.alexander=sanjoseca.gov@sqrug.org]On
Behalf Of Knapp, Richard
Sent: Monday, December 20, 2004 11:06 AM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: RE: [sqr-users] Need help with a PeopleSoft sqr
You might have to muck around with this some. Maybe the lines per page
are overriding your top margin. The first thing I would try is to drop
two lines from that.
Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu
-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
Nanci Lawson
Sent: Monday, December 20, 2004 12:58 PM
To: This list is for discussion about the SQR database reportinglanguage
from Hyperion Solutions.
Subject: RE: [sqr-users] Need help with a PeopleSoft sqr
Yes, HP printer, PCL 5.
Nanci
-----Original Message-----
From: sqr-users-bounces+lawson=soka.edu@sqrug.org
[mailto:sqr-users-bounces+lawson=soka.edu@sqrug.org] On Behalf Of Knapp,
Richard
Sent: Monday, December 20, 2004 9:37 AM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: RE: [sqr-users] Need help with a PeopleSoft sqr
Are you using a PCL compatible printer?
Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu
-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
Nanci Lawson
Sent: Monday, December 20, 2004 10:20 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Need help with a PeopleSoft sqr
Hi,
I have been asked to modify this PeopleSoft sqr, SF1098RP. It prints
1098-T's to a preprinted form. I have been asked to move the print down
2 lines.
I have changed the top-margin=.165 to top-margin=.6 (per another
suggestion), but it did not have any effect. Does anyone have any other
suggestions?
Here is the setup;
begin-setup
#include 'setupdb.sqc' ! Database specific setup
!
! The escape codes, unless otherwise noted, are for PCL-compatible
printers ! being used as a line printer. If the printer you are using is
not ! PCL-compatible, then these codes will not work as intended. Please
refer ! to the user's manual for your printer to determine the correct
codes.
!
#ifndef EBCDIC ! If not running on IBM MVS or
AS/400
#if {PRINTER_TYPE} = 'LINEPRINTER'
declare-printer LP-definition
type=LINEPRINTER
init-string=<27>E<27>(0N<27>&l6D<27>&l0E<27>&l64F
! | | | | |
! | | | | --> 64 text lines
! | | | --> top margin = 0 lines
! | | --> 6 lines per inch
! | --> ISO 8859-1 symbol set
! --> Reset
end-declare
#endif
#else ! EBCDIC Ports
#if {PRINTER_TYPE} = 'LINEPRINTER'
declare-printer LP-definition
type=LINEPRINTER
! If you intended to download the output file created by SQR to print it
on a ! PCL-compatible printer attached to an ASCII-bases operating
system, such as ! Windows or Unix, use the following escape codes.
!
! Note: These codes may not work as intended if the output is copied to
a
! printer defined as a directly-attached printer or a remote
network
! printer, even if the printer is PCL-compatible
!
! init-string=<39>E<39>(0N<39>&l6D<39>&l0E<39>&l64F
! | | | | |
! | | | | --> 64 text lines
! | | | --> top margin = 0 lines
! | | --> 6 lines per inch
! | --> ISO 8859-1 symbol set
! --> Reset
!
! If you intended to copy the output file created by SQR to a printer
defined as ! a directly-attached printer or a remote network printer on
EBCDIC-bases operating ! systems, such as MVS or OS/400, use this
init-string !
! THIS IS THE DEFAULT FOR EBCDIC SYSTEMS !
init-string=<241>
! |
! --> FCFC "1" for top of page
!
end-declare
#endif
#endif
declare-layout 1098T-layout
paper-size=(8.5,11)
orientation=PORTRAIT
max-columns=80
left-margin=0
top-margin=.165 ****** This top margin is probably important.
bottom-margin=0
line-height=9
char-width=7.2
end-declare
Thanks in advance,
Nanci
SUA
_______________________________________________
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
_______________________________________________
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