benjaminliuman

When I generate a table report and set the group's average, it will include null records, how can I ignore null records? The code is below: DJGroupVariable(AbstractColumn InegerColumn, DJCalculation Average) It seems the AVERAGE DJCalculation will include null records to caculate the average value. Example: name IntegerColumn a 2 b 5 c 2 d Average: 2.25 The average value is 2.25, but what I needed is 3.

Currently, I need to generate a title like 'User name + Created on'. If I generate it by one JRDesignTextField, like "$F{userName} + $F{createon}", the report's global timezone will not work, if I generate it by two JRDesignTextField, I can not generate it in one line, because I can not get "User name" length, if I can get its length, I can use it to set "Created on" x. Below is my code: JRDesignTextField userName = new JRDesignTextField(); JRDesignTextField createon = new JRDesignTextField(); userName.setExpression(new JRDesignExpression("$F{userName}")); createon.setExpression(new JRDesignExpression("$F{createon}")); createon.setX( "how can I get userName's length to make createon follow username");