robert_mx7

I found this problem has been fixed on ireport v3. We are still using an earlier version that has been integrated into Adempiere.

I'm working late tonight trying to solve the same problem!!- I want to compare a big decimal field with a big decimal parameter, but it never works. Reason- drag any big decimal parameter onto any area of a report and then run it. Result: whatever I enter in for the parameter value (am I missing a special format here?) the parameter appears "null" on the report. Only the parameter default can be set. Change parameter type to String, Double etc then there is no problem doing this. Maybe change parameter to Double, compare the doubleValue() of Big Decimal fields? I'll give it a go. Nice to know whats going on with BigDecimal though, anyone know the answer?

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.