wayne.shepherd

I am using Jaspersoft Studio Professional and I am trying to create an "Input Control" that has 2 elements "Invoice Address" & "Delivery Address". If the "Invoice Address" is selected then the report needs to filter the addresses that have a "SalesLedger.Customer.Address.AddAddressNumber" < 101. If the "Delivery Address" is selected then it needs to filter the addresses that have a "SalesLedger.Customer.Address.AddAddressNumber" > 100. I hope that someone can help

I have created a variable field that is either "Invoice Address" or "Delivery Address" based on an actual integer field. I would now like create a filter based on the variable field rather than the actual integer field as that contains numbers 0 thru 200 and does not mean anything to the person running the report.

Hi, I am new to Jaspersoft and this site. I am hoping that someone can help me. I am trying to create a variable from a java.math.BigDecimal 'selected field' that is already displayed on the report. If the 'selected field' = 101 then I want the variable to display "D" else "I". The variable field is also set to java.math.BigDecimal I have tried this ($F{SalesLedger.Customer.Address.AddAddressNumber}==101?"D":"I") but this returns an error. I hope that someone can help