Passing Multiple Parameters In Crystal XI

[Former Member]

I have a need to pass 3 parameters in Crystal XI and then let the user have their choice from which to select. I would like to pass the following parameters: "Salesman #", or "Customer #" or all "Salesman". Is it possible to setup a parameters that would allow you to choose which of the parameters being passed without needing to fill in the other values.

Thanks for your help

Jim Dyer

[Former Member · Accepted solution]

Create two parameters.

first one will be of type String and will contain the following 3 values:

Salesman #

Customer #

All Salesmen

Second parameter will be of type Number and will have a default value of zero.

If the user chooses Salesman # or Customer # then they can enter a value in the second parameter (if they dont then it will look for either the saleman or customer number to be zero in the database).

For your selection criteria:

if {?parameter1} = 'Salesman #' then {database.salesman#} = {?parameter 2}

else

if {?parameter1} = 'Customer #' then {database.customer#} = {?parameter 2}

else

if {?parameter1} = 'All Salesmen' then {database.salesman#} = {database.salesman#};