Pass Null Parameters to ireport

[robert_mx7]

Hi

I want to pass null report parameters to a report created in ireport, and for the report to still run. Reason: Adempiere users are used to entering blank date ranges for unused parameters like say account date, and just entering the parameters they want - date created, invoice date etc.

I found this simple solution  failed for me in Edit -> Report query. Is it a bug?

select * from <any table of your choice>
where ( (<some date field>  >=    $P{param1}) or ($P{param1} is null) )

param1 is also of type date, and I expect (but don't find) that the report should still generate output even when I select "use default" on the parameter pop up. All I get though is "the document has no pages"

Maybe param1 is not null? but if you change the query to

select * from <any table of your choice>
where ( (<some date field>  >=    $P{param1}) or ($P{param1} is not null) )

then I find  the report still produces no output. Choose a parameter value, and it does.

[hangman01]

Try:

select * from <any table of your choice>
where <some date field>  >=    nvl($P{param1},<some date field> )

I have done this on reports where I needed to produce one report by an ID or the entire batch at one time.

Hope that this helps.