What is a Report and when should I use them? Overview A report is a document that calculates sub-totals and grand totals. Reports also give you the flexibility to create...
Report Template The Report Template is similar to the Multiple Record Inquiry template. However, reports have several additional features, including: Runtime Walkthrough...
Interactive Report Template Interactive Reports are applications that can be easily worked with by end-users to create dynamic displays of data. These applications...
Pivot Table Template The Pivot Table template was created to offer maximum flexibility while minimizing time needed for customization in the build process....
Ranking Report Template The Ranking Report template is an invaluable tool with regards to Business Intelligence Reporting. Within the prompt page of these...
Cross Tab Report Template The Cross Tab Report template allows end users to control the columns of a report, while maintaining developer customization of...
Bypassing the Prompt Page in Reports via URL Parameters Usually a report is generated by clicking the “Run Report” button. For most customers, most of the time, this method...
Date Period Analysis Overview The period analysis tool allows end-users the ability to quickly choose from a list of pre-set date values to...
Margin Calculations within Pivot Tables Overview Pivot Tables offer increased runtime functionality for end-users without requiring heavy customization by developers. While Pivot Tables are easy...
Display the Last Row of Detail within a Subtotal from m-Painter By design, m-Power automatically totals all numeric fields at the grand total and subtotal levels. As a result, you may...
Page Breaks in a Report Overview m-Power’s Page Break feature allows specifying page breaks when a dimension key changes. This option can be changed under...
True Excel vs. Deprecated Excel Output Overview m-Power Reports utilize a True Excel output format by default (outfmt = 13). Features of this format include: Elimination...
Locking Table Header to Screen Overview This feature allows developers to freeze the column headers to stick to the top of the screen while end-users...
Report Designer The Report Designer template is a great choice when building most reports that require only common UI customizations. Within its...
Emailing from the Report Screen Developers who wish to enable m-Power reports for email have two options: This document will focus on Option 1, listed...
Color Coding Ranges Overview Conditional color coding has been available as an m-Painter feature for many years. Now, developers are able to add...