Conditional Formatting Not Updating in Reports?


I'm finding that conditional formatting is not consistently updating in reports, and my staff are complaining about it. See for example below, the "Rollinson Downstairs..." task highlighted has no conditional formatting even though the date has passed. If I open the Rollinson sheet, it then updates and updates the report.

Shouldn't have to do this! Is this a known bug / issue?