Hello Al, No problem, I'll send you an attachment (directly to your email address) with the screen and printed outputs for you to review. Kind regards, David. -----Original Message----- From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Al Gershen Sent: 02 August 2006 23:42 To: MAPICS ERP System Discussion Subject: Re: [MAPICS-L] Query/400: How do you remove duplicaterecordinformation on a Report? Hi David Unwin: Thank you for your reply to my July 20, 2006 posting. I tried following your instructions and I didn't have any good results. I was a little confused about your comment how the printed report will look different that the report displayed on the screen. Also, do the settings of Select Sort Field and Select Report Summary Functions have an affect on the outcome? Perhaps you could run a simple Query and mail me a copy of the printed Query definition? Any assistance you can provide would be greatly appreciated. Regards, Al Gershen Cost Accountant Lead ECS Composites 3560 Rogue River Hwy Grants Pass, OR 97527 Tele (541) 476-8871, x272 Fax (541) 474-2479 aldg3@xxxxxxxxx --- "Unwin, David" <dunwin@xxxxxxxxxx> wrote on Fri, 21 Jul 2006 11:16:52 +0100:
Hi, Select the fields you need, e.g. Item, Description, Quantity On Hand, CO Number, sort by Item, and CO Number, and then put a break level of 1 in for the Item, Description and Quantity. When you print the report it will not repeat the Item, Description, and Quantity lines (although it does show them if you display the report to screen). Regards, David.
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com _______________________________________________ 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.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.