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 Inventory Management 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 Db2 Web Query Alternative
    Solutions by Industry
    Overview Manufacturing Government Foodservice Software Vendors Logistics & Supply Chain Software Consultants Healthcare
  • Services Services
    Development Services Training 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
  • Display the Last Row of Detail within a Subtotal
Back to Manual


How to Display the Last Row of Detail within Subtotals

Click here to access current documentation for this feature.

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 field from being shown by displaying the Last Row of Detail.

The screen shot below shows that the Customer Number has been added for each record:

If you look closely at the records with blue backgrounds in the table above, you can see that the customer number is being totaled.

Moreover, if the end user chooses to not display the detail line, this can become even more confusing:

Do you notice how the customer numbers are being totaled? Obviously, the customer number is an identifier, and not a field to be totaled. To prevent the field from being totaled, you must use the Last Row of Detail feature in m-Painter.

Once in m-Painter, select and delete the field that needs the have the Last Row of Detail applied:

Click your curser in the now empty cell. Next, click the "Field" icon in the m-Painter toolbar.

Select the correct field, then under "Report/Summary For:", select "Last Row of Detail". At runtime, this will not total the field, but rather place the last instance of the detail row on the subtotal line. The benefit of this is that your report (regardless whether it is running in Subtotal or Detail view) will always display the correct Row Information.

Now, the Customer Name will automatically populate with the last row of detail at the subtotal level. Remove the Customer Number entirely from the grand total row as it is not needed. After making the changes and saving, this is the final result:

In-Action

  • Detail Mode
  • Summary Mode
MultiRecordPC
Summary Mode

Created: February 29, 2008 | Modified: November 7, 2023

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

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

See all tags »

michaels, ross & cole, ltd. (mrc)

Privacy Policy Cookie Policy Cookie Settings Notice at Collection Do Not Sell or Share My Personal Information

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


© 2024 mrc. All rights reserved.