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,


-----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.

Al Gershen
Cost Accountant Lead
ECS Composites
3560 Rogue River Hwy
Grants Pass, OR 97527
Tele (541) 476-8871, x272
Fax (541) 474-2479

--- "Unwin, David" <dunwin@xxxxxxxxxx> wrote on Fri,
21 Jul 2006 11:16:52 +0100:


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



Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
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.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.