Pages

OracleEBSpro is purely for knowledge sharing and learning purpose, with the main focus on Oracle E-Business Suite Product and other related Oracle Technologies.

I'm NOT responsible for any damages in whatever form caused by the usage of the content of this blog.

I share my Oracle knowledge through this blog. All my posts in this blog are based on my experience, reading oracle websites, books, forums and other blogs. I invite people to read and suggest ways to improve this blog.


Tuesday, May 14, 2013

How to Calculate Total in XML Publisher Report


declare a variable on top of the group.

<?xdoxslt:set_variable($_XDOCTX, 'TROW_NUM', 0)?>

add another variable inside the loop.

<?xdoxslt:set_variable($_XDOCTX, 'TROW_NUM',
xdoxslt:get_variable($_XDOCTX, 'TROW_NUM') +  COLUMN_NAME)?>

And put the below inside the total field

<?xdoxslt:get_variable($_XDOCTX, 'TROW_NUM')?>

1 comment: