[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Multiple Reports on UNIX through Peoplesoft Process Scheduler



You are correct, it is in the sqr parameters that Process Scheduler
uses to create the reports.  You will need to go to the process
scheduler definition page for your process, find the SQR Parameters
page, and override the normal parameters to accomodate the different
parms you will need for the multiple reports.  How you get to the SQR
Parameters panel depends on which version of PeopleSoft you are using.


On Tue, 12 Feb 2002 10:48:23 -0600, you wrote:

>Hi..I have an sqr that creates 2 reports..a summary one and a detail one and
>the user has a choice of which one they want to run.  When I run the sqr on
>the Client through sqrw I get the 2 reports just fine..one's called
>fasar745.lis(detail) and the second is called fasar745.l01 (summary).   But
>when I run the same sqr through the Peoplesoft panels on UNIX I only get the
>detail report even if I wanted both the detail and the summary.  If I switch
>the order of teh DEclare report for detail and summary then i always get the
>one of top but the one on the bottom doenst print.  ANy ideas?  I am
>thinking it has to do with some sqr enviornment variable or flags..but no
>clue where to look.  Thanks
>
>Begin-Setup
>  Declare-Variable
>    integer #mr_day #mr_year #cg_day #cg_year #mr_lag
>    integer #mr_percent #mr_lag_ave
>  End-Declare
>
>  Declare-Layout Report
>    Line-width=90
>    Left-margin=0
>    Top-margin=0
>    Bottom-margin=0
>  End-Declare
>
>  Declare-Report Detail
>    Layout=Report
>  End-Declare
>
>  Declare-Report Summary
>    Layout=Report
>  End-Declare
>
>end-setup