I have the following situation.
I have two prompts
1. Emp_Name - Pick Employee Name
This list comes from picklist report
2. Emp_Type - Pick the Employee Type
Choice are "Creater" or "Owner". It is typed in.
My data is like the following
Record Number Record_Creator Record_Owner
1 John Smith John Smith
2. John Smith John Smith2
In the filter condition, I would like to to the following
If ?Emp_Type = 'Creater" Then
Record_Creator IN ?Emp_Name
Else
Record_Owner IN ?Emp_Name
I was not able to do this in Filter condition. It only lets me do this the following way
IF (?Emp_Name = 'Creator' then Record_Creator)
else (Record_Owner)
= ?Emp_Name
It does not let me have IN operator.
Any suggestions?
Thanks,
Ashish
I have two prompts
1. Emp_Name - Pick Employee Name
This list comes from picklist report
2. Emp_Type - Pick the Employee Type
Choice are "Creater" or "Owner". It is typed in.
My data is like the following
Record Number Record_Creator Record_Owner
1 John Smith John Smith
2. John Smith John Smith2
In the filter condition, I would like to to the following
If ?Emp_Type = 'Creater" Then
Record_Creator IN ?Emp_Name
Else
Record_Owner IN ?Emp_Name
I was not able to do this in Filter condition. It only lets me do this the following way
IF (?Emp_Name = 'Creator' then Record_Creator)
else (Record_Owner)
= ?Emp_Name
It does not let me have IN operator.
Any suggestions?
Thanks,
Ashish