One other suggestion. While not the best solution, at the end of the macro add ThisComponent.close(1)
. That will close the blank .odt & still leave the report visible.
Edit: Just tried at beginning of macro and blank screen appeared for shorter amount of time. Report still generated.