Re: Change to a Crystal report when upgraded Ibm i

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