RE: Crystal Reports

Terry,

You may want to consider the Mapics report writer, Info WorkPlace (IWP).
IWP shields the report developer from the technical aspects of the database.
You focus on the information you want on the report instead of file names
and field names and getting the links/keys correct.  There are a number of
"subsets" available for download from Mapics that already have a large
portion of the database mapped.  A subset is a "view" over the Mapics
database and defines the files/links required for various types of
reporting.  You can modify the Mapics subsets and develop your own.

Better yet, IWP has a FREE version that allows any Mapics customer to
download and run any report they have developed.  You can also create up to
5 reports of your own to try out the report designer.  See SH11858, the IWP
informational PTF.

IWP has very powerful reporting capabilities for calculations, sorting,
totaling, etc and does not utilize ODBC or Query - which can impact system
performance.

Momentum is the developer of Info WorkPlace, JacanaForms and inTuator.

Regards,
-Greg

Gregory Novak
Manager North American Technical Services
Momentum Utilities Pty Ltd
(630) 985-1736
gnovak@xxxxxxxxxx
www.jacana.com
 
Making Information Work for your Business
www.intuator.com



-----Original Message-----
From: Terry LeBlanc [mailto:TLeBlanc@xxxxxxxxxxx] 
Sent: Wednesday, August 24, 2005 12:49 AM
To: MAPICS ERP System Discussion
Subject: Crystal Reports


Anybody using Crystal Reports with MAPICS?  We are contemplating
implementing Crytal Reports XI to access MAPICS and other data to
generate reports.  We currently utilize Queries and Browser, using Excel
to massage the resulting data.  Need a better way...

Wish the database schema were documented properly, with lookups and
where-used references.  Very difficult to find the right database
elements.

Terry J. LeBlanc
Nailite International