CA Service Management

 View Only
  • 1.  Save reports published in Dashboard

    Posted Oct 08, 2015 03:49 AM

    Hi All,

     

    I am trying to save or export the reports published in dashboard, I have the print option enabled, yet am not able to save.

     

    We are using Service Catalog 12.7. Instead of copying the result, is there any other way to export the report.

     

    If the print option is working, we can use Save to PDF. That also seems not working.

     

    Please suggest on the same.



  • 2.  Re: Save reports published in Dashboard

    Posted Nov 10, 2015 05:28 PM

    Hi Divya,

     

    When you unselect 'Hide Print Button' in the data view, a 'Print Report' will be exposed in the report which only works in IE.

     

    You can export a report to a pdf or csv as an administrator from Administration > Report Builder > Data Views. From the dashboard there really isn't a supported way to export the same however we could suggest the following:

     

    1) Leverage Windows Print > Save as PDF functionality

    2) Include an excel export link in the data view:

     

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

      b. Select 'Advanced'

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

     

    // 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);

     

      d. If you receive a javascript error after selecting the 'Export' link you will need to enable 'Initialize and script ActiveX controls not marked as safe' within IE's security settings

     

    Note: This will only work in IE as ActiveX controls are not natively supported in Chrome/Firefox.

     

    3) If your reports do not include any user prompting variables you could include an export to PDF link:

     

      a. Navigate to the data view and select the PDF link under the 'Action' column

      b. In the new window copy the URL and remove '<uuid string>.pdf' so it looks similar to the following:

     

    http://hostname:8080/usm/wpf?Node=icguinode.reportsgenericdataviewdisplaypdf&Args=569a26b44da7e6a5d596b14fb2a55f12-719e1442855774366&Args=&Args=-1&Args=1&cache=10

     

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

      d. Select 'Advanced'

      e. Confirm 'View/Modify POST-Action' is selected and paste the following using the URL from step b:

     

    // export to pdf

    aPdf="<a href='http://hostname:8080/usm/wpf?Node=icguinode.reportsgenericdataviewdisplaypdf&Args=569a26b44da7e6a5d596b14fb2a55f12-719e1442855774366&Args=&Args=-1&Args=1&cache=10' target='_blank' class='t'>Export to PDF</a>";

    aPdf="<span style='width:400px'></span>"+aPdf;

    document.body.insertAdjacentHTML("afterBegin",aPdf);

     

    Thanks!

    Jason



  • 3.  Re: Save reports published in Dashboard

     
    Posted Nov 16, 2015 05:29 PM

    Hi Divya - Did Jason's response help answer your question? If so please mark as Correct Answer. Thanks, Chris