RE: IWP/Jacana -- MAPICS-L

Lloyd -

If all you wanted was the first 10 records, there's a way by adding a
run-time parameter. I'd have to dig out the example I was sent. (I had a
single-page report where I wanted to control the number of copies produced
at run-time.)

Your request is more complicated, however. You want the top 10 (or 25 or
something) in net dollar value. This is going to require a sort on the total
net dollar value, which is a total field accumulated at run-time. Therefore,
there's no way Jacana/IWP is going to know as it runs the report if the
customer currently being processed will be in the top 10 (or whatever).

This is going to require either an RPG report that totals the net sales for
each customer into a temporary file which is then sorted and the report
written, or some other tool like MMA. IWP is a marvelous tool, but it does
have its limits, one being it cannot sort on totals that are accumulated
during the report run.

        -- Joan

Joan McCready, IS Manager      phone:  636-479-4499
MetalTek International         fax:  636-479-3399
The Carondelet Division        www.metaltekint.com
8600 Commercial Blvd
Pevely, MO  63070

-----Original Message-----
From: LDEGNON@AMPRO.COM [mailto:LDEGNON@AMPRO.COM]
Sent: Thursday, January 10, 2002 11:26 AM
To: MApics-l@midrange.com
Subject: IWP/Jacana


Hello folks,

An IWP/Jacana question:


How do I write a report that, among the select criteria, is a selection
value
that asks how many records I want returned?

For example, I create a report that returns customer, Items shipped,
quantity
and net dollar value of shipments for selected date range in descending
order.

What do I add to select criteria that will let me tell report at run time,
how
may of the records I want returned? (top 10, top 25, top 50, etc.)

Attached/Below is example of what I have so far, but all customers are
returned.
(thousands of pages) Upper management might, at runtime, want info on the
top
ten customers at run time...


Cust Number/Name            Item        Description         QTY     Net
30705   XYZ CORPORATION     8550334A    CBL-SVG-Q-01    48    1,248.00
30705       XYZ CORPORATION         8450404B  MM2-SVG-Q-73      48
11,616.00
                   Totals for XYZ CORPORATION
12,864.00

11070   123 Inc.                8250334A    CBL-SVG-Q-95    10      500.00

11070       123 Inc.                    8440404B  CM2-SVG-Q-45      5
2500.00
                   Totals for 123 Inc.
3000.00


Lloyd H. Degnon
Ampro Computers Inc.
5215 Hellyer Ave
San Jose, CA 95138
408.360.4365
Ldegnon@ampro.com
WWW.AMPRO.COM
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
or email: MAPICS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.