If you use any Javascript keywords or built in function names, like VAR, CLASS, DO, ELSE, THROW, DATE, MATH, STRING, OBJECT, NULL, CONST, CASE, NEW, TRY, VOID, WHILE, SUPER, FOR, etc. as parameter/macro variable names, this can cause you to get an "error on page". The stored process may work in EG or the SAS Add-in for Office but it might fail in other clients like WRS or the Portal.
http://support.sas.com/techsup/unotes/SN/018/018502.html
Also, if your stored process is running PROC REPORT and has LINE statements -- the SP will work fine in the other clients, generally, but not in WRS -- most times, you won't see any output at all. A few times, I got a Java exception when I tried this.
And if your SP is using FILE/PUT statements to _WEBOUT, you might have problems:
http://support.sas.com/techsup/unotes/SN/013/013599.html
http://support.sas.com/techsup/unotes/SN/019/019063.html
http://support.sas.com/faq/039/FAQ03934.html
Other possibilities:
http://support.sas.com/techsup/unotes/SN/018/018214.html (your SP might contain < or > tags)
http://support.sas.com/techsup/unotes/SN/016/016056.html (stray & might cause problems -- there's a hot fix for this -- but I'd check with Tech Support first or your Administrator to see if the hot fix has already been applied)
http://support.sas.com/techsup/unotes/SN/020/020225.html (you see an empty row of cells)
http://support.sas.com/techsup/unotes/SN/020/020798.html (call define with style on _ROW_ might not be respected)
http://support.sas.com/techsup/unotes/SN/019/019980.html (SP with style(data) -- generally PROC PRINT)
To find most of these hits, I went to:
http://support.sas.com/techsup and entered this text into the search box:
stored process fail Web Report Studio
Your best bet for a quick response is to contact Tech Support for help and to find out how to turn on and check the log for your SP execution.
cynthia