Multi-Range parameter help

[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 two questions:

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

 

[rosemaryl]

Dear mgksha,

Sure you can do this.

Create 2 parameters, one for first name and one for last name.

In your select expert you can do:

({ado.Lastname}+{ado.Firstname}) = ({?LnameParam}+{?FNameParam})

For faster performance you can create a SQL expression that concatenates the LName and Fname and compare just that:

{#sqlexprLNAME&FNAME} = ({?LnameParam}+{?FNameParam})


Hope that helps,

ro
Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[mgkSHA]

Thanks, that is exactly what I needed. I knew it would be something simple.