t3en4

Hi there, i need some help with this. I have 2 timestamp wich represent a range of days. Im calculating Business Hours calculate values (this means for example average between those timestamp only counting monday to friday between 9 - 18 )... the thing is i already figured it out the day filter (Example: monday - friday) like this: (On the "print when:" detail band section) new Boolean ( ($F{datatime}.getDay() >= 1 && $F{datatime}.getDay() <= 5) ) and it works fine, but i need to define hours range... and using .getTime doesnt work for me cause that function returns number of millisec from 1970-01-01 00:00:00 till the date set on my timestamp, and a comparision like this: ($F{datatime}.getTime() >= (8*3600000) && $F{datatime}.getTime() <= (18*3600000)) doesnt make any sense....(cause 8*3600000 its and absolute hour... not a relative from 1970-01-01 00:00:00)... please help me... if theres other way, like creating a variable or somethig let me know =) thx;)

hi anujapuri there. i cant display multiple lines or series in the same chart. i saw your chart image (and it makes just what i need) and i want to know if you can please make your .jrxml public o send it to my email valentina.trujillo@gmail.com thanks! :blink:

Hi, i need help!!!... i've a very simple table in a databas, datatime (DATETIME) value (DOUBLE) template_id(INT)+ +---------------------+-------+-------------+ | datatime | value | template_id | +---------------------+-------+-------------+ | 2008-05-09 09:00:00 | 0 | 1 | | 2008-05-09 09:05:00 | 0.1 | 1 | | 2008-05-09 09:10:00 | 0.2 | 1 | | 2008-05-09 09:15:00 | 0.3 | 1 | | 2008-05-09 09:20:00 | 0.4 | 1 | | 2008-05-09 09:00:00 | 0.5 | 2 | | 2008-05-09 09:05:00 | 1 | 2 | | 2008-05-09 09:10:00 | 1.5 | 2 | | 2008-05-09 09:15:00 | 2 | 2 | | 2008-05-09 09:20:00 | 2.5 | 2 | | 2008-05-09 09:00:00 | 0.1 | 3 | | 2008-05-09 09:05:00 | 0.3 | 3 | | 2008-05-09 09:10:00 | 0.5 | 3 | | 2008-05-09 09:15:00 | 0.7 | 3 | | 2008-05-09 09:20:00 | 0.9 | 3 | +---------------------+-------+-------------+ i need to create a time-series chart (with two lines o variables in this case, cause i have 2 different template_id (1,2)) that shows on the X axis datatime and value on the Y axis. My query is shown bellow: Select * from data_valueorder by template_id, datatime; of course i need to filter... so, on the chart properties i created two series: - first one: Series Expresion: "template = 1" X Expression: $F{datat ime} Y Expression : ( $F{template_id}.equals(new Long(1)) ? $F{value} : null ) - Second: Series Expresion: "template = 2" X Expression: $F{datat ime} Y Expression : ( $F{template_id}.equals(new Long(2)) ? $F{value} : null ) the thing is, i doesnt show the first line... actually, if i had more template_id entrys (lets say 1,2,3,4,5).... my chart always displays the values of the last template_id (5 in this case).. can anyone PLEASEEE help? :(