Re: Creating multiple reports on mainframe

["Ballesty, Lorraine" <lorraine.ballesty@ROCHESTER.EDU>]

Steve -

I encountered a similar problem a while back, but instead of an error
message, the additional reports were being sent to unix 'Never-Never Land'.
It turned out that while SQR supports multiple report functionality,
PeopleSoft did not.  What I think is happening to you is that the default
names for the additional reports are not compatible with your system's
naming conventions.

I got around my particular problem by calling each new report in the
beginning of the program, and then deliberately setting the output file,
thereby bypassing the default output file ($sqr-report).  It's little
lengthy, but the following had to happen:

        !SQR:  MultipleReports.sqr
        !      Set up and write to 3 separate output reports
        !**************************************************************
        begin-setup

        !declare report names and formats used
        !-------------------------------------
        declare-report interface_errors ! error report
        end-declare

        declare-report Summary_Rpt                      ! summary report
        end-declare

        declare-report Detail_Rpt                       ! detail report
        end-declare

        end-setup

        !Do the following in your initialization phase to attach
        !the report output names to the correct reports.  You
        !CANNOT write to any of these reports until this is done.
        !***********************************************************
        begin-procedure init-program

                use-report interface_errors
                        !This first call sets the value of $sqr-report
                        !i.e., $sqr-report =
'\bin\output\MultipleReports.lis'
                        !Use this variable to set the value of the next
output report

                use-report Summary_Rpt
                new-report '\bin\output\MultipleReports1.lis'

                use-report Detail_Rpt
                new-report '\bin\output\MultipleReports2.lis'

        end-procedure


        !Now call each report as you need it with the 'use-report' command
        !*****************************************************************
        begin-procedure Process-Main

                use-report interface_errors
                !perform processing....

                use-report Summary_Rpt
                !perform processing...

                !etc....

        end-procedure

I don't know if the problem you're having is exactly the same, but please
feel free to contact me with questions.

Hope this helps!

Lorraine Ballesty, Analyst/Programmer Lead
HRIS, Information Technology Services
University of Rochester
phone:  (716) 273-2606
pager:  (716) 220-0803
e-mail: LBallesty@ACS.Rochester.edu

> -----Original Message-----
> From: Steve Rogers [SMTP:srogers@KBTOYS.COM]
> Sent: Wednesday, October 03, 2001 9:53 AM
> To:   SQR-USERS@list.iex.net
> Subject:      Re: Creating multiple reports on mainframe
>
> Peter,
>
>      Thank you for responding.  I believe that our SQR version is 4.1.7.3.
>
>      thanks,
>      steve
>
>
>
>
> Peter Clark <PGCLARK@VAC-ACC.GC.CA> on 10/03/2001 08:59:15 AM
>
> Please respond to sqr-users@list.iex.net
>
> To:   SQR-USERS@list.iex.net
> cc:    (bcc: Steve Rogers/North/KayBee)
>
> Subject:  Re: Creating multiple reports on mainframe
>
>
>
> It would be more helpful if we knew what version of SQR you are on rather
> than
> what version of PeopleSoft. I believe there is a multiple reports command
> line
> flag in the later versions of SQR (-MR) that might be helpful to you ...
> but
> then, it all depends on your version of SQR.
>
> >>> Steve Rogers <srogers@KBTOYS.COM> 2001/10/03 9:42:22 am >>>
>      Good morning all -
>
>      We are running PeopleSoft DB2 for MVS, version 7.51.  All of our
> SQR's are
> processed using the mainframe as our server.  I am attempting to create
> two
> different reports from the same SQR.  I used the DECLARE-REPORT options
> according to the SQR server Language Reference.  When I attempt to run the
> SQR,
> I am receiving the following error -
>
> (SQR 6002) Cannot open the printer file: DDN:SQROUT.SPF
> (13): Improper function argument
>
>      It appears as if the the SQROUT DD name is automatically receiving
> the .SPF
> suffix, which MVS can't seem to process.
>
>      Does anyone know how to resolve this problem?
>
>      thanks,
>      Steve