RE: IWP/Jacana

["Greg Novak, Momentum" <gnovak@xxxxxxxxxx>]

Joan,

A simple correction to your comments to Lloyd - one of the features of
IWP is that it *can* sort on totals.  Many other tools require the
intermediate file to do this sort, where IWP has it built in.

To sort on a total, you must first create the base report specifications
including sorting and totaling (to sum dollars by customer).  Then, in
Jacana, filter the DataCrafter to "Pick Summary Fields", and locate the
total wanted (ie dollars by customer).  Open the Report Specifications
dialog, select the Sort tab, and drag the total field to the top of the
list of sort fields.

I believe Bernard has already replied to Lloyd regarding his question.

Regards,

Gregory Novak
Manager North American Technical Services
Momentum Utilities Pty Ltd
(630) 985-1736
gnovak@jacana.com
www.jacana.com


-----Original Message-----
From: McCready, Joan [mailto:Joan.McCready@metaltekint.com]
Sent: Thursday, January 10, 2002 11:54 AM
To: 'mapics-l@midrange.com'
Subject: RE: IWP/Jacana


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.