RE: [sqr-users] Output to Details

["Pink, Michael" <Michael.Pink@pgnmail.com>]

I am assuming you called the procedure.  Try taking the spaces out of
your file name.

-----Original Message-----
From: sqr-users-bounces+michael.pink=pgnmail.com@sqrug.org
[mailto:sqr-users-bounces+michael.pink=pgnmail.com@sqrug.org] On Behalf
Of radhika reddy
Sent: Tuesday, September 14, 2004 11:58 AM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] Output to Details



Michael,

  I am on Peoplesoft 8.3, peopletools 8.14.

I am running on unix,I gave the following command:-

#ifdef UNIX

          let $File2 = '45 day outlook.csv'

#endif
       let $file_name = &PRCSOUTPUTDIR || '/' || $file2

but i am not getting the csv file in Details(view log/trace). am i
missing 
something?

Thanks,
Radhika

>From: "Pink, Michael" <Michael.Pink@pgnmail.com>
>Reply-To: "This list is for discussion about the SQR database 
>reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>To: "This list is for discussion about the SQR database
reportinglanguage 
>fromHyperion Solutions." <sqr-users@sqrug.org>
>Subject: RE: [sqr-users] Output to Details
>Date: Tue, 14 Sep 2004 11:15:22 -0400
>
>If you are on 8.x you can use the following.
>
>Add this procedure:
>BEGIN-PROCEDURE Get-Prcs-Output-Dir
>
>BEGIN-SELECT ON-ERROR=SQL-ERROR
>PRCSOUTPUTDIR    &PRCSOUTPUTDIR
>
>FROM PSPRCSPARMS
>WHERE PRCSINSTANCE = #prcs_process_instance
>END-SELECT
>
>END-PROCEDURE Get-Prcs-Output-Dir
>
>  Then this call:
>do Get-Prcs-Output-Dir
>
>Then create the file:
>       let $file_name1   = 'name.csv'
>       let $file_name = &PRCSOUTPUTDIR || '/' || $file_name1
>
>This will put it in the process monitor and the report manager.
>
>
>-----Original Message-----
>From: sqr-users-bounces+michael.pink=pgnmail.com@sqrug.org
>[mailto:sqr-users-bounces+michael.pink=pgnmail.com@sqrug.org] On Behalf
>Of radhika reddy
>Sent: Tuesday, September 14, 2004 10:31 AM
>To: sqr-users@sqrug.org
>Subject: RE: [sqr-users] Output to Details
>
>
>
>
>Yes and i am running through process scheduler.
>
>
> >From: "Pink, Michael" <Michael.Pink@pgnmail.com>
> >Reply-To: "This list is for discussion about the SQR database
> >reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
> >To: "This list is for discussion about the SQR database
>reportinglanguage
> >fromHyperion Solutions." <sqr-users@sqrug.org>
> >Subject: RE: [sqr-users] Output to Details
> >Date: Tue, 14 Sep 2004 10:25:30 -0400
> >
> >Are you using this through Peoplesoft?
> >
> >-----Original Message-----
> >From: sqr-users-bounces+michael.pink=pgnmail.com@sqrug.org
> >[mailto:sqr-users-bounces+michael.pink=pgnmail.com@sqrug.org] On
Behalf
> >Of radhika reddy
> >Sent: Tuesday, September 14, 2004 9:49 AM
> >To: sqr-users@sqrug.org
> >Subject: [sqr-users] Output to Details
> >
> >
> >Hi,
> >
> >    My Sqr Report creates a spreadsheet file. At present i am getting
>my
> >spreadsheet file in Unix server. Is there any way that the csv file
> >could be
> >put out such that the user can click on Details and automatically get
> >the
> >file?   Otherwise it has to be downloaded and opened, then saved.
>Sort
> >of
> >cumbersome.
> >
> >Can it be done?
> >
> >Thanks,
> >Radhika
> >
> >_________________________________________________________________
> >Don't just search. Find. Check out the new MSN Search!
> >http://search.msn.click-url.com/go/onm00200636ave/direct/01/
> >
> >
> >_______________________________________________
> >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
>
>_________________________________________________________________
>Don't just search. Find. Check out the new MSN Search!
>http://search.msn.click-url.com/go/onm00200636ave/direct/01/
>
>
>_______________________________________________
>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

_________________________________________________________________
On the road to retirement? Check out MSN Life Events for advice on how
to 
get there! http://lifeevents.msn.com/category.aspx?cid=Retirement


_______________________________________________
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