I couldn't find the place, where in Ireport to specify the above expreesion. This is very urgent, Can somebody help me.
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