Creating a Custom App Portal Report

Creating a Custom App Portal Report

Summary

Custom reports can be created based on SQL queries and then baked in to the App Portal report portal.

Synopsis

Custom reports can be created based on SQL queries and then baked in to the App Portal report portal. The first step is to create a query to return the necessary information. The next step is to convert the report into RDLC format.

Discussion

As a starting point, it is often helpful to find one or more canned reports that have pieces of the information you are looking for. With the title of an existing report in hand, navigate to the AdminStudio.Reports.xml file located within <App Portal Install Dir>\Web\ReportDefinition. From here, you can search for the report title in order to find the raw SQL query behind it.

By combining the elements needed from different reports and taking a look at the other contents of the tables being examined, a query that returns the information necessary for the report can be created. With this SQL query, the final step is to create the RDLC-based reported as mentioned here:
http://helpnet.flexerasoftware.com/appportal2015/Default_CSH.htm#helplibrary/AP_CreateRDLCRpt.htm

This workflow can be followed any time a custom report must be created and integrated.

Additional Information

http://helpnet.flexerasoftware.com/appportal2015/Default_CSH.htm#helplibrary/AP_CreateRDLCRpt.htm
Labels (1)
Was this article helpful? Yes No
No ratings
Version history
Revision #:
1 of 1
Last update:
‎Oct 19, 2018 04:16 PM
Updated by: