search cancel

How to Export Report Data to a CSV?

book

Article ID: 53709

calendar_today

Updated On:

Products

CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER Service Accounting SERVICE ASSURE CA Service Catalog CA Service Management - Service Desk Manager CA Unicenter NSM

Issue/Introduction

Description:

This technical document outlines the methods to export report data to a CSV.

Solution:

There are two ways to export report data to a CSV:

  1. When logged in as an administrative user that has access to report builder:

    1. Navigate to Administration -> Report Builder -> Data Views.

    2. Select the notepad to export the report data to a CSV.

      <Please see attached file for image>

      Figure 1

  2. To allow end users the ability to export report data directly from the report:

    1. Edit the Data View and select 'Column Rules'.

      <Please see attached file for image>

      Figure 2

    2. Select 'Advanced'.

      <Please see attached file for image>

      Figure 3

    3. Confirm 'View/Modify POST-Action' is selected and paste the following text:

      // export to Excel
      aExcel="<a href='javascript:getCSVData_Excel()' class='t'><img src='images/fileicons/xls.gif' style='border:0'> Export</a>";
      aExcel="<span style='width:400px'></span>"+aExcel;
      document.body.insertAdjacentHTML("afterBegin",aExcel);

      <Please see attached file for image>

      Figure 4

    4. When the report is viewd the 'Export' link is exposed.

      <Please see attached file for image>

      Figure 5

    5. If you receive a javascript error after selecting 'Export' you will need to set the following Internet Explorer browser security setting to either 'Enable' or 'Prompt'.

      <Please see attached file for image>

      Figure 6

Environment

Release:
Component: USVCT

Attachments

1558711603477000053709_sktwi1f5rjvs16sa6.gif get_app
1558711601432000053709_sktwi1f5rjvs16sa5.gif get_app
1558711599301000053709_sktwi1f5rjvs16sa4.gif get_app
1558711596750000053709_sktwi1f5rjvs16sa3.gif get_app
1558711594922000053709_sktwi1f5rjvs16sa2.gif get_app
1558711592572000053709_sktwi1f5rjvs16sa1.gif get_app