Entering Multiple Values for Parameter Fields

[luvmy2kids]

I have a report created and the employee would like to enter multiple values for the parameter @customer? I changed the parameter setting to "Allow Multiple Values", but when one of the values that I enter don't have any data, it doesn't return any data at all? Is there a way to allow multiple values and it return data whether all the values have data or not?

Thanks for any help on this!

 

[dunlop1975]

I think you need to provide more information, what are you usng this parameter for?

Do they pick the values from a table that the parameter is linked to or is it just free text?

 

[luvmy2kids]

Currently it is just free text. I tried importing a file so they could select from the list, but for some reason I was not able to import the data in.

 

[dunlop1975]

Are you just tryng to display the free text infomation on the report or is it linking to a table as part of the selection criteria?

 

[luvmy2kids]

Linking to a table as part of the selection criteria.
Thanks!

 

[dunlop1975]

That's always scary ; ) What version of CR reports are you using?

You should be able to link the parameter to the table and pull in all the possible values (so people would select the values as opposed to typing them). It is slighly problematic if this is a table that is constantly updated and you do not have CR XI or higher.

More info is definately needed

What version of Crystal Reports are you using?
What exactly does this parameter link to? Provide sample data

 

[luvmy2kids]

I am using version XI and the parameter links to the name field in the customer table, example below:

CHARLES LUNSFORD &SONS
CHASE MANHATTAN
Eisner and Lubin

This is how my parameter is setup so they can type some of the letters just in case they don't know the correct spelling:

where name like @Custname

 

[dunlop1975]

The problem seems to be that your are not trapping for a "blank". The selection criteria is looking only for records that have name as blank.

try something like

if @Custname = "" then name like "*"
else name like @Custname

This is assuming that if a blank is left for the customer parameter, you would like all the records to be pulled (I do not know what you are grouping on)

 

[luvmy2kids]

Okay, thanks!