13 Replies Latest reply: Jan 22, 2012 8:37 AM by juliandaniel RSS

Export reports to Excel

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

 
  • Re: Export reports to Excel

    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.

    • Re: Export reports to Excel

      Thank you for your valuable answer.

    • Re: Export reports to Excel

      Hi EZakes,

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

      Greetings,
      Gerjan

      • Re: Export reports to Excel

        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.

      • Re: Export reports to 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.

      • Re: Export reports to Excel
        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

        • Re: Export reports to Excel

          Kweise,

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


          Greetings,
          Gerjan

          • Re: Export reports to Excel
            kweise

            Gerjan,

            I'm glad that's what you needed.  I wish I could remember who posted that originally so I could pass your thanks on to them.  Just keep in mind that this will break when Orion moves to supporting ASP.NET only.  Hopefully there are people on here who will be able to help the rest of us update our custom asp code to asp.net.  (I don't have time to learn asp.net!)

            Thanks,
            Kevin

    • Re: Export reports to Excel
      rgward

      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?