RE:

Thanks Mark for adding more information for him....

The trick to CR is to do as much as possible on the IBM i before it is sent to the PC and the CR report showing the results.

Try to only send the records to the client/PC that the CR needs...

This is key to performance!

Let the IBM i do as much as it can...

Think about..

a + b = c for only customer = 123 on IBM i on a sale history file with 10 million records before it goes to client/PC and it only sends a 1000 records to the client/pc/CR or do it wrong and using just CR send 10 million records to client/PC before the a + b = c for only customer = 123 is done in CR.

Also Views stop the business from doing it to themselves...getting different results because they do not know the files and the information store in them or in some cases they just cannot add...

Thus the views as Mark stated...

Also
Do not allow full access with CR to your files on IBM i without thinking about above!


Regards,
Bill Hopkins



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mark Murphy/STAR BASE Consulting Inc.
Sent: Wednesday, May 22, 2013 5:56 PM
To: Midrange Systems Technical Discussion
Subject: Re:

Use an SQL view for best performance. But you can also use a logical file by creating one that only includes the 5 fields of interest.

Mark Murphy
STAR BASE Consulting, Inc.
mmurphy@xxxxxxxxxxxxxxx


-----Crystal Reports <crystalcleardecisions@xxxxxxxxx> wrote: -----
To: "midrange-l@xxxxxxxxxxxx" <midrange-l@xxxxxxxxxxxx>
From: Crystal Reports <crystalcleardecisions@xxxxxxxxx>
Date: 05/22/2013 12:43PM
Subject: (Untitled)

It seems to me, if I remember, the logical file, when used in Crystal REports, it passing not only all the records of the file OEOEHDOH, but also all the many fields. Is this correct?
If the CR only is interested in say 5 fields, how can we code this logical or to make a new one that will only pass less, is that a performance issue would you say?
I have also added a temporary filter to this logical
R OEORHDRR PFILE(OEORHDOH)
K OHORDT R K OHSHTC R K OHORDD R DESCEND
O OHORDD COMP(LT 20130101) *** MY ADD O OHSHTC COMP(EQ ' ')