Overview of Grid Properties
The following grid properties are available in the Properties panel while editing a grid:
General Properties
General properties affect the entire grid. Use general properties to edit some of the following types of items:
-
View or change the grid’s data source
-
Set a title to be displayed above the grid
-
Define the default grid behaviors for row and column sizing, row banding, zoom and drill to source.
-
Set the member heading properties
-
Define the text replacement labels for zero, missing and error data cells
-
Enable suppression
For more information, see General Properties.
Column Properties
Column properties affect an entire column. You must click in a column header to select the column that you want to view the properties for. Use column properties to override the default grid settings for column width, repeated headings, and suppression settings.
For more information, see Column Properties
Row Properties
Row properties affect an entire row. You must click in a row header to select the row that you want to view the properties for. Use row properties to override the default grid settings for row height, repeated headings, and suppression settings.
For more information, see Row Properties
Cell Properties
Cell properties affect the selected range of cells in a grid. Use cell properties to change the way cell text is formatted. For example, you can change the way positive and negative numbers are displayed, and you can change the font, color, and size of text within a cell. You can add borders or shading to a cell range, and specify zoom and indent options. You can also show or hide cell attachment links for selected cells in the grid that have attachments at the data source. See Formatting Grid Cells.
Sorting
You can sort values in a grid. You can add multiple sorts (for example, you can sort by columns and then by rows), and you can add multiple rows or columns to a sort (for example, sort columns by column members, and then by row 3).
For more information, see Sorting
Conditional Properties
Conditional formatting, text and suppression enables you to define formatting, text or suppress cells in a grid that meet conditions that you define. See Working with Conditional Formatting, Text, and Suppression
Drill Through
Drill through properties allow you to set up content links on grid data cells, rows, columns, and member header cells. See Working with Drill To Content.