[sqr-users] Print Layout for Multiple Reports

[David Ward <wardd@mail.uww.edu>]

Thanks to advice from Gordon and Dwayne, I have a solution to my problem.

First, by moving the include for the 'setup32.sqc' AFTER my 'Begin-Setup' 
section, I corrected the problem with the first report.  Then, I added the 
following lines just before the first 'Print' statement is processed for 
the second report:

       alter-printer                     !20030505 added! Needed to get 
.pdf output
       pitch=18                         !20030505 added! formated correctly
       point-size=7.2                 !20030505 added! in PS version 8.x.
(these are the settings in the 'setup32.sqc')

I need to study and read about this more, as I want to fully understand 
what is happening.  It appears to me that since my 'Begin-Setup' section 
was specified last, it becomes the default settings for the entire 
session(thus taking precedence over the settings in 'setup32.sqc).  Since I 
did not specify a layout, etc... in my 'Begin-Setup', the default settings 
are used for all reports in the program.  However, they are 'changed' by 
relocating the 'setup32.sqc' for the first report, then altered for the 
second report with the 'alter-printer' code.  What I don't understand is 
why relocating the 'setup32.sqc' did not lock the settings for both the 
reports in the program?

Thought some might be interested in my experience.
Thanks again.
David.

Original post:
Hello -

we are running version 6.x sqr in a Unix environment(under PeopleSoft Tools 
rel. 8.19 for PS folks).  I'm currently converting a sqr which creates 2 
separate reports in (.lis format) under PS 7.6 to run under PS 8.x 
selecting .pdf as the format.  Both reports are used throughout the program 
using the 'use-report' functionality.  I've specified declares for both 
reports in the 'setup' section, but have not indicated 'layout' or 
'printer' declares.  These are specified in a PS delivered 'setup' sqc 
included, so I've been able to exclude them.  Here is the code:

#include 'setenv.sqc'    !Set environment
#Include 'setup32.sqc'   !Printer and page-size initialization


!Added Setup section for multiple reports!
begin-setup
declare-report Everything_But_Special_Report
end-declare

declare-report Special_Student_Report
end-declare
end-setup

The problem I'm having is that the report layout when opened in Adobe is 
mis-aligning several print fields causing typeover(not adhering to the 
offsets specified in my 'print' statements).

One important note is that I have several other sqr's which produce only a 
single .pdf file(hence no 'setup' section with report declares exists) that 
are using the exact same sqc's for setup, layout, etc...  which are not 
experiencing this issue.

The fonts on the .pdf output between the two sqr's(one with single vs. one 
with multiple reports) seems to be of different size, which leads me to 
believe they are using different layouts.  However, all my reference 
indicates that when not specified the defaults(LINEPRINTER, default layout) 
will be used.  These should be the same as what is in the PS delivered sqc 
file.

I've searched the sqrug archives, and played around with adding layout 
sections to my declarations, but with no luck.  I'm guessing the way I was 
using the 'declare-report' sections under PS 7.6 was not correct and that 
some requirement has been excluded.

Any assistance or suggestions would be greatly appreciated.




David Ward
Technology & Information Resources
UW-Whitewater
800 W. Main St.
Whitewater, WI  53190
262-472-1039
Fax:     262-472-5733


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