Export SQL Report to Excel?

We need a way to generate excel exports of Orion reports from the website, without using the report tool 'export' feature.

Is there any hidden functionality for this?

Currently, the staff that utilize our reports are copy/pasting everything to notepad, then to excel, doing an excel space-delimited import.

Our only browser (IE) isn't able to copy tables neatly like Firefox can.

-JP

Find more posts tagged with

web_console

export

excel

report

Accepted answers

Thanks, search feature!
Adding &outputformat=excel to the end of my query url worked great;

http://SOMEHOST/NetPerfMon/Report.asp?Report=7_day_Critical_Availability&dataformat=excel

Now maybe I can get .xls docs emailed weekly

All comments

Thanks, search feature!
Adding &outputformat=excel to the end of my query url worked great;

http://SOMEHOST/NetPerfMon/Report.asp?Report=7_day_Critical_Availability&dataformat=excel

Now maybe I can get .xls docs emailed weekly

Quick Links