I've just tried this process and it works great for datasets that do not use stored procedure.  When I use a stored procedure, RS cannot validate the procedure when I deploy and changes command type from stored procedure to text.  Once on the server, the report can't execute the stored procedure(s) since they are now text. 

Suggestions?