Sue Taylor
asked on
Crystal Report - Parameter based on a formula?
I have a table that lists employee ID's, FIrstName, LastName, etc.
Other tables used in my report has the Employee ID.
The user isn't going to know the employee ID's, only their name.
I created a formula that displays the employee's full name. I want the user to be able to select which employees he wants filtered in the report. How can I achieve this?
Other tables used in my report has the Employee ID.
The user isn't going to know the employee ID's, only their name.
I created a formula that displays the employee's full name. I want the user to be able to select which employees he wants filtered in the report. How can I achieve this?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes, I have users with the same last name.
CR 2008
Ooh...I want CR XI!
The user will run the report via another program, uniPoint, which acts just like someone doing it from Crystal.
CR 2008
Ooh...I want CR XI!
The user will run the report via another program, uniPoint, which acts just like someone doing it from Crystal.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
1 Create a command , which will get the list of employees' IDs and names. After that create a dynamic parameter and set the datasource to the new command
2. If employee IDs and Names are available in your report you can set them directly as datasource for your dynamic parameter. Choose value = EmployeeID and Description -= Employee Name
Option 1 will be faster because you will get the list of Employees and then run the report for one employee. Option 2 will initially run the report for all employees and then will filter the report locally to show the information for just one of them. However if you want to use the report also offline, you will be able to do this with this option since all the data will be available.
I would prefer option 1