Re: Field selection for users Iseries Data

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.