Re: PowerLink 7.8 Control Break Processing - subtotals

Also in export to PDF...

There is also a little known feature in Overview where you can place functions like count and sum on the seperator node for a group of records.
So if you had a few known groups you can add each to the overview with a different subset and then have totals for each group.
Robert Russell | System i Product Development | Infor | office: 678.319.8277 | mobile: 678.735.2386 | robert.russell@xxxxxxxxx

----- Original Message -----
From: Dale Gindlesperger [mailto:dale_gindlesperger@xxxxxxxxx]
Sent: Thursday, February 09, 2012 05:30 PM
To: MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
Subject: Re: [MAPICS-L] PowerLink 7.8 Control Break Processing - subtotals

Robert,


Just in the Local Print?  Subtotals/breaks will still not an option within a view?  Having it in local print will still be a help, though. 

 
Dale (Cork) Gindlesperger, CPIM
Click here for my professional profile on LinkedIn

"If I'd asked my customers what they wanted, they'd have said a faster horse." - Henry Ford

A Pessimist Sees The Difficulty in Every Opportunity;
An Optimist Sees The Opportunity in Every Difficulty;
An Analyst Sees How to Achieve the Opportunity!

________________________________
From: Robert Russell <Robert.Russell@xxxxxxxxx>
To: "'mapics-l@xxxxxxxxxxxx'" <mapics-l@xxxxxxxxxxxx>
Sent: Thursday, February 9, 2012 4:24 PM
Subject: Re: [MAPICS-L] PowerLink 7.8 Control Break Processing - subtotals

Will be in local print on next PCM (very soon) for R9.
Robert Russell | System i Product Development | Infor | office: 678.319.8277 | mobile: 678.735.2386 | robert.russell@xxxxxxxxx

----- Original Message -----
From: Tom E Stieger [mailto:testieger@xxxxxxxxxxxx]
Sent: Thursday, February 09, 2012 01:32 PM
To: MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
Subject: Re: [MAPICS-L] PowerLink 7.8 Control Break Processing - subtotals

Gerri-

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
then
displaying subtotals and totals?  Has anyone done this using Powerlink
7.8?


_______________________________________________
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,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/mapics-l.

_______________________________________________
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,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.

_______________________________________________
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,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.

_______________________________________________
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,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.