i mean to enter, the user can choose which part numbers to enter as the
param.

On Fri, Aug 25, 2017 at 8:35 AM, Hoteltravelfundotcom <
hoteltravelfun@xxxxxxxxx> wrote:

in crystal when you create a parameter. it can be blank, the user enters
what they like, it can be a pre-determined list of possible values or
dynamic. With dynamic, lets say part number, it will display every single
part number for the user to enter.
the strange here is that it will do this display on my pc but not on the
crystal server, but it used to before the upgrade. I think it went from 7.1
to 7.3 but i have to check that.

On Thu, Aug 24, 2017 at 3:36 PM, Rob Berendt <rob@xxxxxxxxx> wrote:

And we don't know what you mean by "possible values". Do you mean:
- column list?
- possible values for a column listed in your "where" criteria?

All this makes a huge difference.

If one is unfamiliar with an upgrade all sorts of weird things may happen.
For example,
- forgetting to start the database server support after the upgrade (like
STRHOSTSVR)
- forgetting to apply any ptfs so that things will work and the INZSYS
runs
- corrupted the database cross reference files and need to run RCLSTG
*DBXREF
- left system in a restricted state and started stuff piecemeal.

So we would end up just guessing. We gave up instead.


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Rob Berendt <rob@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 08/24/2017 03:26 PM
Subject: Re: Change to a Crystal report when upgraded Ibm i
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Ok, the thing here is we have almost no information to go on.
Ok, so my knowledge of Crystal Reports is nil but stuff like this
<snip>
with one report which used to display parameters dynamically, that is, it
shows all possible values in the ibm I for the user to select from.
</snip>
only makes me wonder where it got those values originally.

And we don't know what you even upgraded: OS, Crystal Reports, ERP
package, etc.

Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 08/24/2017 03:16 PM
Subject: Re: Change to a Crystal report when upgraded Ibm i
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



HI I forgot to list the specs. IBM POwer 8 and os is 7.3

On Wed, Aug 23, 2017 at 11:03 PM, Hoteltravelfundotcom <
hoteltravelfun@xxxxxxxxx> wrote:

Greetings,

Recently a company where I have written some Crystal reports with using
the IBM I database has a problem, with one report which used to display
parameters dynamically, that is, it shows all possible values in the ibm

I
for the user to select from.

After this upgrade, I can run the report on my PC and it works normally.

But when I uploaded this to the Crystal server, it does not display all
the values.
It does allow user to enter one by one.

Can you think of any area why this would happen? I had called IBM in the
past on something similar but they were not helpful at that time, that
is,
they chased the problem to where it's not the I.

Thank you,
Joe

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

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD


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

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD


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

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD




This thread ...

Replies:

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

This mailing list archive is Copyright 1997-2019 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].