User Defined Functions?

[ureta]

I want to be able to define my own functions to use in expressions. How may I do that?

One function that would help me a lot is something like:

    public static int intValueIfNullThenZero(java.lang.Number number) {
        return number==null?0:number.intValue();
    }
 

Is there such a function already defined?

[lucianc]

You can write this method into a utility class, compile it, place it on your application's classpath and use it in report expression.

Currently it's not possible to define a method/function inside a report definition.

Regards,

Lucian

[andrewps21]

How can I create a custom sql clause function like $X{MYFUNCT

 

 

I would really like a function similar to $X{EQUAL that provided the null clause like the $X{IN function. IE: On null rather than IS NULL appending the truism 0 = 0, this would be very handy for optional fields in my web app, so the user can provide say 1 of 10 filters. I currently have to do this with 2 paramaters which I don't like:

 

Plant Code

 

(($P{plantCode} == null || $P{plantCode}.isEmpty()) ? "" : " AND mfg_plant_code =" +$P{plantCode} +" ")

 

And in the SQL:

 

...

where $P!{plantCodeQuery}

 

I have written a JRSqlAbstractOptionalEqualClause and JRSqlOptionalEqualClause then a CustomExtensionsRegistryFactory. It adds this method:

 

protected void handleNoValues(JRQueryClauseContext queryContext) {

queryContext.queryBuffer().append(CLAUSE_TRUISM);

}

 

But I'm not sure what to do next to register my function sounds like I may be able to package it in a jar with a jasperreports_extension.properties but im not sure exactly.

 

Thanks

Andrew

[andrewps21]

Actually i got this working, the jasperreports_extension.properties file had to be in the root of the jar, it contained this: net.sf.jasperreports.extension.registry.factory.sql.clause.functions.myfunct=com.myjob.yba.plant.report.jasperext.CustomExtensionsRegistryFactory

 

It was then picked up in my web app. To get it working in ireport i had to go to tools -> options -> Classpath tab -> add jar :)