I've got a dashboard created in 4.1 SP4 which uses a crystal report as it's datasource via live office. The refresh options for the report are set as 'Latest Instance: From the latest instance scheduled by Any User' and the report is scheduled to run every hour within business objects.
The problem I've got is when I refresh the report within dashboard it looks as though the report is being run adhoc and the resulting spreadsheet being pushed back to the dashboard. I thought it would just pick up the latest instance of the report from business objects.
Not sure what I've done wrong. Can anyone point me in the right direction.