RE: [sqr-users] Output to Details(urgent)

["radhika reddy" <radhika_05@hotmail.com>]

Hi,

   By this  I could get my output in DETAILS but it's not csv file. while 
running through process scheduler i selected the Type:web and  Format to be 
CSV. But my output is opening in internet explorer which is not CSV.  when i 
tried running using type:file and format:csv, i am not getting the output at 
all.  i am getting my csv file in the output directory but my requirement is 
to get when i go and click details. any ideas?

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

_________________________________________________________________
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