I need to output a report as one snapshot file per department rather than 

one multipaged file.  To do this I am limiting the data to the report by 

changing the parameters within the SQL code of the feed query.  



This works fine and the report is showing all the correct details etc 

EXCEPT that occasionaly the graph does not update and instead it shows the 

sample data.  I have placed code in the report in the OnFormat section 

that contains the graph to refresh the graphical object.  This has reduced 

the number of times that it goes wrong from about 30% of the time to only 

2%, but I need it to be perfect as it is meant to be automated!



Does any one have any ideas as to how I can make sure that the graph shows 

the correct data?



Thanks in advance