Re: Ad Hoc Queries on JBA System/21

Mark, 
We have moved away from AS/400 Queries and on to Crystal Reports
(Enterprise V.10)

We have found Crystal to be an excellent AD Hoc type report writer that
puts System/21 files in an easy to understand format. The users are
happy and once a report has been created, it can be set to run
automatically and emailed to the user in a variety of formats, including
PDF and Excel. 

Please contact me if I can provide you any further information. 

We are located in West Virginia. 

Thanks,

Todd
 

-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx] On Behalf Of Mark Faulhaber
Sent: Friday, May 19, 2006 11:01 AM
To: system21@xxxxxxxxxxxx
Subject: [SYSTEM21] Ad Hoc Queries on JBA System/21

 I'm the Director of IT for Griffin Industries in Northern Ky.  

We are JBA/GEAC/Infor (whatever) System/21 users.

We're looking at AD Hoc Query and reporting software to replace the
Corvu that 
JBA sold us when we originally went on System/21.

It would be a big help to me if you would let me know how you're
dealing with this.

Thanks in advance for your consideration of my request.

Do you use  the native System/21 reports?
YES


Do you use just AS/400 query and download extracts to Excel?
We do download to Excel via Client Access, but we are not doing the same
thing with Crystal Reports.


If you use Corvu, have you upgraded to Aurora?
We do not use Aurora.


Do you use System/21 Performance Analyzer?
No. 


Do you use some other product?  Which one?
Crystal Reports. Enterprise V.10

Are you doing any kind of EIS or executive dashboard software?  Which
one?
Crystal does have dashboard ability, but we have not implemented that
feature yet. 


To get things rolling, here's my answers:

Do you use  the native System/21 reports?
 A: Yes, we do, but we've had to modify them extensively.

Do you use just AS/400 query and download extracts to Excel?
  A: We use some query, but for downloads to Excel we use a product
called mrc


If you use Corvu, have you upgraded to Aurora?
  A: We use Corvu now.  We're unhappy with the support we're getting. 
And we've 
       received contradictory information about whether it'll work with
Aurora.  
       (Hence the need for this mailing.)


Do you use System/21 Performance Analyzer?
  A: No, it's one that we're looking at as a Corvu replacement


Do you use some other product?  Which one?

  A: We use mrc-Productivity series.  An application generator that
does a good job for 
       us in the hands of a programmer.  But we've had little luck
getting the Accountants to
       embrace it.


Are you doing any kind of EIS or executive dashboard software?  Which
one?

   A: We have some EIS type screens that are written in mrc.  The
Executives use them, 
        but we'd like to do a lot more and the Infor sales rep is
saying that a lot of what we
       want is already in the basic templates they deliver with
System/21 Performance Analyzer.


Thanks again.

Mark Faulhaber
Director I/S
Griffin Industries
859-572-2507

The information contained in this message and any attachment may be
proprietary, confidential, and privileged or subject to the work
product doctrine and thus protected from disclosure.  If the reader
of this message is not the intended recipient, or an employee or
agent responsible for delivering this message to the intended
recipient, you are hereby notified that any dissemination,
distribution or copying of this communication is strictly prohibited.
If you have received this communication in error, please delete this 
message immediately.  


_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.