October 2, 2008 at 12:46 pm
I went back into a Visual Studio report project today. I have made numerous changes to the stored procedure that populates the report but the name is the same, as are the parameters. I cannot get it to run in the Data tab. I even rebooted my machine.
I deleted the stored proc and added it back in. It still won't run and until I get it to run here and update the fields (though they haven't changed), the report won't run. The major "odd" thing I put in the proc is that I was creating a table, populating and deleting it to calculate running balances. Didn't work well for multiple hits so I changed the table to #nisse (which I found on the Internet somewhere). Does anyone think this #nisse--which solved my multiple hit issue--code is adversely affecting the report?
Any info would be greatly appreciated.
October 2, 2008 at 12:52 pm
Please, do not cross post.
Original post is here:
http://www.sqlservercentral.com/Forums/Topic579405-150-2.aspx#bm579901
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply