Follow us: Connect on YouTube Connect on YouTube Connect on YouTube


Monday, 6 November 2017

Limit Number Of Records Per Page in XML/BI Publisher

XML Code to limit number of rows to a page Oracle XML Publisher

You can restrict rows in page in xml reports by using following command 

Let us take example if you want show 5 records for each page you can use follow tag and place this tag before ending loop shown image

<?if:position() mod 5 =0?> <xsl:attribute name="break-before">page</xsl:attribute> <?end if?>

Here position key word is used to find the logical position of particular records


 Report Ouput:

You May Like:

Share this article :


  1. Life saver! I looked all over for hours and saw solutions using complex variables. This worked exaclty how I needed. Thank you!

  2. Thanks Bro:D. This is the best solution i got for my problem rest all solution on net with solution as defining counter and stuff didn't worked at all.