Creating a Custom App Portal Report
SummaryCustom reports can be created based on SQL queries and then baked in to the App Portal report portal.
SynopsisCustom 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.
DiscussionAs 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:
This workflow can be followed any time a custom report must be created and integrated.