I have a report on SSRS 2008 R2, 2 server scale-out.
The tablix on the report is driven by a dataset that looks for "id in @parameter"
The parameter is internal, multivalued and is generated from a straight SQL select from a tmp table
This tmp table is populated fron a stored procedure defined in another dataset with the report parameters passed to it to derive the record id's I want to show.
Works like a champ, but:
The first time I run it from the report server, I get all the expected values in the tablix for the parameters chosen. If I close/re-open report and run with let's say a different date period, the report comes back with the previous report's values, even though the underlying tmp SQL table did change/update and other expressions on the report change accordingly.
If I close/reopen Internet Explorer, then re-run the report with the new parameters, I get what is expected.
I have caching on the report disabled, thinking session cookie? Is there a downside to setting UserSessionCookie=FALSE in [dbo].[ConfigurationInfo]? Is this even the issue or is this just "the way things work"?