Your SAS programs, embedded in web apps and elsewhere

What sort of stored process output can web report studio present?

Accepted Solution Solved
Reply
PROC Star
Posts: 1,325
Accepted Solution

What sort of stored process output can web report studio present?

Hi,

As I understand it, when Web Report Studio (WRS) invokes a stored process, the only output format it can receive from the stored process is the SASREPORT (xml) format. Is that correct?  And also, it looks like WRS can only receive PACKAGE results, not streaming results?

The implication of this is that if I have a stored procedure, and want the user to be able to specify _ODSDEST= pdf | rtf | html, the user CANNOT use WRS to invoke the stored procedure, because WRS is only happy receiving _ODSDEST=SASREPORT. Correct?

So basically, WRS can receive (and create, and store, and edit) reports in this SASREPORT (xml) format.  And that is really the only file format "supported" by WRS.  (with I guess exception that if you register a pdf, looks like its possible for WRS to display it, and could create a pdf through "print" command).

Thanks,

--Q.



Accepted Solutions
Solution
‎05-18-2012 02:13 PM
SAS Super FREQ
Posts: 8,868

Re: What sort of stored process output can web report studio present?

Hi:

  Essentially, this understanding is correct. SAS Web Report Studio is "geared" to use SAS Report XML as the format for the reports which it displays inside the WRS interface. "Streaming" results are sent to a client browser using the HTTP protocol -- since WRS runs under the control of a Java-based application, it does not communicate using the HTTP protocol to receive results from a stored process.

  The nice thing about creating a stored process with package results, in general, is that with package results, you can put multiple outputs into the package (conceptually like a zip archive) and then you could publish the package to a webDAV repository or email the result package or send the package to a client application that knows how to deal with the package.

  Suggest you read the Stored Process Developer's guide for more thorough info.

cynthia

View solution in original post


All Replies
Solution
‎05-18-2012 02:13 PM
SAS Super FREQ
Posts: 8,868

Re: What sort of stored process output can web report studio present?

Hi:

  Essentially, this understanding is correct. SAS Web Report Studio is "geared" to use SAS Report XML as the format for the reports which it displays inside the WRS interface. "Streaming" results are sent to a client browser using the HTTP protocol -- since WRS runs under the control of a Java-based application, it does not communicate using the HTTP protocol to receive results from a stored process.

  The nice thing about creating a stored process with package results, in general, is that with package results, you can put multiple outputs into the package (conceptually like a zip archive) and then you could publish the package to a webDAV repository or email the result package or send the package to a client application that knows how to deal with the package.

  Suggest you read the Stored Process Developer's guide for more thorough info.

cynthia

PROC Star
Posts: 1,325

Re: What sort of stored process output can web report studio present?

Posted in reply to Cynthia_sas

Thanks Cynthia!

Took me a while to figure out why my stored process which ran fine under SPWA was not returning results (or errors) when I ran it from WRS.  Then luckily I happened to try _odsdest=SASREPORT, everything appeared, and I started reading up on what might be going on.... Very much appreciate your response.

-Q.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 503 views
  • 0 likes
  • 2 in conversation