[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] naming multiple reports
- Subject: RE: [sqr-users] naming multiple reports
- From: "Jamie Harris" <JHarris@frederick.edu>
- Date: Fri, 28 Jan 2005 17:13:26 -0500
- Delivery-date: Fri, 28 Jan 2005 17:13:24 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
What if you had multiple reports "open" at once and needed to be able
to use the "use-report" command to go between them?
I have a report that produces a report of successes, a report of errors
and a report of warnings. Each row of data could potentially be one of
the three, so I can't simply process all of report 1's data then say
"new-report" to start the next one.
I haven't been able to find a way to do that without specifying with -f
all the different names and the path to put them in (which results in a
command line that's too long for the Peoplesoft process scheduler).
Any thoughts?
-----------------------------------------------------
James Harris
Junior Systems Programmer/Analyst
Information Technology Division
Frederick Community College
-----------------------------------------------------
>>> jwomeldo@fastenal.com 1/28/2005 12:18 PM >>>
Use the New-Report command as described in this document:
http://www.ontko.com/sqr/sqrcard4.html
-----Original Message-----
From: sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org]On Behalf Of
Susan Haberman
Sent: Friday, January 28, 2005 10:26 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] naming multiple reports
Hi,
I am trying to name multiple reports instead of using the default
naming convention reportname_instance_#.lis
In the process scheduler manager>use>process definitions>override
options I have tried several options:
1) Parameter List: Append -MR 5 -FDedReg.lis -FLibMut.lis
-FCombFnd.lis
-Fcwufcu.lis -Fwsecu.lis
This sqr runs successfully but uses default name.
2) Command Line: Append -MR 5 -FDedReg.lis -FLibMut.lis -FCombFnd.lis
-Fcwufcu.lis -Fwsecu.lis
and
Command Line: Override -MR 5 -FDedReg.lis -FLibMut.lis
-FCombFnd.lis -Fcwufcu.lis -Fwsecu.lis
and
Parameter List: Append -MR 5
Command Line: Append -FDedReg.lis -FLibMut.lis -FCombFnd.lis
-Fcwufcu.lis -Fwsecu.lis
These processes error with the following message: Process Request
shows
status of 'INITIATED' or 'PROCESSING' but no longer running
Has anyone successfully managed to rename the output files? We are
running Oracle on a Unix server.
Thanks for your help!
_______________________________________________
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