Re: Query/400: How do you remove duplicaterecordinformation on a Report?

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.