Re: PowerLink 7.8 Control Break Processing - subtotals
Robert Russell <Robert.Russell-wzDqe+/[email protected]>
| Newsgroups | gmane.comp.systems.as400.mapics |
|---|---|
| Message-ID | <[email protected]> |
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.