Page Designer – Fixed Height Tables that pad empty rows

There are two types of Report Layouts, Continous Page Layout (CPL) and Fixed Page Layout (FPL).

By default a Continous Page Layout (CPL) is used but to fix the height of the Table area the Layout will need to be converted to a Fixed Page Layout (FPL).  The general idea here is that we want to fix the height of a Table area so that it always takes the same about of space on the page and fills the remaining space with empty rows.

There are two ways to change a CPL Layout to FPL

1 ) Select menu File – New
2) Converting the existing Layout CPL to FPL by select the menu Report – Convert to FPL Report

When in Fixed Page Layout mode you will see the page size grid in full the background.

Select Menu File – New

Select No to using the default Template so that you get a fixed blank Page

Create a Table and on the Whole Table Properties set the Fixed Size Property Height.  You will notice a hashed grid wil appear below the Table to show the space it will fill

Select Menu Report – Convert to FPL Report

Preview

Notice the rows will pad with space to fill the fixed height now

Add Details below the Fixed Table Section

If you place items under this table section it will display the first value or if you use =Sum the total value

If you use =Sum( name ) then it will be the Final Total of the dataset

Any other field references=Name  will show the first value in the dataset

Preview Showing Sum outside of the Fixed Table seciton