August 13, 2009 at 7:33 am
Hi
I've got a simple tabular (sproc sourced) report thats on auto-refresh every 10 seconds
The report uses a Muti Value drop-down where the Key/Description pairs are sourced from another sproc.
The sproc that feeds the Multi Value drop-down works by selecting a list of items that changes (can both add to / delete from) over time (e.g. distinct list of items sold 'today').
I'm finding that once a user opens the report, clicks an initial set of selections and leaves the report running ... sometimes the keys being sent to the report sproc (and therefore the data shown on the main report) don't match those selected on the Multi Value drop-down.
I assume that the auto-refresh is refreshing both the datasets for the report and the parameter and can only think the indexing used to match up the Multi Value drop-down labels with the keys in the parameter dataset get out of sync ?!?
Has anybody else hit such a problem and found away round it ?
Rgds
Martin
August 13, 2009 at 9:14 am
I've not experienced this, but I do have a troubleshooting step for you, just to make certain you know what's happening. Have you tried to run a trace on the datasource, or taken a look at the execution history for the report to verify what you think is happening is truly happening? Perhaps both datasets are not being refreshed as you believe they are.
-Luke.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply