duncanstanton

I tried changing the Evaluation Time on the textfield and went through all of the different options with the same result. Also, I am not using "Print When Expression", the code above is what is in the actual text field expression. The form seems to process this field once and prints it on the report, but it does not seem to want to process the text field expression a second time to make it show up in the header on the second page.

I have a report with a header band where I have a text field with a conditional (if/else) expression. The expression looks for a certain value and then prints static text from a variable. I am able to have that field show up on the first page of the report, but on the second page the field is blank. The field is only blank on the second page if I use a field without the conditional (if/else) expression. If I use a field from the data source by itself, the field is printed on both pages of the report. I am having to use the conditional expression to print static text because it does not exist in the data source. Does anyone have any advice on how to make a field like this print on all pages? Below is the code in the textfield : $F{plant_code}.contains("101") || $F{plant_code}.contains("201")? $V{v_201_Remit} : $F{plant_code}.contains("102") || $F{plant_code}.contains("202") ? $V{v_202_Remit} : $F{plant_code}.contains("103") || $F{plant_code}.contains("203") ? $V{v_203_Remit} : $F{plant_code}.contains("104") || $F{plant_code}.contains("204") ? $V{v_204_Remit} : $F{plant_code}.contains("105") || $F{plant_code}.contains("205") ? $V{v_205_Remit} : $F{plant_code}.contains("106") || $F{plant_code}.contains("206") ? $V{v_206_Remit} : $F{plant_code}.contains("108") || $F{plant_code}.contains("208") ? $V{v_208_Remit} : "CONTACT BILLING - PLANT CODE ISSUE"

I have a field that is adding up to four values together and then dividing by the number of values totaled Example : 3,3,4,4 =14/4=3.5(avg) However when I have the following : 3,3,4,null=10/3=3.333(avg) I get null because when including the null in the total, you get null. I can replace the null value with a 0 by using the following : ($V{Total_Cost_1}==null?0:$V{Total_Cost_1}.doubleValue()), but this still leaves me with a problem as the number that I am dividing by is still 4 rather than 3. Does anyone have any advice on how to tackle this problem?