mrc logo mrc logo
  • m-Power m-Power
    What is m-Power?
    Overview Demos Build Process Case Studies Specs Pricing Trial
    m-Power Resources
    Overview How-To Videos Webinars & Podcasts White Papers Fact Sheets
  • Solutions Solutions
    What does m-Power build?
    Overview Database Front-Ends Reporting CRM Systems Business Intelligence Dashboards Mobile Apps ERP Enhancements Modernization Spreadsheets to the web MS Access to the web B2B/Web Portals Scheduling Embedded Analytics Web Forms Workflow Data Exploration Budgeting & Forecasting APIs and Web Services
    Solutions by Industry
    Overview Manufacturing Government Foodservice Software Vendors Logistics & Supply Chain Software Consultants Healthcare
  • Services Services
    Overview Training Project Consulting Staff Consulting Mentoring
  • About About
    Overview Partners Press Releases Careers Events Contact Blog
  • Support Support
    Support Home FAQ Documentation Customer Portal Enhancements Updates Roadmap Techblog
Try m-Power

m-Power Manual

Browse:

  • Home
  • Reports
Back to Manual

What is a Report and when should I use them?

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 […]

Tags: Email, Excel, Graphs, PDF, Printing, Reports, Subtotals

Date Period Analysis

Date Period Analysis The period analysis tool allows end-users the ability to quickly choose from a list of pre-set date values to filter reports. Common values include dates such as 'today', 'yesterday', and 'this week' to more complicated date ranges such as 'last month to date' and 'last fiscal quarter'. Additionally, end-users are given the […]

This post has no tag

Report Template

Report (with Graph) Template   Jump to: Features Template Notes Runtime Walkthrough Template In-Action Application Properties Web Parameters The Report Template is similar to the Multiple Record Inquiry template. However, reports have several additional features, including: Determine subtotal and grand total values Perform graphing Output to different formats Schedule to run and/or email automatically Note: […]

This post has no tag

Interactive Report Template

Interactive Report Template   Jump to: Features Template Notes Extra Guidelines Runtime Walkthrough Template In-Action Application Properties Web Parameters Interactive Reports are applications that can be easily worked with by end-users to create dynamic displays of data. These applications offer features like a collapsible record selection screen, automated drill downs, and flexible graphing. In addition, […]

This post has no tag

Pivot Table Template

Pivot Table Template   The Pivot Table template was created to offer maximum flexibility while minimizing time needed for customization in the build process. The primary use of this template is to quickly total both column and row data, while grouping via one or more fields, in a completely ad-hoc environment. Features that Apply to […]

Tags: Pivot Tables, Reports

Ranking Report Template

Ranking Report Template   Jump to: Features Template Notes Runtime Walkthrough Template In-Action Application Properties Web Parameters The Ranking Report with Graph template is an invaluable tool with regards to Business Intelligence Reporting. Within the prompt page of these applications, end-users can: Select the number of records they wish returned Select the order in which […]

Tags: Ranking Reports, Reports

Cross Tab Report Template

Cross Tab Report Template   Jump to: Features Template Notes Runtime Walkthrough Template In-Action Application Properties Web Parameters The Cross Tab Report template allows end users to control the columns of a report, while maintaining developer customization of the HTML layer. Moreover, this template summarizes measure values into separate columns/buckets across the page, one for […]

Tags: Cross Tab, Popular, Report, Reports

In-Memory Reporting

In-Memory Reporting The architecture of m-Power reports allow them to query data from a variety of sources, including: -A database, via a JDBC connection -Web Services -In-Memory This documentation will focus on the final point listed above, In-Memory Reporting. It is important to note that while In-Memory Reporting may offer considerable performance advantages from Web […]

Tags: Advanced, Report

Page Breaks in a Report

Creating Page Breaks within m-Power Reports m-Power's Page Break feature allows 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 we would like […]

Tags: Page Breaks, Popular, Printing, Report, Reports

Margin Calculations within Pivot Tables

Margin Calculations within Pivot Tables Pivot Tables offer increased runtime functionality for end-users without requiring heavy customization by developers. While Pivot Tables are easy to use, one common question received is “How can I add runtime calculations to my subtotal and grand total levels?” To do so, begin by creating your Pivot Table as normal, […]

Tags: Advanced, Application Calculations, Pivot Tables, Report

Configuring Email Functionality

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 a scheduled task. (This option is discussed in a separate document, found here.) This document will focus on Option 1, listed above. Step […]

Tags: Advanced, Email, Report, Reports

Display the Last Row of Detail within a Subtotal

How to Display the Last Row of Detail within Subtotals By design, m-Power automatically totals all numeric fields at the grand total and subtotal levels. As a result, you may occasionally encounter a situation in which a Report will subtotal and grand total numeric fields when this is not desired. You can prevent a numeric […]

Tags: m-Painter, Popular, Report, Reports, Subtotals

Fixed Header Report

Fixed Header Report

Tags: Excel, fixed header, videos

True Excel vs. Deprecated Excel Output

True Excel vs. Deprecated 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 the […]

Tags: Excel, Reports

Bypassing the Prompt Page in Reports via URL Parameters

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 know, […]

Tags: CSV, Excel, Parameters, PDF, Popular, Prompt Screens, Record Selections, Report, Reports, Subtotals

Created: February 29, 2008 | Modified: December 23, 2011

Search


Browse By Category

Build Process (13)
Starting with m-Power (8)
Retrievals (10)
Reports (15)
Summaries (4)
Maintainers (17)
Graphs (8)
m-Power Data Explorer (4)
General (24)
Calculations (5)
Utilities (9)
m-Power Administration (23)
Security (11)
Freemarker (6)
m-Painter (29)
Form Validation (5)
External Objects & UDFs (12)
Deprecated Documentation (23)
Bootstrap Templates (7)

Popular Tags

Record Selections Admin Email Advanced Dropdowns App Properties Maintainer Performance Bar Graphs Form Validation Summaries Freemarker Parameters Report External Objects Bootstrap Templates SQL m-Painter Compiling Getting Started Security Dates Reports Maintainers Administration Java mrc-Productivity Series Excel Production Data Dictionary Build Process DB2 Popular Application Properties Calculations Retrievals Retrieval Graphing Database Graph Properties Graphs Video Tomcat RPG Prompt Screens

See all tags »

michaels, ross & cole, ltd. (mrc)
Privacy Settings Privacy Policy Cookie Policy Employee Intranet
© 2023 mrc. All rights reserved.
mrc (US)

2001 Midwest Road
Suite 310
Oak Brook, IL 60523
630-916-0662

mrc (UK)

Mortlake Business Centre
20 Mortlake High Street
London, SW14 8JN
+44-20-335-59566