jasper report calculation using current and next row

[nithinabaq.us]

Hi ,

  I want to show the difference of the current and the next reocrd in jasper report.How can i show that. I know how to show difference between current and previous ( http://community.jaspersoft.com/wiki/getting-previous-records-value-calculation-variables-etc ) like that is there anyway???

 

[calculate.machine]

The calculating of difference between the current and the next/previous record is inter-row calculation, for which Jasper has little support. It’s quite difficult to handle it using Jasper. In this case you can try esProc, in which the next record can be represented, for instance, by amount[1] and thus the difference between it and the current record is amount-amount[1]. In this manner the growth rate between two records can be represented by (amount-amount[-1])/amount[-1].

 

Jasper can connect to an esProc script through JDBC and calls it in the same way as that in which it calls the stored procedure. See http://blog.raqsoft.com/?p=2918 for more details about the topic.