RE: JBA Reporting -- SYSTEM21

Joe,

You can use a product called Transformation Server from Datamirror to
transfer data from your AS/400 to your reporting database (e.g. SQL Server)
in real time.  That way you get much better reporting performance against
real time data, AND free up your 400's CPU for more important stuff.

Regards,
Bill

-----Original Message-----
From: Joe Roesch [mailto:jroesch@xxxxxxxxxxxxxxx]
Sent: 07 July 2003 14:18
To: 'System 21 Users'
Subject: RE: [SYSTEM21] JBA Reporting


This message has been successfully virus checked by the Centura Foods Mail
system. 


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.

_______________________________________________
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 e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________


=======================================================
This email, its content and any files transmitted with it are confidential
and intended solely for the use of the individual(s) to whom it is 
addressed.
If you are not the intended recipient, be advised that you have received
this email in error and that any use, dissemination, forwarding, printing, 
or copying of this email is strictly prohibited.
This email, its contents and any files transmitted with it have been 
prepared using information believed by the author to be reliable and
accurate, but Centura Foods Ltd. makes no warranty as to accuracy or
completeness. In particular Centura Foods Ltd. does not accept 
responsibility for changes made to this email or related files after it was 
sent. Any opinions expressed in this email and any related documents
are those of the author and do not necessarily reflect the opinions of
Centura Foods Ltd. or its associated companies.

If you have received this email in error please notify the Centura Foods
IT Helpdesk by telephone on +44 (0) 1606 830 533.
=======================================================


________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________