Desktop productivity for business analysts and programmers

Stored Process to generate PDF Report

Reply
Contributor
Posts: 33

Stored Process to generate PDF Report

Hi,

I have developed a program which generates a PDF report using the PROD REPORT and ODS PDF Statement.

I want to create a stored process and deploy it on the portal for the end users to execute and see the report.

I do the following.
1) Right click on the empty space in the EG Project and select "Create Stored Process".
2) It walks me thru the wizard asking for parameters and the server where it will be run.
3) One screen asks for Streaming Output- I select this option and create the stored process.
4) I log on to the stored process explorer, and click on the stored process i have created.
5) It asks me for the parameters, i key in the paratmeter, go to the advance menu and select PDF as the output method.

When i run the stored process the stored process is run successfully but the report does not open.

Anything that i migth be missing.

OS: AIX
SAS : 9.1.3

Regards
Russell
Community Manager
Posts: 2,691

Re: Stored Process to generate PDF Report

I think you want to use the transient/package as the output type.

Streaming is more useful for HTML output, similar to classic SAS/IntrNet applications that use _WEBOUT.

Chris
SAS Super FREQ
Posts: 8,716

Re: Stored Process to generate PDF Report

Hi:
Another point to keep in mind is that while you can create the stored process and run the stored process in EG to get PDF results, you may not be able to get PDF results in all the various client applications.

For example, if you run your stored process in PowerPoint or Web Report Studio, those client applications can only "receive" SASReport XML output from stored processes.

If you use EG or the Information Delivery Portal or the SAS Stored Process Web Application to run your stored process, then you can receive PDF results with those client applications.

If you use the SAS Stored Process Web Application to run your stored process, you may need to use the STPSRV_HEADER function to tell the SPWA that you are returning PDF results to the browser.

As long as your stored process is executed in EG, however, you should be OK getting PDF results. Changing the result type to transient, as Chris recommends is a good idea. (But even with transient output, I do not believe you can receive PDF results from a stored process in PowerPoint or Web Report Studio.)

cynthia
Contributor
Posts: 33

Re: Stored Process to generate PDF Report

Hi,

My requirement was to create the stored process and publish on the web thru IDP. I have been successful in doing so.

Now i have the stored processes in the IDP, the user when clicks the link is presented with the same interface as with the Stored Process Explorer.

How do i supress the advance menu.

Regards
Russell
SAS Super FREQ
Posts: 8,716

Re: Stored Process to generate PDF Report

Hi:
I'm not sure what you mean by "advance menu", but if you mean the form which prompts the users for information about the stored process, this Tech Support article has information on how to suppress the execution options:
http://support.sas.com/techsup/technote/ts764.pdf

cynthia
Ask a Question
Discussion stats
  • 4 replies
  • 111 views
  • 0 likes
  • 3 in conversation