I was working on a requirement some days back wherein I had to restrict the number of records in the Pivot table on a page. Firstly, I started to look for Pivot properties but when i didn’t get anything then i used this approach.
Follow the below steps to achieve the same:
1) Go to the criteria tab of your report and add a new column(any column).
2) In the fx of that column add the following :
cast ((TRUNCATE(RCOUNT(1)/20,0)+1) AS INTEGER)
RCOUNT(1) is just like ROWNUM on Database and generates a sequence. Divide it by the number of records you want on a page in the report. Cast as Integer will remove the decimal places.
3) Now, drag this column and add it to the Page section of the Pivot Report and you achieve the target.
After following the above step, it looks like as shown below:
Posts
