multi-range parameter values

[mgkSHA]

I am not sure if this is possible. I can do this is VB, but I am not sure how to do it in Crystal.

I have a personnel VB application I am working on. I have created a work history report that shows the present and past work history events for each employee. Now, I can easily pass a parameter with the unique social security number and pull up the employee requested as:

{ado.SSNO} = {?SSNOparameter}

The problem is, we have over 500 employees and the HR staff can't recognize an employee via their SSN number. I have a question:

1) Is it possible to pass a mulitple range parameter such as "Last Name" and "First Name". something like
{ado.Firstname} = {?NameParameter - start range}
{ado.Lastname} = {?NameParameter - end range}

I can create a parameter for first name OR last name OR SSN, I am just not sure how do get more than one.

I am sure some experienced Crystal developers have an answer to this, I am just not sure how to do it. Thanks

 

[synapsevampire]

I wouldn't use a single parmeter for the first and last name, I'd generally use a separate parameter for each.

However the Crystal syntax for a range like this would be:

(
{ado.Firstname} = minimum({?NameParameter})
and
{ado.Lastname} = maximum({?NameParameter})
)

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com