In iReport 3.0.0 version , how can one specify Report element property expression. I need to specify excel formula through property expression "net.sf.jasperreports.export.xls.formula"
I couldn't find the place, where in Ireport to specify the above expreesion. This is very urgent, Can somebody help me.
I couldn't find the place, where in Ireport to specify the above expreesion. This is very urgent, Can somebody help me.
1 Answer:
Posted on July 25, 2008 at 9:57pm
1. Open iReport 3.0
2. Open your JRXML file
3. Insert "Static Text" from tool bar
4. Right Click on Newly added Static Text
5. Select Custom Element Properties
6. Click On new button
7. Property Name : net.sf.jasperreports.export.xls.formula
8. Property Value : write any valide Excel expression i.e. sum(B1:B10) .
remember don't put = sign before formula
9. compile and export report in Excel
10. enjoy formula....
- By KP Bird
