The first part of your time is in SMS ALTER Stored Procedure, Parse it then execute it if it returns your data then go to BIDs data pane and run the stored procedure if it runs then recreate the old report with relevant changes you want and use the new stored procedure. This also gives you a tool for comparison.