March 13, 2013 at 11:45 am
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"?
Thanks
March 21, 2013 at 8:37 am
This is an issue I caused myself by using a stored procedure to insert rows into a temp table.
Since there is no way to control in what order report elements, datasets, etc run, sometimes the report grabbed the old data from the tmp table before I had a chance to delete and re-insert.
So re-wrote stored procedure to just return the id list I was looking for, that now populates my internal parameter and works fine.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply