Re: Field selection for users Iseries Data

[Alan Campin <alan0307d@xxxxxxxxx>]

I would think your best bet is a stored procedure. Let the work be done on
the iSeries and only the result set is returned. Best to do this in any
case. i am not sure within Crystal how you are going to display different
fields are at different times.

In the stored procedure use SQL to either use a static query or use a
prepare to build a dynamic query.


On Sat, May 18, 2013 at 7:46 PM, Crystal Reports <
crystalcleardecisions@xxxxxxxxx> wrote:

> HI I wanted to get some opinions from you guys. We have a request to
> create a front end with Crystal Reports. The idea is that the user will
> select which fields they want to see
> and then pass these to the Crystal Report. The data resides on the
> Iseries. I see so far that time to run the CR is pretty slow because they
> are doing alot of the processing on Crystal (using the Report Record
> Selection) but I want to create Logical files for this purpose.
>
> But I wanted to get some feedback on how you may have done this in the
> past. Does it work out well for the users that  they select fields ? I can
> think of one problem that the business rules and logic are not involved per
> se, unless you code for that. I would like to hear if you have been
> successful to implement this type of solution. I should note that i have
> gotten this same type of request in my other job, a sql server shop where
> we are going to create an XML file for the user.
>
> Thank you,
> Paul
> --
> 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.