How can i configure input controls so it will not require user input and still return data in my report?

[banderton_1]

How can i configure input controls so it will accept nulls and still return data?  The use case is for when you may or may not want to require an input control on a report.  If the user leaves the input text field null, then all values will return.  Currently, no values return and I do not want the filtering to be mandatory.

[ajinkya_c]

Hi,

I did the same thing in iReport based report

1. create dynamic where condition in parameter P!{} .

2. Write condition in parameter

if(param1!=null ?  " where field=param2": null)

so that if the you provide not null value then it will use dynamic where condition in your query ortherwise it replaced with null value so there is no filter in the query.

Try this if you are using iReport.

Regards

Ajinkya