jang888

I appreciate you for replying, lucianc I have an another question. Our product manager wants to put a default value as a dash( "-" ) if the value of columns is ZERO or NULL in the report. However, when exporting the excel report, the columns should be "numeric" for pivoting. Is there anyway that I can achieve it? Thanks,

Hi, I know there is an expression syntax for parameter, field, variable and resource bundle. parameter: $P field: $F varaible: $V resource bundle: $R But, I don't know how to retrieve property in jrxml. I just tried to use $ only but got exception. Could you let me know if anyone knows? Thanks, Code:<property name="report_type" value="html"/>.........<printWhenExpression>new Boolean(${report_type}.equals("html"))</printWhenExpression> <= error

Hi, Is there anyway that I can distinguish the output format (xls, pdf, csv,..) in jrxml. I need to apply different pattern for each output format. Thank you for your help. Code:<textField isStretchWithOverflow="true" isBlankWhenNull="true"><reportElement key="textField" style="detail" x="1290" y="0" width="90" height="18" stretchType="RelativeToTallestObject"><printWhenExpression>new Boolean({OUTPUT_FORMAT}.equals("EXCEL"))</printWhenExpression></reportElement><textFieldExpression class="java.lang.Double"><![CDATA[new DecimalFormat("#,##0.0000")).format($F{test}]]></textFieldExpression></textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"><reportElement key="textField" style="detail" x="1290" y="0" width="90" height="18" stretchType="RelativeToTallestObject"><printWhenExpression>new Boolean({OUTPUT_FORMAT}.equals("PDF"))</printWhenExpression></reportElement><textFieldExpression class="java.lang.Double"><![CDATA[new DecimalFormat("#,##0.00")).format($F{test}]]></textFieldExpression></textField>

Hi, Is there anyway that I can distinguish the output format (xls, pdf, csv,..) in jrxml. I need to apply different pattern for each output format like <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement key="textField" style="detail" x="1290" y="0" width="90" height="18" stretchType="RelativeToTallestObject"> <printWhenExpression>new Boolean({OUTPUT_FORMAT}.equals("EXCEL"))</printWhenExpression> </reportElement> <textFieldExpression class="java.lang.Double"><![CDATA[new DecimalFormat("#,##0.0000")).format($F{test}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement key="textField" style="detail" x="1290" y="0" width="90" height="18" stretchType="RelativeToTallestObject"> <printWhenExpression>new Boolean({OUTPUT_FORMAT}.equals("PDF"))</printWhenExpression> </reportElement> <textFieldExpression class="java.lang.Double"><![CDATA[new DecimalFormat("#,##0.00")).format($F{test}]]></textFieldExpression> </textField> Thank you for your help.