Reporting Services Cache Issue?

[sqlguru89]

Hi Friends,

I have many datasets for a report -- some are stored procedures with parameters and other are straight SQLs with parameters. In fact, the stored procedures truncate and populate certain tables and the SQLs are based on the tables populated by stored procedures. (I had to do this as stored procedure can return only one set of data).

Issue: When we run the report, some data regions shows the data for the previously run report's data (with different parameters). I checked the tables that are propulated by stored procedure(s) -- they contain the data as per the current parameter.

Question: How do we set/configure the reporting service to get, each and every data afresh from database tables/stored procedures (I think, cache should be completely disabled?!)

Any help/suggestion is highly appreciated.

To-be-sqlguru