The most likely reason why the stored process fails is that you do not have Package output selected. SAS Web Report Studio does not support Streaming stored processes.
I also recommend that you review this SAS note:
http://support.sas.com/kb/47/839.html
... View more