General parameters of data table can be set up on the Parameters side panel tab.
The Parameters tab in express report and dashboard:
The Parameters tab in regular report:
By default, element names are displayed without hyperlinks, as a plain text.
In order dimension element names are displayed as hyperlinks, deselect the Hyperlinks as Plain Text checkbox on the Parameters side panel tab.
NOTE. Only the dimension elements with child elements are displayed as hyperlinks.
By default, clicking the hyperlink leads to elements of the child level of hierarchy. To change the operation executed on the hyperlink click, use the Detailing side panel tab. The tab is available if dimension or level is selected.
The following parameters can be set for data table in regular report:
Identifier. Data table identifier as a sheet object.
Sheet. List of sheets available to move table data. By default the name of table sheet were data area is located is displayed.
Area Borders. Data table cell range.
Behavior. Behavior of rows and columns on adding new element to the table:
Fixed. The number of data table rows/columns will be fixed (determined in the Area Borders parameter), and will not change on selecting dimension elements.
Grab Adjacent. If the number of data table rows/columns is increased, the rows/columns not included into the table will be moved to the adjacent rows/columns of the table sheet.
Insert. If the number of data table rows is increased, the required number of rows will be added to the report sheet. Therefore, the information in the rows below will be moved down.
Save Data to Source. Selecting the checkbox enables the user to save changed table data to data source. If the checkbox is deselected, changed data cannot be saved to data source.
Use Sheet Formatting. If the checkbox is selected, table sheet formatting will be also applied to the data table located on this sheet. If the checkbox is deselected, changes in table sheet formatting will not affect data table formatting.
See also: