{"id":770,"date":"2008-02-29T03:45:02","date_gmt":"2008-02-29T09:45:02","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/legacy\/?page_id=770"},"modified":"2023-11-07T12:52:57","modified_gmt":"2023-11-07T18:52:57","slug":"display-the-last-row-of-detail-within-a-subtotal","status":"publish","type":"page","link":"https:\/\/www.mrc-productivity.com\/legacy\/reports\/display-the-last-row-of-detail-within-a-subtotal","title":{"rendered":"Display the Last Row of Detail within a Subtotal"},"content":{"rendered":"<link rel=\"stylesheet\" href=\"https:\/\/code.jquery.com\/ui\/1.10.3\/themes\/smoothness\/jquery-ui.css\">\n  <script src=\"https:\/\/code.jquery.com\/jquery-1.9.1.js\"><\/script><br \/>\n<script src=\"https:\/\/code.jquery.com\/ui\/1.10.3\/jquery-ui.js\"><\/script><br \/>\n<script><br \/>\n  $(function() {<br \/>\n    $( \"#tabs\" ).tabs();<br \/>\n  });<br \/>\n  <\/script><\/p>\n<h1>How to Display the Last Row of Detail within Subtotals<\/h1>\n<p><i>Click <a href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/display-the-last-row-of-detail-within-a-subtotal\">here<\/a> to access current documentation for this feature.<\/i><\/p>\n<p>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.<\/p>\n<p>The screen shot below shows that the Customer Number has been added for each record:<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"\/legacy\/images\/reportdatatable.jpg\"><\/p>\n<p>If you look closely at the records with blue backgrounds in the table above, you can see that the customer number is being totaled.<\/p>\n<p>Moreover, if the end user chooses to not display the detail line, this can become even more confusing:<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"\/legacy\/images\/reportdatatablenodetaillevel.jpg\"><\/p>\n<p>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.<\/p>\n<p>Once in m-Painter, select and delete the field that needs the have the Last Row of Detail applied:<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"\/legacy\/images\/mpainterlastrowofdetail.jpg\"><\/p>\n<p>Click your curser in the now empty cell. Next, click the &quot;Field&quot; icon in the m-Painter toolbar.<\/p>\n<p>Select the correct field, then under &quot;Report\/Summary For:&quot;, select &quot;Last Row of Detail&quot;. 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.<\/p>\n<p><img decoding=\"async\" class=\"border\" alt=\"\" src=\"\/legacy\/images\/insertdatafield.jpg\"><\/p>\n<p>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:<\/p>\n<h2><strong>In-Action<\/strong><\/h2>\n<div id=\"tabs\">\n<ul>\n<li><a href=\"#tabs-1\">Detail Mode<\/a><\/li>\n<li><a href=\"#tabs-2\">Summary Mode<\/a><\/li>\n<\/ul>\n<div id=\"tabs-1\"><a><img decoding=\"async\" class=\"alignnone  wp-image-5826\" alt=\"MultiRecordPC\" src=\"\/legacy\/images\/lastrowofdetail.jpg\"><\/a><\/div>\n<div id=\"tabs-2\"><a><img decoding=\"async\" class=\"alignnone  wp-image-5825\" alt=\"Summary Mode\" src=\"\/legacy\/images\/lastrowofdetailsummary.jpg\"><\/a><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":557,"menu_order":8,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-770","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/770","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/comments?post=770"}],"version-history":[{"count":14,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/770\/revisions"}],"predecessor-version":[{"id":9563,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/770\/revisions\/9563"}],"up":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/557"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/media?parent=770"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}