topic Passing parameters to a Stored Process from WRS in SAS Web Report Studio

Passing parameters to a Stored Process from WRS

bheinsius — Fri, 08 Jul 2011 15:56:57 GMT

Hi,

We need to create many WRS reports that contain a certain graph that we cannot make with WRS.

So we created a Stored Process that generates this graph, to include it in the WRS reports.

The data to graph depends on the Case that the report is for, so I assigned the prompt CASE_CODE to the Stored Process to filter data based on CASE_CODE.

Now I want WRS to call the Stored Process with a specific CASE_CODE but I can't find a way to do that.

Is there a way to do this?

Thanks,

Bart

Passing parameters to a Stored Process from WRS

TSBruce — Tue, 19 Jul 2011 14:02:20 GMT

You could include a prompt in your stored process to capture the CASE_CODE. This prompt would be surfaced via WRS and can be used in your stored process code to filter your data.

Passing parameters to a Stored Process from WRS

bheinsius — Wed, 01 Feb 2012 17:15:33 GMT

Thanks for your answer, sorry for my late reply, email notifications are not working for me and thus I never saw your reply.

The prompt is surfaced in WRS to the user but I don't want that, I want it to be passed "under the hood", passing it to the SP as http://server/SASStoredProcess/do?_program=mySP&case_code=case_001

I have asked around and it seems that this is not possible.

Re: Passing parameters to a Stored Process from WRS

RMP — Tue, 14 Feb 2012 16:20:16 GMT

If the prompt value is not being entered by the user, why cant you let the stored process retrieve the case_code from a dataset or text file?

oops just saw that this question is ages old...

Passing parameters to a Stored Process from WRS

bheinsius — Tue, 14 Feb 2012 21:19:05 GMT

How would the WRS report get that case_code in that data set or text file?

Passing parameters to a Stored Process from WRS

RMP — Wed, 15 Feb 2012 13:22:53 GMT

so you have two items in your report - a report and a graph. the report is a standard WRS object and the graph is a stored process. What determines what case a report is for?

Passing parameters to a Stored Process from WRS

bheinsius — Wed, 15 Feb 2012 13:30:07 GMT

In the report I set a filter on the case code data item: