r17

hello can some kind souls teach me how to use list with the help of sql? i tried searching on the web but apparenlty, there's NONE. with result to me in seeking help from here. or perhaps you guy has some good websites that teach how to use list with sql. thanks alot .

This is what i had type in my field $F{Jan} == 1? $F{Jan} :new Double($F{plannedamount}) / (new Integer($F{Jan})+ new Integer($F{Feb}) + new Integer +new Integer ($F{Dece})) what i'd like to do is to "sum" up all the variables for jan. is there a way to do so?

thanks alot. it helps.

thanks alot slow. sadly, I know nuts about java but was tasked to do on ireport.

Jan Feb Amount 1 0 0.09 As shown, i have a table with 0 and 1. is there a way in which im able to use if statment such that if jan = 1, it will show the amount else if it is 0 = null. Thanks!

hello, I have a table of data filled with 0 and 1. i'd like to use print when expression such that when the data is = 1 it will show the variables figure. if is o data will 0.

Alright, i solved it. thanks !

this is my sql statment SELECT*, campaignmonth, substring(campaignmonth,1,1)as Jan From campaign; I'd like to sum up all the substring information as shown in the table above. is there a way to do so?

hi slow, thanks for helping me but your answer doesnt apply to mine. i wanna add up all the 1 together.. is there a function to do so? like sum ( substring )?????????????????

im actually trying to transfer from mysql into sql in ireport.

is there a way in which i can do in SQL?

hello, i have a table of data filled with 1 and 0 with the help of substring. Jan Feb Mar Apr May June July Aug Sept Oct Nov Dec Total 1 0 1 1 1 1 1 0 1 0 1 1 ????? is there a way in which i am able to add up all the 1 (formed by substring) ?? Thanks :D