RE: [sqr-users] Multiple PDF reports with variable report name

["Tritt, Merrill" <MerrillTritt@spherion.com>]

You missed the END-SETUP at the end of the block.

Merrill

-----Original Message-----
From: Wes Williams [mailto:wes@Princeton.EDU]
Sent: Tuesday, November 04, 2003 7:47 AM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] Multiple PDF reports with variable report name


Begin-Setup
  Declare-report one
  end-declare
  Declare-Layout Default
  orientation=landscape  
  Max-Lines = 66
  Max-Columns = 100
End-Declare

Wes Williams
Manager Facilities Mgt. Systems
Princeton University
609-258-7027
 

-----Original Message-----
From: MGreene@marinerhealthcare.com
[mailto:MGreene@marinerhealthcare.com] 
Sent: Monday, November 03, 2003 5:10 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Multiple PDF reports with variable report name


Thanks for the code, but am getting error messages on the declare
statements.
Can you elaborate on what you are using for your declare-report,
declare-layout, etc.?
Much appreciated.
Marsha
________________________________
Marsha Greene
IT PeopleSoft Financial Developer
Mariner Health Care, Inc.
E-mail: mgreene@marinerhealthcare.com




----- Message from "Wes Williams" <wes@Princeton.EDU> on Fri, 31 Oct
2003
12:17:57 -0500 -----
                                                           
      To: <sqr-users@sqrug.org>                            
                                                           
 Subject: RE: [sqr-users] Multiple PDF reports with        
          variable report name                             
                                                           

Here is snippet from a report that creates multiple pdf's based on a
room number which I load into the array and then process.

CREATE-ARRAY Name=inspectors Size=20
               Field=inspector:Char
               Field=dateinsp:date

  CREATE-ARRAY Name=rooms Size=20000
               Field=room:Char

 Alter-Printer Font=4 Point-Size=8


 do number_of_rooms_inspected(#rcntr)
  while #cntr < #rcntr
        let $room = rooms.room(#cntr)
        let $report = $room||'.pdf'
        new-report  $report
        use-report one
        do update_date($room)
        do Item


HTH
Wes

Wes Williams
Manager Facilities Mgt. Systems
Princeton University
609-258-7027


-----Original Message-----
From: MGreene@marinerhealthcare.com
[mailto:MGreene@marinerhealthcare.com]
Sent: Friday, October 31, 2003 11:58 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Multiple PDF reports with variable report name

I'm attempting to create multiple PDF reports based on differing Corp
codes, that use the same report layout, in a single SQR, with the
corpcode as part of the  label in the name output.  Currently using SQR
4,
with
PeopleSoft 8.40.    I have a Corp. file where I select distinct corp
codes, and want to insert those codes into the name output, so the
result
will
be something like:     Programname_corpcode_processinstance.pdf   as
output
to the process monitor.

I also want to avoid having to hardcode the corpcodes as individual
report names using a Declare-report command in the SQR, so I can add
extra
Corps to the corp.file and not have to maintain those new 'names' to the
declare-report statements in the SQR, everytime the company decides to
do service work for another company.  I know I will probably need to add
a
command line of -MR x   for the number of output reports expected + 1
for the default.   (thanks for all the past archives).

Any suggestions?
Marsha Greene
________________________________
IT PeopleSoft Financial Developer
Mariner Health Care, Inc.
E-mail: mgreene@marinerhealthcare.com





_______________________________________________
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