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-wzDqe+/[email protected]

----- Original Message -----
From: Dale Gindlesperger [mailto:dale_gindlesperger-/[email protected]]
Sent: Thursday, February 09, 2012 05:30 PM
To: MAPICS ERP System Discussion <mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]>
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-wzDqe+/[email protected]>
>To: "'mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]'" <mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]> 
>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-wzDqe+/[email protected]
>
>----- Original Message -----
>From: Tom E Stieger [mailto:testieger-7y5+ka1ulstWk0Htik3J/[email protected]]
>Sent: Thursday, February 09, 2012 01:32 PM
>To: MAPICS ERP System Discussion <mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]>
>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-Zwy7GipZuJhWk0Htik3J/[email protected]
>[mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Gerri Schubert
>Sent: Thursday, February 09, 2012 10:17 AM
>To: mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]
>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-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or
>change list options,
>visit: http://lists.midrange.com/mailman/listinfo/mapics-l
>or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
>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-Zwy7GipZuJhWk0Htik3J/[email protected]
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/mapics-l
>or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
>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-Zwy7GipZuJhWk0Htik3J/[email protected]
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/mapics-l
>or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
>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-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
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-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.