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

[Quentin]

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.

[Cynthia_sas · Accepted solution]

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

[Quentin]

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.