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