Ask Question
Help Others
Home › Forums › PeopleSoft › PeopleSoft Technical

You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

how to locate SQR Report output in a specified destination

2 replies [Last post]
Fri, 01/23/2009 - 7:52am
Guest's picture
Guest

Hi all,

I have one question in SQR .our client wants report output in a specified location .
and report name should be concatenated with current date(yyyymmdd) format.
is it possible to set path in SQR CODE or is there any other option is there?

thanks in advance

mythili

Bookmark/Search this post with
  • Buzz Up!
  • del.icio.us
  • Digg
  • Facebook
  • Google Buzz
  • Reddit
  • StumbleUpon
  • Technorati
  • Twitter
  • Yahoo
Top
  • Login to post comments
  • 6269 reads
Sat, 01/24/2009 - 6:20am
#1
Ashar's picture
Ashar
User offline. Last seen 5 years 6 weeks ago. Offline
Joined: 03/26/2008
Posts: 227
Re: how to locate SQR Report output in a specified destination

Yes. There is.. below given is the sample code..

begin-program
let $Report='C:\Temp\MyReport_' || $mydate || '.csv'
new-report $Report
Rest of the program here..
end-program

/Ashar

Top
Wed, 01/28/2009 - 4:48am
#2
Guest's picture
Guest (not verified)
Re: how to locate SQR Report output in a specified destination

thanks for your reply its working.

so many times i got solution from this site thank u very much to compshack

Top