Using Report Sub Totals

[Mike Matthews - Omnis]

Hello Paul,

That was easy, not sure why I missed that first time.

Thank you

Mike Matthews

Lineal Software Solutions
Commercial House, The Strand<x-apple-data-detectors://1/1> Barnstaple, Devon, EX31 1EU<x-apple-data-detectors://1/1>

omnis at lineal.co.uk<mailto:mike.matthews at lineal.co.uk>

www.lineal.co.uk<http://www.lineal.co.uk/>

www.sqlworks.co.uk<http://www.sqlworks.co/>



On 18 Dec 2020, at 15:24, Paul Manning via omnisdev-en <omnisdev-en at lists.omnis-dev.com<mailto:omnisdev-en at lists.omnis-dev.com>> wrote:

Mike,

Try leaving off $cols. Just use iList.project_total.$total()

Paul

************************************************
Paul R. Manning
paulrmanning58 at icloud.com<mailto:paulrmanning58 at icloud.com> <mailto:paulrmanning58 at icloud.com>


On Dec 18, 2020, at 10:16 AM, Mike Matthews - Omnis <omnis at lineal.co.uk<mailto:omnis at lineal.co.uk>> wrote:

Me again.

In a report, I have a subtotal section. The column sets $totalmode as kTmTotal and all is good.  How do I use that subtotal value in the next field in the report line?

When I useiList.$cols.project_total.$total(), it totals the whole list, and not the sub total value.

Hope that this is clear, often explaining these things is difficult.


Mike Matthews

Lineal Software Solutions
Commercial House, The Strand<x-apple-data-detectors://1/1> Barnstaple, Devon, EX31 1EU<x-apple-data-detectors://1/1>

omnis at lineal.co.uk<mailto:omnis at lineal.co.uk><mailto:mike.matthews at lineal.co.uk>

www.lineal.co.uk<http://www.lineal.co.uk><http://www.lineal.co.uk/>

www.sqlworks.co.uk<http://www.sqlworks.co.uk><http://www.sqlworks.co.uk>

_____________________________________________________________
Manage your list subscriptions at https://linkprotect.cudasvc.com/url?a=http%3a%2f%2flists.omnis-dev.com&c=E,1,ENX64NSbl3m2B7ryL4ITGjC8IpTpCBm15U-Uxt00LyXUILmQShEObLAeTHw56Zdgz-SqfTA8OXHh1Jhcqq68FWPTEg2B3u1rDkusztKYxTXpl-9qfiiIII8,&typo=1
Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com

_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com

_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com