Here is another option, giving a value in hours. This is total elapsed time between ticket open and ticket close - using 'now' in place of close_date if the ticket is still open. Assuming the ticket fields are labelled cr.open_date and cr.close_date, three variables are used:
Name | Type | Expression |
---|
vop1 | Long | DATEVALUE($F{cr.open_date}) |
vcls1 | Long | IF($F{cr.close_date} == null, DATEVALUE(NOW()), DATEVALUE($F{cr.close_date}) ) |
vDiff1 | Long | ($V{vcls1} - $V{vop1}) / (1000 * 60 * 60) |
'vDiff1' is the elapsed time in hours.
Hope that gets you some way towards what you're looking for.