Why does Jasper display everything from a multi-select when nothing is selected?

[j.t.casperson]

It's very odd, and a little frustrating that say I have a multiselect sql statement that says $X{IN, buildings_field, buildings_parameter}, if I don't select any buildings in the multiselect it will display all buildings as if I had selected all of them. Does anyone know why Jasper does this, and how to fix it? 

[hozawa]

Simply because that's the specs. It like when if you don't specify a WHERE clause in SQL statement, all rows are selected.

[kkriplani]

Rightly said by hozawa.

But i feel there is a workaround for this.

Declare a default value say '0' in the default expression. Make sure '0' does not exist for that column in the database. Hence everytime you don't select anything, default value for that parameter would go as 0 and the result would be empty as 0 is not in that column.

 

Hope this helps,

KKriplani.