At the last users conference they talked about that functionality coming
for release 9 for PowerLink. I believe it was going to be controlled
via the specified sort on the object.

One solution at 7.8 that may work is to create an SQL view that does the
breaking and subtotals, then integrate that view as a non-maintainable
object. This will probably have some severe performance implications,
but it should work.

Let me know if you need some help with the SQL. The CUBE and/or ROLLUP
Functions(v6.1) are useful for this.

-Tom Stieger
IT Manager
California Fine Wire

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Gerri Schubert
Sent: Thursday, February 09, 2012 10:17 AM
To: mapics-l@xxxxxxxxxxxx
Subject: [MAPICS-L] PowerLink 7.8 Control Break Processing - subtotals

Can PowerLink's Enterprise Integrator accommodate basic control break
processing. summarizing data for each record having a unique value and
displaying subtotals and totals? Has anyone done this using Powerlink

This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post
a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.