Data:
Last_Name First_Name Last_FirstInit
Crawford Cindy Crawford C
Locked John Locked J
Locked Farrah Locked F
Johnson Cathy Johnson C
In oracle PL/SQL I could simply use statement like:
Select * from emp_tab
where last_name in...
I need to display those persons (Crawford, Locked J and Johnson) and exclude Locked F. I have only one parameter (accept multiple value) in report.
So the input would be like : Crawford, Locked J, Johnson
I like to use two fields {last_name} and {last_firstinit} such as
if {myparam} contains...
Hi,
My data look like this:
Last_Name First_Name Last_FirstInit Total_Last_Name
Crawford Cindy Crawford C 1
Locked John John L 2
Locked Farrah Farrah L 2
Johnson Cathy Cathy J 1
How can I list the names...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.