RE: Re:

I would create logical just for use by CR and show them just the fields and rows you want to allow. Improves security and performance

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Hoteltravelfundotcom
Sent: Wednesday, May 22, 2013 4:44 PM
To: Midrange Systems Technical Discussion
Subject: Re: Re:

Good so in the Logical i have it seems that the logical returns all of the fields of the Physical, lets say 100 fields. WHen we may be using only 3 fields in the Crystal. Are these extra 97 fields going to cause a slower performance or its not an issue as number of records are.


On Wed, May 22, 2013 at 4:09 PM, Bill Hopkins <bhopkins@xxxxxxxx> wrote:

In the past I would create a Stored Procedures on the IBM I using
either SQL or RPG to select and generate only the records I wanted on
the CR. This greatly improves performance of CR since all the
selection and number crunching is done on the IBM i and not on the local PC by CR.


Regards,
Bill Hopkins



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:
midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of John McKee
Sent: Wednesday, May 22, 2013 2:39 PM
To: Midrange Systems Technical Discussion
Subject: Re:

The few times I have used CR to access data on the i, it was done
using the PF in a subreport. All the PF fields were available. I
would assume that a LF would only return the records it referenced and
then only the fields that were defined in the LF DDS.

John McKee


On Wed, May 22, 2013 at 11:43 AM, Crystal Reports <
crystalcleardecisions@xxxxxxxxx> wrote:

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 ' ')
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please
take a moment to review the archives at
http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.