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