Okay so you want to kick off an SSRS report that apparently has two datasets that you capture (are you combining these two datasets? or showing them separately?). ...
the insert into the table from the executed stored procedure will work, done it before, just make sure the returned columns match your table's columns, or you'll fail on the...