Here's the setup for my question:
I have a Report that knows about a stored procedure I wrote in SQL Server. I then change some of the contents of that stored procedure(parameters and maybe some of the SQL, I've got a lot of trial and error stuff going on).
Is there an easy way for me to have my report know about that change? I've been removing and then re-adding my stored procedure, but there's got to be an easier way than this. Some sort of refresh data source mechanism maybe?
I have a Report that knows about a stored procedure I wrote in SQL Server. I then change some of the contents of that stored procedure(parameters and maybe some of the SQL, I've got a lot of trial and error stuff going on).
Is there an easy way for me to have my report know about that change? I've been removing and then re-adding my stored procedure, but there's got to be an easier way than this. Some sort of refresh data source mechanism maybe?