To set up table general parameters, use the Parameters group of parameters on the parameters panel:
To open the Parameters group of parameters
To open the Parameters group of parameters on the parameters panel:
Select a cell or a cell range in the table.
Click the Parameters button on the toolbar.
Select the Table area type in the drop-down menu of the parameters panel title.
Set the parameters:
The box contains identifier of the data table as a report sheet object.
To change the table identifier, enter a sequence of Latin letters and numbers. The identifier should be unique within the report.
To move the table to another report sheet, select the required sheet in the Sheet drop-down list.
NOTE. When the table is moved from one sheet to another, table formatting and all applied settings are saved.
Name of the sheet with the table is displayed by default.
To move the table within the report sheet, change coordinate of the top left table corner.
NOTE. Table borders cannot be larger or smaller than their actual size.
The actual range of data table cells is displayed by default.
To determine behavior of columns and rows during placement on a sheet, select a mode in the parameters drop-down list:
Columns. The parameter determines how table columns and columns located to the right of the table change on table resize. The following options are available:
Overwrite Columns to the Right. If the number of table columns increases, information located in columns to the right of the table will be overlapped with table data. If the number of table columns decreases, information located in columns to the right of the table will not change its position.
Insert. If the number of table columns increases or decreases, the necessary number of columns will be added to or removed from the report sheet. Information located in columns to the right of the table will be shifted to the right/left. The number of columns during the shift will be equal to the number of columns of the added table area.
Rows. The parameter determines how table rows and rows located below the table will change on table resize. The following options are available:
Overwrite Rows Below. If the number of table rows increases, information located in rows below the table will be overlapped with table data. If the number of table rows decreases, information located in rows below the table will not change its position.
Insert. If the number of table rows increases or decreases, the necessary number of rows will be added to or removed from the report sheet. The information stored in the rows below will be moved down/up. The number of rows during the shift will be equal to the number of rows of the added table area.
Selecting the checkbox enables the user to save changed table data to data source. If the checkbox is deselected, saved data cannot be saved to the data source. The checkbox is selected by default.
To use formatting used on a table sheet to the table, select the Use Sheet Formatting checkbox. If the checkbox is deselected, changes in table sheet formatting do not affect the table formatting. Use the Use Sheet Formatting checkbox only if the table will not be dynamically rebuilt and resized at the same time.
See also: