Good Day
Does anyone export reports from the orion reports?? What I am trying to do is find a way that an orion user can export report outputs to excel without copying the content from the printable version link off the web page.
Thank You
You can export Orion reports to Excel. With a report open in Report Writer, go to the Report menu, choose the Data Format option and select 'raw data" before you export. That way, Excel can process the data correctly.
Thank you
This method I was aware was available, what I am looking for is a way for the web user to export without access to the server and the report writer.
Determine the URL for the report that the client is requesting and then place this on the end of the URL:
&dataformat=XLS
A pop-up dialog box will be presented, click Open or Save and choose a location.
Hope that is what you are looking for.
Has anyone got this to work with Report Scheduler without having Excel installed on the Orion server? It is my understanding a check is made to determine if Excel exists on the system so you need to burn a MS Office license to exploit the &dataformat=xls option. Anybody come up with a workaround?