Hello BI Tool community,
I am wondering if anyone out there has had success with exporting a BI report to excel using the "Download to Excel" button on the prebuilt report page that results in a usable format for Excel.
Our PSAT/SAT practice test report in Illuminate when downloaded to PDF:
When using the Download to Excel button:
As you can see the excel report is useless. I want to be able to export the PSAT/SAT report above into a usable Excel format that is similar to the matrix report. I have found this help doc online, but wondered if there were any Illuminate users out there that have had experience doing this prior to experimenting.
Any ideas/suggestions? Would I create a subreport that could be connected to execute when the Download to Excel button is clicked? Any information/insight would be helpful.
Please sign in to leave a comment.