Prompt to enter multiple parameters

[Drus]

I need to be prompted to enter two separate criteria - (1) the date range and (2) the salesperson.

I currently have the date range prompting me to enter a date range, but how can I have the next step be to enter a range of salespersons? Andrew Hagenbach
OPUS SYSTEMS, INC.
916.503.3173
ahagenbach@opus-sys.com

 

[rogar]

Add a salesperson parameter. You can make it a multiple selection or range parameter if that is what you want (what is a salesperson range? Alphabetical or by ID Number?) CR will display parameters in a listbox - you have to highlight each parameter to get its prompt message and to enter parameter values.

 

[Drus]

Worked like a charm! Thanks. Andrew Hagenbach
OPUS SYSTEMS, INC.
916.503.3173
ahagenbach@opus-sys.com

 

[Drus]

One more thing... I was successful when entering the salesperson's name, but not when entering the salesperson's code. I would prefer to use the salesperson's code, which follows a 4 numerical value format (i.e., "0001&quot. I am guessing there is something wrong with my parameter setup. I chose "String" and "Discrete Value" for both attempts. Andrew Hagenbach
OPUS SYSTEMS, INC.
916.503.3173
ahagenbach@opus-sys.com

 

[rogar]

Look at the Record Selection Formula. To select by name the formula should contain something like:
... and {MyTable.SalesmanName} = {?NameParm} ...
To select by ID the formula would have to be:
... and {MyTable.SalesmanID} = {?IDParm} ...
You will need a separate parameter to select by ID. If you want to be able to do both, your selection formula will become more complicated:
... and ( {MyTable.SalesmanName} = {?NameParm} OR {MyTable.SalesmanID} = {?IDParm} ) ...
Note the extra parentheses enclosing the two "OR" conditions.