Re: Reporting Application

["Tom Wood" <tomw@xxxxxxxxxxxxxxxxxxxxxxxxxx>]

It takes a little bit of up front effort, but what we do is run several extract 
programs (queries) at night against the MOTRAN and LABSUM files (and others) 
and harvest the information into databases.  Then we access those databases 
using Microsoft Excel's pivot table/chart and ODBC feature which seems to work 
very well for us.  You can (and we do) also run simple queries against this 
data.  Pretty flexible and inexpensive way to do this.  Contact me offline if 
you'd like some samples.

Regards.

Thomas C. Wood
IS Manager
Fort Recovery Industries, Inc.
419-375-4121 phone
419-375-4150 fax

>>> michael.huber@plymouthwater.com 02/26/02 08:00AM >>>
Does anyone know of you use any 3rd party, or internal to MAPICS
applications to provide detailed reporting of things such as production
efficiency, daily production, etc etc

Thanks


----------------------------------------------------------------------------
-----------
Michael K. Huber
Applications Development & AS/400 Operations
Microsoft Certified Professional
<http://www/plymouthwater.com>

----------------------------------------------------------------------------
-----------
Confidentiality Note:   This e-mail message and any attachments to it are
intended only for the named recipients and may contain confidential
information.  If you are not one of the intended recipients, please do not
duplicate or forward this e-mail message and immediately delete it from your
computer.
----------------------------------------------------------------------------
-----------

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