Export reports to Excel

omarinfi

I need to know how to export my reports into Excel format please

Find more posts tagged with

excel

export_report

Accepted answers

kweise

Gerjan,

Actually, you can modify the report.asp file (at least until the next major release, when Orion no longer supports custom asp resources.) At one point, there was a description of how to do this in the content exchange area. You have to add a line to the report.asp file (in the \inetput\SolarWinds\NetPerfMon folder.) In the sub DoReport, you add the following before the first <% End If %>.

<td align=right><a href="<%=URL%>&Printable=TRUE&dataformat=XLS"><img src="/NetPerfMon/images/Button.RawData.gif" border=0></a></td>

Just for the record, I'm not an asp developer, but this is working in our environment (v9.1 SP3.) This has been working for us since v8.5.1, but use it at your own risk.

To be safe, I'd make a backup copy of your report.asp file first! Hope this helps.

Original Sub DoReport:

Sub DoReport
%>
<table width="100%" cellpadding="8">
<tr valign="top">
    <td colspan=2 nowrap class="PageHeader"><%=WebReport.Report.Title%><br><font size=2><%=WebReport.Report.SubTitle%></font></td>
<%    If Printable <> "T" AND Printable <> "Y" Then %>
        <td align=right><a href="<%=URL%>&Printable=TRUE"><img src="/NetPerfMon/images/Button.Printable.gif" border=0></a></td>
<%    End If    %>
</tr>
<tr valign="top">
    <td colspan=2>
    <%
        If Len(WebReport.LastError)>0 Then
            Response.Write(WebReport.LastError)
        Else
            WebReport.OutputReport
        End If
    %>
    </td>
</tr>
</table>
<%
End sub
%>

Modified Sub DoReport:

Sub DoReport
%>
<table width="100%" cellpadding="8">
<tr valign="top">
<td colspan=2 nowrap class="PageHeader"><%=WebReport.Report.Title%><br><font size=2><%=WebReport.Report.SubTitle%></font></td>
<% If Printable <> "T" AND Printable <> "Y" Then %>
<td align=right><a href="<%=URL%>&Printable=TRUE"><img src="/NetPerfMon/images/Button.Printable.gif" border=0></a></td>
<td align=right><a href="<%=URL%>&Printable=TRUE&dataformat=XLS"><img src="/NetPerfMon/images/Button.RawData.gif" border=0></a></td>
<% End If %>
</tr>
<tr valign="top">
<td colspan=2>
<%
If Len(WebReport.LastError)>0 Then
Response.Write(WebReport.LastError)
Else
WebReport.OutputReport
End If
%>
</td>
</tr>
</table>
<%
End sub

All comments

ElisabethZakes

The Administrator Guide has a section on exporting reports, beginning on page 171:

***

Orion Report Writer gives you the ability to present your created reports in a variety of different, industry-standard formats. The following formats (and extensions) are currently supported:
•Comma-delimited (*.csv, *.cdf)
•Text (*.txt)
•HTML (*.htm, *.html)
•MIME HTML, with embedded images (*.mhtml)
•Excel spreadsheet (*.xls)
•Adobe PDF (*.pdf)
•Image (*.gif)
The following procedure presents the steps required to export an open report from Orion Report Writer into any of the previously listed formats.
To export a report from Report Writer:
1. Select a report to export by clicking any of the following:
•Select a report from the file tree in the left pane
•File > Open to open an existing report
•File > New Report to create a new report.
2. Select File > Export and then click the format in which you want to export your report.
3. Check the fields in your open report that you want to export into the selected format, and then click OK.
4. Select a location to save your file.
5. Provide a File name, and then click Save.

omarinfi

Thank you for your valuable answer.

Mars

Hi EZakes,

is it also possible to export the data from the webconsole to e.g. Excel.

Greetings,
Gerjan

ElisabethZakes

Not directly, as you can from the Report Writer.

In the web console, schedule the report to be sent by e-mail, and then you can copy/paste from the e-mail into Excel.

borgan

Actually, you can do this. Log in to the Orion web site. Generate a report, and append the fiollowing to the end of the URL:

&dataformat=excel

This will open the file in Excel as long as Excel is installed on the server. You can also open a report in Word. Just repolace the word Excel with Word.

kweise

Gerjan,

<td align=right><a href="<%=URL%>&Printable=TRUE&dataformat=XLS"><img src="/NetPerfMon/images/Button.RawData.gif" border=0></a></td>

Just for the record, I'm not an asp developer, but this is working in our environment (v9.1 SP3.) This has been working for us since v8.5.1, but use it at your own risk.

To be safe, I'd make a backup copy of your report.asp file first! Hope this helps.

Original Sub DoReport:

Modified Sub DoReport:

Sub DoReport
%>
<table width="100%" cellpadding="8">
<tr valign="top">
<td colspan=2 nowrap class="PageHeader"><%=WebReport.Report.Title%><br><font size=2><%=WebReport.Report.SubTitle%></font></td>
<% If Printable <> "T" AND Printable <> "Y" Then %>
<td align=right><a href="<%=URL%>&Printable=TRUE"><img src="/NetPerfMon/images/Button.Printable.gif" border=0></a></td>
<td align=right><a href="<%=URL%>&Printable=TRUE&dataformat=XLS"><img src="/NetPerfMon/images/Button.RawData.gif" border=0></a></td>
<% End If %>
</tr>
<tr valign="top">
<td colspan=2>
<%
If Len(WebReport.LastError)>0 Then
Response.Write(WebReport.LastError)
Else
WebReport.OutputReport
End If
%>
</td>
</tr>
</table>
<%
End sub

FormerMember

Adobe PDF (*.pdf)

What I'd like to know is when is PDF coming to the web console and Report Scheduler using &dataformat=pdf via the url and Printable Version button?

Mars

Kweise,

Thanks a lot!!! this was exactly what i needed.
Again happy mamangement created!!

Greetings,
Gerjan

bshopp

It is on the list to do, but not in the next version

juliandaniel

When will Excel get added as an export option like PDF. We have had several releases now and Excel is still not an option