× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



ODBC is slow and Crystal reports is slower. We switched from Crystal 
reports to excel (using ODBC) which greatly increased our processing 
speed. THe downside is that Excel doesn't have all the built in functions 
of Crystal reports.   For us, the fastest method to query and download 
data was to call, from excel, an AS400 program, which selects and 
summarizes the data then download this data into excel. We're using this 
combination of Excel, visual basic for applications (macros) and AS400 RPG 
to do most of our reporting now.





system21-request@xxxxxxxxxxxx
Sent by: system21-bounces@xxxxxxxxxxxx
07/07/2003 08:36 AM
Please respond to system21

 
        To:     system21@xxxxxxxxxxxx
        cc: 
        Subject:        SYSTEM21 Digest, Vol 1, Issue 542


Send SYSTEM21 mailing list submissions to
                 system21@xxxxxxxxxxxx

To subscribe or unsubscribe via the World Wide Web, visit
                 http://lists.midrange.com/mailman/listinfo/system21
or, via email, send a message with subject or body 'help' to
                 system21-request@xxxxxxxxxxxx

You can reach the person managing the list at
                 system21-owner@xxxxxxxxxxxx

When replying, please edit your Subject line so it is more specific
than "Re: Contents of SYSTEM21 digest..."


Today's Topics:

   1. Access (Kate Healy)


----------------------------------------------------------------------

message: 1
date: Mon, 7 Jul 2003 16:32:50 +0100 
from: Kate Healy <Kate.Healy@xxxxxxxx>
subject: [SYSTEM21]   Access

We are just considering using Access - we are considering copying the data
from the AS400 to a data  warehouse nightly and using Access both for 
adhoc
queries and for reports.

Has anyone any experience of this/any recommendations?

We had been using Objects but find it cumbersome at times.

Regards,

Kate Healy
EI Electronics

-----Original Message-----
From: system21-request@xxxxxxxxxxxx
[mailto:system21-request@xxxxxxxxxxxx]
Sent: 07 July 2003 16:25
To: system21@xxxxxxxxxxxx
Subject: SYSTEM21 Digest, Vol 1, Issue 541


Send SYSTEM21 mailing list submissions to
                 system21@xxxxxxxxxxxx

To subscribe or unsubscribe via the World Wide Web, visit
                 http://lists.midrange.com/mailman/listinfo/system21
or, via email, send a message with subject or body 'help' to
                 system21-request@xxxxxxxxxxxx

You can reach the person managing the list at
                 system21-owner@xxxxxxxxxxxx

When replying, please edit your Subject line so it is more specific
than "Re: Contents of SYSTEM21 digest..."


Today's Topics:

   1. RE: JBA Reporting (Joe Roesch)
   2. RE: JBA Reporting (Bill Pinnington)
   3. RE: JBA Reporting (Dan Thomas)
   4. Accrual Report Problem (Ostrowski, Bruce)
   5. Manufacturing Requirements Planning - MPF option 13 (Kate Healy)
   6. RE: JBA Reporting (Bill Pinnington)


----------------------------------------------------------------------

message: 1
date: Mon, 7 Jul 2003 09:18:04 -0400 
from: Joe Roesch <jroesch@xxxxxxxxxxxxxxx>
subject: RE: [SYSTEM21]   JBA Reporting


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.


------------------------------

message: 2
date: Mon, 7 Jul 2003 15:00:11 +0100 
from: Bill Pinnington <BPinnington@xxxxxxxxxxxxx>
subject: RE: [SYSTEM21]   JBA Reporting

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
________________________________________________________________________

------------------------------

message: 3
date: Mon, 7 Jul 2003 10:44:40 -0400 
from: Dan Thomas <dthomas@xxxxxxxxxxx>
subject: RE: [SYSTEM21]   JBA Reporting

We have been using Transformation server for about three years now and the
performance increase was 10x to 90x depending upon the application.  Our
queries are web Active Server Pages and MS Access.  We do have a low end
AS/400 (620-2179), but that increase was with a moderately configured SQL
Server box (1 ghz Xeon).  We are ordering a new AS/400 810-2466 and a new
SQL Server.  I'll post performance comparisons when both new boxes are
installed.  I expect the differences to be less pronounced, but still
significant.  The nice thing about this setup is that you can optimize the
SQL Server box for queries.  It also provides a nice standby system (i.e.
stock locations) if your AS/400 ever goes down.  You can set up
Transformation server to send data to multiple SQL Server boxes if your
needs dictate.

One thing to keep in mind is that Transformation server is going to want a
unique key for each file.  This is a real challenge for many of the JBA
files.  Biggest problems we have run into is INP95, PMP09 and CRP09.

Dan Thomas
Director of Information Technology
MDI
4500 Progress Blvd
Louisville, KY  40218
(502) 318-1208

This message is a privileged and confidential communication protected by 
the
Electronic Communications Act and is intended for the designated 
recipients
only.  Duplication or distribution of this email beyond the intended
recipients without prior written consent of the sender is strictly
prohibited.


-----Original Message-----
From: Bill Pinnington [mailto:BPinnington@xxxxxxxxxxxxx]
Sent: Monday, July 07, 2003 10:00 AM
To: 'System 21 Users'
Subject: RE: [SYSTEM21] JBA Reporting


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

------------------------------

message: 4
date: Mon, 7 Jul 2003 10:00:31 -0500 
from: "Ostrowski, Bruce" <BOSTROWSKI@xxxxxxxxxxxxxxx>
subject: [SYSTEM21]   Accrual Report Problem

Has anyone every had a problem with the accruals report being incorrect. 
It
looks like the PO has been received and matched, but the accruals report
still shows the PO line item.   It look like the PMP09 record has not been
updated.  Any ideas on how to fix or verify what records need fixed.  Any
help would be appreciated.
 
Thanks
Bruce

------------------------------

message: 5
date: Mon, 7 Jul 2003 16:21:04 +0100 
from: Kate Healy <Kate.Healy@xxxxxxxx>
subject: [SYSTEM21]   Manufacturing Requirements Planning - MPF option
                 13

Is there anyway of uploading data from Excel to MPF? We find that
maintaining the item forecast is very time consuming. We have 100 
different
models, and tend to enter details for 26 weeks at a time.


Is there any other approach that will have the same end result?

Regards,


Kate Healy.
Ei Electronics
Phone: +353 61 471277
Fax:     +353 61 471140
Homepage:  www.eielectronics.com
----------------------------------------------------------------------------
------------
This e-mail is intended only for the recipient(s) and may contain
confidential and/or privileged information. If you have received this
communication in error, please notify the sender immediately. Any
unauthorized disclosure, dissemination or use of this transmission is
prohibited.









------------------------------

message: 6
date: Mon, 7 Jul 2003 16:21:45 +0100 
from: Bill Pinnington <BPinnington@xxxxxxxxxxxxx>
subject: RE: [SYSTEM21]   JBA Reporting

Dan,

We also suffer from a lack of unique key on all JBA files, INP95 and PMP09
being prime examples as you say.  You can work round this by using the
Relative Record Number (RRN) which gives you a unique key.  It works well,
but watch out after archiving when you reorg your files!!!

Regards,
Bill

-----Original Message-----
From: Dan Thomas [mailto:dthomas@xxxxxxxxxxx]
Sent: 07 July 2003 15:45
To: 'System 21 Users'
Subject: RE: [SYSTEM21] JBA Reporting


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

We have been using Transformation server for about three years now and the
performance increase was 10x to 90x depending upon the application.  Our
queries are web Active Server Pages and MS Access.  We do have a low end
AS/400 (620-2179), but that increase was with a moderately configured SQL
Server box (1 ghz Xeon).  We are ordering a new AS/400 810-2466 and a new
SQL Server.  I'll post performance comparisons when both new boxes are
installed.  I expect the differences to be less pronounced, but still
significant.  The nice thing about this setup is that you can optimize the
SQL Server box for queries.  It also provides a nice standby system (i.e.
stock locations) if your AS/400 ever goes down.  You can set up
Transformation server to send data to multiple SQL Server boxes if your
needs dictate.

One thing to keep in mind is that Transformation server is going to want a
unique key for each file.  This is a real challenge for many of the JBA
files.  Biggest problems we have run into is INP95, PMP09 and CRP09.

Dan Thomas
Director of Information Technology
MDI
4500 Progress Blvd
Louisville, KY  40218
(502) 318-1208

This message is a privileged and confidential communication protected by 
the
Electronic Communications Act and is intended for the designated 
recipients
only.  Duplication or distribution of this email beyond the intended
recipients without prior written consent of the sender is strictly
prohibited.


-----Original Message-----
From: Bill Pinnington [mailto:BPinnington@xxxxxxxxxxxxx]
Sent: Monday, July 07, 2003 10:00 AM
To: 'System 21 Users'
Subject: RE: [SYSTEM21] JBA Reporting


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
________________________________________________________________________
_______________________________________________
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 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 is the System 21 Users (SYSTEM21) digest 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.



End of SYSTEM21 Digest, Vol 1, Issue 541
****************************************

------------------------------

_______________________________________________
This is the System 21 Users (SYSTEM21) digest 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.



End of SYSTEM21 Digest, Vol 1, Issue 542
****************************************



As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.