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
  • Build Process
  • Select an Application Type and Template
Back to Manual

Select an Application Type and Template

m-Power ships with over a dozen templates which gives you numerous options when deciding how an application should look and function. The first decision is what type of application to create. m-Power defines four general types: Retrievals, Reports, Summaries, and Maintenance Applications. Then, each of those application types has specific templates to select from. The templates define the general layout and functionality of the resulting application.

To decide which type of application to create, ask this question: Will this application…

List multiple or single rows of data? Show sub- or grand-total data levels? Create a new data table? Maintain data?
Build a Retrieval
Application. Select one of these templates:

  • Multiple Record Retrieval
  • Single Record Retrieval
  • Option List
  • Row Level Security
Build a Report
Application. Select one of these templates:

  • Report
  • Report with Graph
  • Ranking Report with Graph
  • Interactive Report
  • OLAP Pivot Table
  • Cross Tab Report
Build a Summary
Application. Select this template:

  • Summary
Build a Maintenance
Application. Select one of these templates:

  • Display and Maintain Row Maintenance
  • Single Row Maintenance
  • Grid Add Maintenance
  • Grid Update Maintenance
  • Re-order Maintenance
  • Data Upload Maintenance
  • Display and Maintain Calendar

Once you know which type of application to create, then you need to choose which template to use.

Retrieval Templates

Retrieval Templates
Multiple Record Retrieval
  • Provide a paginated list.
  • Filter and sort rows.
  • Create SmartLinks to drill-down into other apps for more detail.
Single Record Retrieval
  • Show exactly one record at a time.
  • Infinite layout options to show even the most complex data clearly.
  • Import related info into other apps.
Option List Retrieval
  • Build drop-down lists/radio button objects that can be used in any other application.
  • Control what values are shown to the user and which are submitted to the database.
Row Level Security
  • Build a retrieval over data that can be used for validation in any other application.
  • Allows different users to see different data in the same application.

Report Templates

Report Templates
Prompted Report
  • Display sub- and grand-total values.
  • Numerous output types: HTML, Excel, PDF, email, and more.
  • Separate prompt screen for user inputs.
Report with Graph
  • Same features as the Report Template, plus the ability to graph.
  • Bar, pie, line or speedometer chart.
  • Enable drill-down through the graphed values.
Ranking Report
  • Automatically list top results based on user-selected options like dimension and record selections.
  • Report the results on the output screen.
Interactive Report
  • AJAX-executed report provides a connected feel experience.
  • Automatically drill-down into lower level of details within the same report.
  • Smart selections show related/unrelated data as selections are made.
OLAP Pivot Table
  • Allows users to control both the row and column for a report.
  • Automatically totals all rows and columns to spot trends within data.
  • Interactive graph where users can change graph types and values.
Cross Tab Report
  • Allows users to control both the row and column for a report.
  • Allows custom painting in m-Painter.
  • Can be generated to Excel/PDF or run in batch.

Summary Template

Summary Template
Summary
  • Produce data marts for Business Intelligence and Dashboard apps.
  • Run batch-capable apps with built-in scripting and scheduling.

Maintenance Templates

Maintenance Templates
Display and Maintain Row Maintenance
  • Users can view, copy, update, delete, and create new records.
  • Perfect for master-table maintenance.
  • Developers control which functions are available.
Single Row Maintenance
  • Enable update of one record at a time.
  • Create a prompt screen to front other screens or server-side functions.
Grid Add Maintenance
  • Enable users to add multiple records at one time to a database table.
Grid Update Maintenance
  • Enable update and delete of multiple records at one time.
Re-order Maintenance
  • Users interact with an intuitive drag and drop interface to re-order rows within a table, resetting sequence values in the affected row.
Data Upload Maintenance
  • Allows users to upload spreadsheets and external data directly into the database.
Display and Maintain Calendar
  • View, add, edit, or delete any date-related data in a familiar calendar format.
  • Filter records.
  • Color code entries based on any criteria.

Click here to read some common m-Power questions.

Created: January 20, 2010 | Modified: June 12, 2017

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

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

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