Creating an Input Control

[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

[hozawa]

Recommend that you check cascading input control.

http://community.jaspersoft.com/wiki/cascading-input-controls

[gururagavan2008]

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!