Hi Marc, Do you use the native System/21 reports? Yes, we use Financial Reports such as Open A/R and Open A/P Invoices, etc. Do you use just AS/400 query and download extracts to Excel? We use AS/400 queries for simple reports and displays. I create queries and add to a user's menu or on JBA Explorer so they can call any time. I also have many on nightly scheduler to print daily or weekly reports. I rarely transfer to excel and on;ly I would do so, not users. If you use Corvu, have you upgraded to Aurora? NO. Do you use System/21 Performance Analyzer? NO. Do you use some other product? Which one? We use COGNOS but are moving away from it to product called Intellijade. Intellijade is SQL product, which requires no ODBC setup. All queries reside on AS/400. I have many Jade reports & emails that are setup on my Windows Task Scheduler that mostly emails reports around the world and done overnight. Are you doing any kind of EIS or executive dashboard software? Which one? I think Intellijade can do, but I have not had the time to research. Thanks Barbara Byrne IT Manager Greatex Mills Inc. -----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? Do you use just AS/400 query and download extracts to Excel? If you use Corvu, have you upgraded to Aurora? Do you use System/21 Performance Analyzer? Do you use some other product? Which one? Are you doing any kind of EIS or executive dashboard software? Which one? 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.