SSRS 2008 using temp files and stored procedures
Posted on 2014-09-11
I'm working on something I've never done before and I don't quite know how to do it. I have a report that I'm rewriting in SSRS. Because it lists a combination of unlike items I thought it best to run a stored procedure ahead of time and enter the final counts and totals into a temp table. I have 2 questions on how to do this.
Because multiple people could run this file at the same time with different parameters, how do I insure the table the values are being written into are unique for the user running the report? Do I have to call the table something special or do something special with it? One person could run it with current dates and one person while someone else is running it with last year dates and a single person.
Second, how do I add the stored procedure to a SSRS report and make sure it runs before the report runs?