# Advanced Reports

**URL:** https://community.sapphireims.com/c/platform/advanced-reports/33.md

[Latest](https://community.sapphireims.com/latest.md) · [Categories](https://community.sapphireims.com/categories.md) · [Tags](https://community.sapphireims.com/tags.md)

---

## [About the Advanced Reports category](https://community.sapphireims.com/t/about-the-advanced-reports-category/91)

<div class="topic-metadata">

**Author:** [@harish](https://community.sapphireims.com/u/harish)\
**Replies:** 0

</div>

---

## [If AR report data not loaded, what need to be check?](https://community.sapphireims.com/t/if-ar-report-data-not-loaded-what-need-to-be-check/646)

<div class="topic-metadata">

**Author:** [@Haranath](https://community.sapphireims.com/u/Haranath)\
**Replies:** 0\
**Last updated:** [May 26, 2021, 10:23am UTC](https://community.sapphireims.com/t/if-ar-report-data-not-loaded-what-need-to-be-check/646 "2021-05-26T10:23:07Z")

</div>

For ITSM Reports, SD records should be present in the respective project. For CMDB Reports, Assets should be present under CMDB Module. Check Repository log for custom type report templates like Call summary, chart, Sto…

---

## [What are the supported Export types in AR?](https://community.sapphireims.com/t/what-are-the-supported-export-types-in-ar/647)

<div class="topic-metadata">

**Author:** [@Haranath](https://community.sapphireims.com/u/Haranath)\
**Replies:** 0\
**Last updated:** [May 26, 2021, 10:24am UTC](https://community.sapphireims.com/t/what-are-the-supported-export-types-in-ar/647 "2021-05-26T10:24:32Z")

</div>

Following are the supported Export types in AR in SapphireIMS, PDF – supported for all template types. Excel - supported for all template types. Row merge Excel - supported for custom tabular reports (Call summary, As…

---

## [How to enable SSL in AR?](https://community.sapphireims.com/t/how-to-enable-ssl-in-ar/645)

<div class="topic-metadata">

**Author:** [@Haranath](https://community.sapphireims.com/u/Haranath)\
**Replies:** 0\
**Last updated:** [May 26, 2021, 10:19am UTC](https://community.sapphireims.com/t/how-to-enable-ssl-in-ar/645 "2021-05-26T10:19:41Z")

</div>

Stop the SapphireIMSAR Service. Place the server.keystore file in AR installed Path/ReportingFiles/SSL Folder. Go to AR installed Path/ReportingFiles/CommonYaml and open the application.yml file in text editor. …

---

## [If reports are not getting triggered, what are the troubleshooting steps?](https://community.sapphireims.com/t/if-reports-are-not-getting-triggered-what-are-the-troubleshooting-steps/535)

<div class="topic-metadata">

**Author:** [@Haranath](https://community.sapphireims.com/u/Haranath)\
**Replies:** 0\
**Last updated:** [April 6, 2021, 10:16am UTC](https://community.sapphireims.com/t/if-reports-are-not-getting-triggered-what-are-the-troubleshooting-steps/535 "2021-04-06T10:16:36Z")

</div>

Need to check SMTP/Exchange settings configured is correct or not. You may check with test mail. Need to check whether scheduler and notification service is running or not Execution of the custom report should work fine…

---

## [What are the supported charts and report types supported in SapphireIMS advanced reports?](https://community.sapphireims.com/t/what-are-the-supported-charts-and-report-types-supported-in-sapphireims-advanced-reports/505)

<div class="topic-metadata">

**Author:** [@Haranath](https://community.sapphireims.com/u/Haranath)\
**Replies:** 0\
**Last updated:** [March 31, 2021, 6:04am UTC](https://community.sapphireims.com/t/what-are-the-supported-charts-and-report-types-supported-in-sapphireims-advanced-reports/505 "2021-03-31T06:04:20Z")

</div>

Following are the supported charts in AR in SapphireIMS, Bar 2d/3d Pie Donut Line Stacked bar Waterfall Multi axis charts Multi Series charts (Bar, stacked bar, zoom line ) Angular Chart and supported reports types a…

---

## [I understand advanced report service runs on different HTTPS port and customer wants to avoid exposing it to external world. Is there any way to handle it?](https://community.sapphireims.com/t/i-understand-advanced-report-service-runs-on-different-https-port-and-customer-wants-to-avoid-exposing-it-to-external-world-is-there-any-way-to-handle-it/439)

<div class="topic-metadata">

**Author:** [@Haranath](https://community.sapphireims.com/u/Haranath)\
**Replies:** 0\
**Last updated:** [March 19, 2021, 2:47pm UTC](https://community.sapphireims.com/t/i-understand-advanced-report-service-runs-on-different-https-port-and-customer-wants-to-avoid-exposing-it-to-external-world-is-there-any-way-to-handle-it/439 "2021-03-19T14:47:06Z")

</div>

If customer has Application gateway/LB/Reverse proxy, we can write rules in Application Gateway/LB/reverse proxy based on context path of REST API which is getting used by AR service to redirect the requests to internal …

---

## [Apart from SapphireIMS application port, do I need to open additonal port for advanced reports module?](https://community.sapphireims.com/t/apart-from-sapphireims-application-port-do-i-need-to-open-additonal-port-for-advanced-reports-module/440)

<div class="topic-metadata">

**Author:** [@harish](https://community.sapphireims.com/u/harish)\
**Replies:** 0\
**Last updated:** [March 22, 2021, 8:17am UTC](https://community.sapphireims.com/t/apart-from-sapphireims-application-port-do-i-need-to-open-additonal-port-for-advanced-reports-module/440 "2021-03-22T08:17:31Z")

</div>

Advanced reports AR module is a add-on component which is a micro-service architecture and it runs on port 9099 with rest interface. The port is configurable and you may change it. In the firewall we need to open Sapphre…

---

## [Can I run Advance report module in a machine where SapphireIMS application is installed?](https://community.sapphireims.com/t/can-i-run-advance-report-module-in-a-machine-where-sapphireims-application-is-installed/438)

<div class="topic-metadata">

**Author:** [@harish](https://community.sapphireims.com/u/harish)\
**Replies:** 0\
**Last updated:** [March 19, 2021, 2:31pm UTC](https://community.sapphireims.com/t/can-i-run-advance-report-module-in-a-machine-where-sapphireims-application-is-installed/438 "2021-03-19T14:31:56Z")

</div>

Yes, we can run Advanced Report (AR) in a machine where SapphireIMS application is installed provided prerequisites and additional system requirement is met.
