RE: iSeries Reporting Tools

["Rick Rauterkus" <ricker@xxxxxxxxxxxxx>]

We use Sequel here and have the Viewpoint and FYI modules with it.

As someone else mentioned, to do ad-hoc stuff, you need to be familiar with
the database and joining files, etc.  We have a couple of power users that
can do this Sequel and ViewPoint.  We tell them what files they need and how
to join them, they do their own selection and sorting, etc.

FYI is pretty cool.  I created a non-normalized file containing the orders,
sales, and backlogs for the last 3 years, downloaded it to FYI, and gave it
to the VP of Sales and Marketing.  Using drag and drop, they can view and
print the data any way they can imagine.  Since the data is on the PC, they
can take it with them on the road.  The file is updated each night with that
days transactions, and with a click of a button and type a password, their
file on their PC is up-to-date.  This cut about 90% of the requests for
reports from them.

Rick