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.

Sending SQR output to new window

3 replies [Last post]
Guest's picture
Guest

I am trying to send SQR output, submitted by Peoplecode to a new window for the user. My peoplecode submits the request, I have my SetOutputOption to ("WINDOW","PDF","",&MySQQR). It will submit and run, but no new window. We can do this via the normal submitting the job method so it appears that our PSRENSRV is set up correctly. The peoplecode is housed in Component peoplecode during a fieldchange event.

Any ideas?

CompShack's picture
User offline. Last seen 6 years 23 weeks ago. Offline
Joined: 12/09/2007
Posts: 167
Re: Sending SQR output to new window

So your SetOutputOption function is working correctly BUT the PDF report opens in the same window browser not in a new one?

Also, what tools version are you on?

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

sb's picture
sb (not verified)
Re: Sending SQR output to new window

Thanks for your response. We are on tools 8.47. The peice of code is below. The messagebox for a status = 0 does display, so I can't see any errrors. It gets fired from a push button, field change event. I can run this same report via the Process Scheduler to a window. Any help is appreciated.

&VRTRoster = CreateProcessRequest("SQR Report", &VRPMR004);
&VRTRoster.RunControlID = "VRT_Pcode";
&VRTRoster.SetOutputOption("WINDOW", "PDF", "", &VRPMR004);
&VRTRoster.Schedule();

If &VRTRoster.Status = 0 Then
/* Continue */
MessageBox(0, "", 99999, 99, "Process returned SUCCESS status of %1", &VRTRoster.Status);
Else
MessageBox(0, "", 99999, 99, "Process returned error of %1", &VRTRoster.Status);
/* Error Processing */
End-If;

CompShack's picture
User offline. Last seen 6 years 23 weeks ago. Offline
Joined: 12/09/2007
Posts: 167
Re: Sending SQR output to new window

sb,

Sorry to answer you with yet another question but I would need to know if you are able to view the PDF report in the browser window 1st. If you can, then we need to figure out how to open it in a new window. It will be a different story if the report is not showing up at all.

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog