m-Power Manual

What is a Report and when should I use it?   A report is a document that calculates sub-totals and grand totals. Reports also give you the flexibility to create graphs. · Sub-total/Grand total — Reports give you the ability to automatically sub-total and grand total all numeric data. In addition, most of the time Read the rest of this document »

Executing a Report directly from a link and/or URL   Usually a report is generated by clicking the “Run Report” button. For most customers, most of the time, this method works well. But there are times when you may need to skip the prompt page and proceed directly to the results page. As you may Read the rest of this document »

Cross Tab Report Template   Starting with the March 6th, 2012 version of m-Power, the Cross Tab template ships with m-Power as a standard template. This template’s purpose is to, like the pivot table, allow your end user to control the columns of their report, while still allowing the developer access to edit the HTML Read the rest of this document »

Top Ten Style Reports   Reports offer you the ability to create fully functional Top-ten style lists which will restrict the output to a pre-specified number of records and sort by your Sequence field. This is perfect for creating simple reports where you only wish to show a certain set of records, for instance — Read the rest of this document »

Margin Calculations within Pivot Tables   Pivot Tables offer incredible runtime functionality for end-users while not requiring much painting by developers. This makes the Pivot Table very easy to use, however one common question received is “How can I add runtime calculations to my subtotal and grand total levels?” Beginning with the August 20th, 2012 Read the rest of this document »

Margin Calculations within Pivot Tables   Pivot Tables offer incredible runtime functionality for end-users while not requiring much painting by developers. This makes the Pivot Table very easy to use, however one common question received is “How can I add runtime calculations to my subtotal and grand total levels?” Beginning with the August 20th, 2012 Read the rest of this document »

Group by within Reports   This document explains how to setup your report applications to take advantage of the Group By functionality and also contains information pertaining to additional configuration options. What is the Group By Feature & why do I want it? The ability to group data by a specific value allows you to Read the rest of this document »

Creating Page Breaks within m-Power Reports   m-Power allows you the advanced feature of specifying page breaks when a sequence key changes. This option can be changed under the “Sequencing” link within the Application Menu. At run time, every time the sequence key changes, a new page will be printed. In this case, let’s assume Read the rest of this document »

Customizable Splash (loading) Page   m-Power Reports give you the option of Customizable splash (loading) pages. On long running reports, users will see a pre-defined image letting them know that their report is running. By default, it is turned off. However, just a few clicks will activate this very friendly user feature. First, be sure Read the rest of this document »

Output Reports to PDF   m-Power Reports include the option to output to PDF. The painting for the PDF comes directly from the HTML presentation layer. This means that m-Painter is the WYSIWYG editor for all of these output types: HTML, Formatted Excel, and PDF. Options (shown with default) Page Size and Orientation: Portrait (8.5in Read the rest of this document »

  Configuring Email Functionality   Developers who wish to enable m-Power reports for email have two options: Allow end-users to send e-mails interactively through a Report prompt page Automate e-mails to be sent in batch. (This option is discussed in a separate document, found here.) This document will focus on Option 1, listed above. Step Read the rest of this document »

How to Display the Last Row of Detail within Subtotals   Inevitably, you will encounter a time when a Report will subtotal and grand total numeric fields that you do not wish to be totaled. The reason these fields are totaled is because they are Numeric Fields. Notice the screen shot below: You will notice Read the rest of this document »

True Excel vs. Old Excel Output   m-Power Reports utilize a True Excel output format by default (outfmt = 13). Features of this format include: Elimination of the warning message from Excel when attempting to open an m-Power Report. Non-formatted (no colors or other HTML mark-up) output. This means that your end-users will see just Read the rest of this document »

  Interactive Report Template   Jump to: Template Features Real-World Example Using the Interactive Report Template Output to Excel Advanced Tips General Notes The Interactive Report template is full of features that will allow both you and your users greater flexibility in accessing your data. Template Features Record Selections and Report Data on a single Read the rest of this document »

OLAP Pivot Table Template   OLAP stands for Online Analytical Processing. This document will explain how users will interact with the OLAP Pivot Table template at runtime, as well as additional features that developers have access to while creating OLAP Pivot Reports. Template Overview The primary use of this template will be for the user Read the rest of this document »

Ranking Report with Graph   The Ranking Report with Graph template is an invaluable tool with regards to Business Intelligence Reporting. Within the prompt page of the application built with this template, your users will be able to: · Select the number of records they wish returned · Select the order in which they are Read the rest of this document »