Example Repayment Schedule

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.

 

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 behavior in our blog called: Tips for Creating a Reporting Template.

 

2) Formatting Dates and Numbers

This template makes use of the built-in date format and number format functions.

 

The DATE FORMAT function looks like this:

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

The first parameter is the variable you want to format.

The second is a format string specifying how you want the date to appear in the document.

The third is a format string specifying how the date is encoded in the variable.

So this: 08112019 turns in to this: Tuesday, 11 Aug 2019

 

The NUMBER FORMAT function looks like this:

{numFormat(number,'$#,##0.00')}

The first parameter is the variable you want to format.

The second is a format string specifying how you want the number to appear in the document.

The example example will format the variable 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 Template Guide.

Feedback

Invalid Input

Sorry, this field will only accept letters and numbers, and not special characters, to limit spam.

Sorry, this field will only accept letters and numbers, and not special characters, to limit spam.

Invalid Input

Applies To

Docmosis-Java Tornado Cloud
Version(s) 4.0.3, 4.1.0, 4.2.0, 4.3.0, 4.3.1, 4.4.0, 4.4.1, 4.4.2, 4.5.0 (Latest) 2.0, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.7.1, 2.7.2, 2.7.3, 2.8.0, 2.8.1 (Latest) ALL