Hi all, hope you can help me.
I have several filters (parameters) in my report like gender, eye color, hair, etc.
The user can select each characteristic or left it blank. When left blank, the report should return all records.
For each filter I started to use something like:
SELECT * FROM CANDIDATES where $P{GEND} = GENDER
but this way the parameter can't be left blank. How can I change the script in order to allow blank filters to return all options?
Thanks in advance