Formatting records to span multiple rows

You can customize the layout of views so that each record is displayed on more than one row. You can use this feature to display all of the information you are interested in on screen, and avoid having to scroll to see additional information. For example, if you have a table with a number of columns you are interested in and a column that includes notes that provide more information, you could display the data columns in one row and the notes on a separate row. You can also use this feature to optimize the layout of reports generated from the view. For example, if you have two address fields in a table (address_1 and address_2) you can align the address_2 field on the row below the address_1 field in the report, to make it more readable than if these fields were side by side.

To format records in a view to span multiple rows:

  1. Position the cursor over the bottom line for any record in the record number column. The record number column is the gray area to the left of the first column in the view.
  2. Click and drag the cursor down to add rows to the record, or drag up to remove blank rows. When you modify the number of rows for an individual record, the change is applied to all records in the table and the column header is modified by an equivalent number of rows to reflect the change.
  3. To move data in a column to a different row, click and drag the column in the column header to the row in the column header that you want to add it to. The column is added to the leftmost position in the row, after any columns already in the row.
  4. Modify the position of individual columns in the row by positioning the mouse cursor over the vertical lines that mark the start and end of the column and click and drag the line to the new position.
  5. If you do not want to display all of the lines in the column header in the view, and you want to suppress some of the column headers when the view is printed, you can modify which column headers are visible. For example, if the first line has an entry for an “Address” header and the second line has an entry for an “Address_2” header, you will typically want to suppress the second line. To change the visible lines, position your mouse cursor over the black line above the scroll bar on the right-hand side of the view and click and drag the cursor up to hide column headers you do not want to include. The columns in the top row of the header cannot be hidden because the column header must include at least one row.
  6. After you have set the position of the columns and column headers, save the changes to the existing view or to a new view.

(C) 2015 ACL Services Ltd. All Rights Reserved.