Report Manager Excel Requirement
When publishing reports to Excel using Report Manager, you MUST have the default number of sheets in Excel set to two or higher. If it is set to one, your data will not be returned correctly; you will receive either a blank worksheet or some row headings only.
I hope this helps.