This article details the issue related to a "#NAME?" result on a SUM Formula when rendering.
When running a report that uses total formulas (ex: SUM), if you have totals that do not return results they can have an Excel "#NAME?" result.
No result returned when rendering the report.
To alleviate this issue you can use an IFERROR Statement.
Instead of =SUM(OSRRef(F6)) you can replace this with =IFERROR(SUM(OSRRef(F6)),0).
Doing so will correct this and look something similar to the below:
- Report Designer all versions