Do you have Excel installed on your Reporter host?
No I dont. No office suite installed on server
It is required for exporting reports in Excel format.
See requirements here under "Required Software"
https://support.quest.com/technical-documents/enterprise-reporter/3.1/release-notes/2#TOPIC-952831
I just installed excel on the server but still not getting xlsx output.
I just installed excel on the server but still not getting xlsx output.
Scheduled reports require Excel to be installed on the server but for the reports being run with PowerShell ensure it is installed on the machine running the command. Thanks!
I installed excel on the server and still wont work. I even ran the command on my laptop that had excel before, same result.
Ok, there may be another issue. The Enterprise Reporter team will test this scenario and be back to you soon with further information. Thanks!
One of my team members has just reminded me that the Invoke-ERReport cmd does not support XLSX. The only supported formats are PDF and CSV. Please see product documentation. https://support.quest.com/technical-documents/enterprise-reporter/3.1/configuration-manager-user-guide/53#TOPIC-930530
You can generate reports in either PDF or CSV format, with the CSV file as a comma delimited file. Reports can be useful as record keeping or for disaster recovery. The complete report information obtained from the Get-ERReport cmdlet is required when performing the export. For more information, see Getting report information.