Adding and removing rows

You can add rows to your report design. New rows are added below the selected row, in the same section. New rows can be added to Page Header, Header, Total and Subtotal sections.

Note: There is always an empty row and column at the end of the report design. This ensures that there is a border around the report when it is generated in an Excel worksheet. However, you cannot edit this row or column
  1. In your report layout, highlight a cell in a Page Header, Header, Subtotal or Total section.
  2. Click the + button in Section Rows and set the number of rows you want to include.
    The specified number of rows is added below the selected row, in the same section. A blank row is always included. For example, increase the number of rows to 2 to include one new row and to keep one empty row at the bottom of the section.
  3. To remove a row, click the - button in Section Rows and set the number of rows you want to remove.
    Note: 
    • The smallest number you can set is 1.
    • You cannot remove the empty row at the end of the report.