I think that the better approach is using jasper sentences for parameters like: $X{[bETWEEN], schoolName , second_Parameter, second_Parameter} AND $X{[bETWEEN], country , first_Parameter, first_Parameter} When a parameter value is null, replace its sentences with: 0=0 Regards