zaya80

Dear Hasham Thank you for your response. But it doesn't still work. (Or i hadn't understood your answer :-( ) In the TextField i was giving this formula: ( $F{QUANTITY}==""? $V{CountRow}:" ") ($F{QUANTITY} is the column in the Detail Band,in which i searching for empty fields $V{CountRow} is a variable, which has following properties: Calculation: Count Increment type: Column Reset Type: Report Variable Class: java.lang.String) I hope, you understand my horrible english. Regards, Zaya

HI all, I'm using iReport 3.5.2. I would like to count in my report all empty cells in a column. TheFormula in excel is COUNTIF(B8:B500;"") Due to the special sign " (quotation mark) i have to escape the sign with \. (COUNTIF(B8:B500;\"\")) But this Formula doesn't yield any result on the export sheet. (see the code mentioned below) Has anyone an idea how could i write this formula in iReport? Thanks, Zaya Code:<reportElement key="staticText-31" mode="Transparent" x="176" y="90" width="257" height="15"><propertyExpression name="net.sf.jasperreports.export.xls.formula"><![CDATA["COUNTIF(B8:B500;\"\")"]]></propertyExpression></reportElement>