Adding Export to Excel Button on Report

jeremyeperdue
Giga Expert

We are trying to add an Export to Excel button next to Export to PDF.

Export to Excel button.png

 

Are these buttons "editable"?

1 ACCEPTED SOLUTION

jeremyeperdue
Giga Expert

We decided to add the UI Action to the Configuration item list.



1.PNG



Step 1


Ascertained the OTB code for Export to Excel.


2.PNG


Step 2


Created a new UI Action and applied it to the cmdb_ci table so the Export UI Action appears on every list screen for CIs.




3.png


and pointed the onClick to the "scoped" function we added.




It would be nice for OTB to come with the Export options at the top, but in this case, being able to export from the CI itself will save the time of drilling into a separate report.








View solution in original post

5 REPLIES 5

Mike Allen
Mega Sage

You still have your export UI Actions in the list that the report creates.   I am looking to see if adding something up top is available.


You can also schedule the report to run and send out as Excel.



I think all this code is hidden from the end user, living on the actual server in the SN data centers.


felipe_barbosa
ServiceNow Employee
ServiceNow Employee

Hi Jeremy, I tried to find this page on SNOW System UI, it seems to be a UI Page but it ´s not listed as one. The name of that particular page is sys_report_template.do and if you type your instance URL/sys_report_template.do (https://urinstance.service-now.com/sys_report_template.do) you will end up in that page.



I found an old thread in which people reached SNOW asking for changes on that particular page:



Editing sys_report_template



As far as I could see, there ´s no way for administrators to perform customizations in this page, however, you can access the HI instance and submit a feature request for ServiceNow to add this button for you. I think it worth the try.



Best regards,



Felipe


jeremyeperdue
Giga Expert

We decided to add the UI Action to the Configuration item list.



1.PNG



Step 1


Ascertained the OTB code for Export to Excel.


2.PNG


Step 2


Created a new UI Action and applied it to the cmdb_ci table so the Export UI Action appears on every list screen for CIs.




3.png


and pointed the onClick to the "scoped" function we added.




It would be nice for OTB to come with the Export options at the top, but in this case, being able to export from the CI itself will save the time of drilling into a separate report.