1 Parameter, multiple fields... can do ?

[FredGexel]

Hi there folks,
I'd like to know if any of you know a way to do what i'm looking for. Here's the pattern. I got an employee table with a first_name field, a last_name field and an ID. Is it possible to make that the parameter is a combinaison of both names (last_name, first_name) w/o creating a field in the table and that the selection on my table is based on the ID of the employee selected.

for instance :

first_name last_name ID
John Doe 1
Jim Price 4
Bob BillyBob 6

the parameter would have the following values :
Doe, John
Price, Jim <----- SELECTED
BillyBob, Bob

and the selection formula would be
{employee.ID} = {?id}

Or if you know how, i dont mind doing my search using the last_name first_name combinaison.

Reguards

 

[IdoMillet]

If you know all emp_id's when you create the parameter,
specify all of them in the list of DEFAULT VALUES and click on 'Define Description' to enter the employee name for each ID value.

Cheers,
- Ido

ixm7@psu.edu

 

[kenhamady]

Ido is correct, but if you are wanting the list to assemble the names from the tables you are going to have to write a front end in VB. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[FredGexel]

Tks a lot !