RE: [SYSTEM21] JBA Reporting

[Joe Roesch <jroesch@xxxxxxxxxxxxxxx>]

The ODBC link (for Crystal) can become very slow depending upon the table
size accessed from the AS400.  Information warehoused in another database,
such as SQL Server or Oracle for example, has exponentially faster access
the larger the data becomes on the AS400.  However, this is limited to data
that is not constantly updated (i.e. pulled hourly or nightly) where real
time is critical.     


-----Original Message-----
From: Angus Appleby [mailto:aappleby@xxxxxxxxxxxxxxxxxx] 
Sent: Thursday, July 03, 2003 11:29 AM
To: System 21 Users
Subject: RE: [SYSTEM21] JBA Reporting

I found the ODBC driver quite slow when trying to create Crystal Reports - 
how are you connecting to the AS/400?

Angus



"Trask, William" <WTrask@xxxxxxxxxxx>
Sent by: system21-bounces@xxxxxxxxxxxx
03/07/2003 16:03
Please respond to System 21 Users

 
        To:     "'System 21 Users'" <system21@xxxxxxxxxxxx>
        cc: 
        Subject:        RE: [SYSTEM21]   JBA Reporting


Crystal Reports is a terrific product. We use Version 8.5, but there is a
newer one out now.

We use it for System 21 and other AS/400 programs - even tying System 21
records with our HR program.
Reports can be dynamic or static - we publish static reports to our 
Intranet
site for users.
It also has a built in SQL Wizard which comes in handy sometimes.

----------------------
WW (Bill) Trask
Hensley & Company
Phoenix, AZ
 


-----Original Message-----
From: Todd Grass [mailto:tgrass@xxxxxxxxxx] 
Sent: Thursday, July 03, 2003 5:50 AM
To: system21@xxxxxxxxxxxx
Subject: [SYSTEM21] JBA Reporting


We are searching for a better report writing method than query. Has anyone
used the Crystal product and how did it work for you?

Todd Grass
American National Rubber
TGRASS@xxxxxxxxxx

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



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