Sum on specific rows in iReport

[welsa.chy]

Hi Eeveryone,

i've been stuck on that for days now..

I have a report where i am displaying data as below:

ID      Type       Number_of_Vehicles

1       Car        1000

2       Lorry      200

3       Truck     400

 

I would like to sum only the Type "Car" and "Truck".

I created a new variable named TOTAL, then the below properties:

Variable Class: java.lang.Integer

Calculation:Sum

Variable Expression: ( $F{ID}== 1 || $F{ID}==3 ? $F{Number_of_Vehicles} : 0 )

But it gives me the last number that is "400"

Can anyone figure this out?

Thank you so much..

 

[ajinkya_c]

Create three variables

Var1(CAR)=Number of vehicles

Var2(Truck)=Number of Vehicles

Var3(Total)=Var1+Var2

[shravanmudumba]

try adding in the query by using a if case and a view...I have dont in the similar way .I couldnt find the solution ....the condition is wrong$F{ID}== 1 || $F{Type}==3 use id instead of type .. but I dont think that will help you

[welsa.chy]

Thank you ajinkya_c for your response :) I created a variable TOTAL_TRUCK with the variable expression ($F{ID}==3 ? $F{Number_of_Vehicles} : 0 ) and tried to display it .. its returning me a "0"

 

 

[jatinb]

Hi welsa.chy,

 

Which is the band where you have placed the "TOTAL" variable i.e. Column Footer, Page footer or Summary?  What is the Reset type for the "TOTAL" variable (ideally it should be Report if in Summary Band)

 

The Variable Expression- ( $F{ID}== 1 || $F{ID}==3 ? $F{Number_of_Vehicles} : 0 ) or even

( $F{Type}== "Car" || $F{Type}== "Truck" ? $F{Number_of_Vehicles} : 0 )  should work for you.

 

Let me know if this works.

 

Regards,

Jatin

 

[welsa.chy]

Hi Jatinb, yea i placed it in all of the bands.. but it would not work.. :( in fact i have a stored procedure which is returning me these data. and i tried putting it in the summary band. the TOTAL Variable is returning me "0" when i put ($F{ID}==1 ? $F{Number_of_Vehicles} : 0 ) in the variable expression and it is giving me a "400"(the last value of the field[Number_of_Vehicles] obviously) when i put ($F{ID}==3 ? $F{Number_of_Vehicles} : 0 ).

[jatinb]

What is the RESET type set for "TOTAL" variable?

 

[welsa.chy]

My RESET TYPE is set to "None" is it okey?

[welsa.chy]

Thank you so much Jatinb.. if you didn't mentioned the reset type i would have never thought about it. I am new to jaspersoft. The RESET TYPE should be set to "Report".

[saroj.shandilya]

( $F{ID}== 1 || $F{ID}==3 ? $V{Number_of_Vehicles} : 0 )

[saroj.shandilya]

Hi,

 

You can keep any no of condition. just update ur variable expression like below then use variable in footer or summary. dont change exp once you dragged it to ur column footer. If you need t modify change ur variable exp instead of field in footer

( $F{ID}== 1 || $F{ID}==3 ? $V{Number_of_Vehicles} : 0 ) 

 

Regards

Saroj Jha

[saroj.shandilya]

Hi,

 

 

 

You can keep any no of condition. just update ur variable expression like below then use variable in footer or summary. dont change exp once you dragged it to ur column footer. If you need t modify change ur variable exp instead of field in footer

 

( $F{ID}== 1 || $F{ID}==3 ? $V{Number_of_Vehicles} : 0 )

 

 

 

Regards

 

Saroj Jha