You should make use of "$P!" Parameters in Jasper. Your SQL query should be like: Select col1, col2 from table where myownfilters and $P!{newParam} Then in your jasper report, add this parameter newParam and set the default value as: $P{yourInputControl} == "Invoice Address" ? "SalesLedger.Customer.Address.AddAddressNumber" < 101 : "SalesLedger.Customer.Address.AddAddressNumber" > 100 Hope this helps!