Repayment Schedule

Category : Business Examples

An example of how to fill tables with data and manage what happens when the table runs over the bottom of the page.

Includes examples of Date and Currency formatting using built-in renderers.

Data Files
Output Files
All Files as a ZIP

This example explained

1) Filling Tables with data.

    The table starts at the bottom of the first page and depending on the amount of data, may flow on to the second page.

    By setting the Table Properties in the template, you can control whether the whole table should start on a new page, or perhaps just repeat the header row on the next page.

You can find more details on this behaviour in our blog called: Tips for Creating a Reporting Template.


2) Formatting Dates and Numbers

    This template makes use of the built-in renderer feature.


    The DATE renderer looks like this:

    {renderer=date('EEEE, dd MMM yyyy','MMddyyyy')}

    The first format string specifies how you want the Date to appear in the document.

    The second format string specifies how the Date is encoded in the data.

    So this: 08112015 turns in to this: Tuesday, 11 Aug 2015


    The NUMBER renderer looks like this:


    This will format any number so that it

  • starts with a '$' sign
  • has an optional comma at the thousands
  • finished with at least one number before the decimal point
  • has two numbers after the decimal point.

    So this: 1200 turns in to this: $1,200.00


    You can find more details on the formatting options in the Developer Guide from our Resources section.