Subtotals in a grid

This Q&A forum allows users to post and respond to "How Do I Do ....." questions. Please do not use to report (suspected) errors - you must use your regional help desk for this. The information contained in this forum has not been validated by LANSA and, as such, LANSA cannot guarantee the accuracy of the information.
Post Reply
rhoehle
Posts: 3
Joined: Tue Dec 12, 2017 9:01 am

Subtotals in a grid

Post by rhoehle »

I have a project where the analyst wants to have subtotals inside the grid. Personally, I feel like this needs to be done outside the grid (for multiple reasons, least of which is it wipes out some of the grid's functionality), but before I dig my heels in and push for an alternative, is there a good or effective way to create subtotals? See attachment for a visual of what is requested. However, since I'm still newer to Lansa, maybe there is a trick or easy way to create subtotals.

Thanks.
Attachments
InvoiceAuditReport_Subtotals.jpg
InvoiceAuditReport_Subtotals.jpg (253.16 KiB) Viewed 3143 times
atostaine
Posts: 696
Joined: Wed Jan 20, 2016 7:38 am

Re: Subtotals in a grid

Post by atostaine »

You can define the necessary fields as Alpha and either insert the word "subTotal" or insert the amount by using asDisplayString. You could probably disable that row too so clicking on it wouldn't do anything.
Art Tostaine
Post Reply