how to set the parameter fields

building reports crystal reports
1

Hi,

I’m using Crystal Report XI and my data in the database are in CAPITALS. When I drive a parameter in “lower case” it does not return the data because it needs to be in capitals. My intention is that when I enter the parameter either in uppercase or lowercase likes 22jb or 22JB, I want it to return the data for me.

Please advise how can I achieve that. Thanks.

Regards,
Andrew

al123402 (BOB member since 2006-09-25)

2

One thing I forgot to mention. I’m thinking of using the uppercase function to convert the parameters to uppercase likes,

uppercase({?CABLE SEGMENT})

but I’m getting the following errors…

This array must be subscripted. For example: Array [1]

In this parameter ?CABLE SEGMENT, under the in value options, multiple value is set to true which I would want it to accept multiple entry.

Please advise how can I resolve this problem.

Thanks in advance.

al123402 (BOB member since 2006-09-25)

3

Hi,
That’s very odd. I’ve used multiple value parameters in a similar way before and not had a problem.
First thing, check that you are using ‘in’ in your record selection criteria instead of =.
Then consider the use of the Join function which will turn your returned parameters values into a separated list:
Join({?CABLE SEGMENT,},", ")
will give you a list of all your cable segments separated by “,”.
Worst comes to the worst you could try looping through the values brought back in the parameter and creating a list.
Cheers,
BatCat

BatCat :uk: (BOB member since 2004-05-18)