mrc Documentation
michaels, ross & cole, ltd.
http://www.mrc-productivity.com/

How to Display the Last Row of Detail within Subtotals (Web 2.0)

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 that the Customer Number has been added for each customer number, while the customer name has not been added to the Subtotal (blue) row. Notice the problem this can become if the detail line is not printed.

Notice now that the end user has no way to discern what subtotal line belongs to which customer.

There is a very easy solution to this problem – m-Painter.

Notice the Circled CUSNO. This is the field that is being summed. Select the field, then delete it from m-Painter. Be sure to click your curser in the now empty cell.

Next click the “Insert Data Field” button on the m-Painter toolbar:

Select the correct field, then under “Report/Summary For:”, select “Last Row of Detail.” This will, at run time, not add up the field as the subtotal did, but rather simply place the last instance of the detail row on the subtotal line. The benefit of this is that your report, rather running in Subtotal or Detail view, will always display the correct Row Information.

After doing the same process with the Customer Name and removing the Customer Number entirely from the grand total row, but output now looks like this:

In Detail mode:

In Summary mode: