With a Scripted dataSet this is a way to put an element on the bottom of the last page of a report

GLO_FR
edited February 11, 2022 in Analytics #1
With a Scripted dataSet this is a way to put an element on the bottom of the last page of a report.<br />
<br />
In this report, my bottom element is 10 lines height and I can put 40 lines in a page<br />
So if I have :
    <br />
  • 30 rows, it is OK : 30 lines on the page + 10 lines for my footer<br />
  • 40 rows, I will have a page break so I need to add 30 blank lines : 1 page with 40 lines, one page with 30 lines + footer<br />
  • 50 rows, 1 page with 40 lines, 1 page with 10 lines, 20 blank lines + footer<br />
  • 75 rows, 1 page with 40 lines, 1 page with 35 lines + 5 blank lines, 1 page with 35 lines + footer<br />
  • etc..<br />
<br />
For this, I'm using a scripted dataSet and do everything in the "open" and "fetch" event
Warning No formatter is installed for the format ipb