Traditional web-based reporting with SAS BI tools

Passing parameters to a Stored Process from WRS

Reply
Regular Contributor
Posts: 187

Passing parameters to a Stored Process from WRS

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

SAS Employee
Posts: 37

Passing parameters to a Stored Process from WRS

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.

Regular Contributor
Posts: 187

Passing parameters to a Stored Process from WRS

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.

SAS Employee RMP
SAS Employee
Posts: 52

Re: Passing parameters to a Stored Process from WRS

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...

Regular Contributor
Posts: 187

Passing parameters to a Stored Process from WRS

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

SAS Employee RMP
SAS Employee
Posts: 52

Passing parameters to a Stored Process from WRS

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?

Regular Contributor
Posts: 187

Passing parameters to a Stored Process from WRS

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

Screenshot.png

Ask a Question
Discussion stats
  • 6 replies
  • 1569 views
  • 7 likes
  • 3 in conversation