07-08-2011 11:56 AM
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?
07-19-2011 10:02 AM
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.
02-01-2012 12:15 PM
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.
02-14-2012 11:20 AM
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...
02-15-2012 08:22 AM
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?