bporter

Thanks ed4becky, good solution. So iReport sends the final SQL statement to the DB Engine as "... where ... null is null" which is always true. Very much appreciated...

Hi all, Assume that I have an SQL statement such as: Select type from user where type = $P{typeParam} As long as typeParam has a value, it works fine. But what if the user wants to see all the records in user table... In this case typeParam value will be null (and there is no default value assigned to typeParam). There are some "workarounds" like passing the where clause (or even passing the whole SQL) from the application side, but it lowers the usability of iReport... Any idea?