You can specify options for aligning and indenting text in selected cells. You can select options for horizontal and vertical alignment. You can also specify the number of character spaces to indent text from the margins of selected cells.
To align text in grids:
Create a grid in a report in the Report Designer, or open an existing report containing a grid.
Select Format, and then Cells to access the Format Cells dialog box.
Select the Alignment tab to specify alignment for the selected cells.
From the Horizontal drop-down list, select an alignment option. The options are Left, Center, and Right.
From the Vertical drop-down list, select an alignment option. The options are Top, Middle, and Bottom.
To indent the heading and the associated text, data, or formula cells in the row, from the Indent value box, select the number of spaces to indent the values from the left cell margin.
To indent the row headings of each generation of a selected member:
Confirm that you selected a row with the desired heading cell from the Indent Increases for Each Generation By value box.
Note:
You can specify a reverse indentation (from right to left) by using a negative number in the format property.
Select the number of spaces to indent the text. This number is added to the number in the Indent value box if it contains a value.
For Planning, select Show Supporting Detail to view detail items. Also, for all database connections including Planning, select a member relationship that returns members on multiple levels; for example: Children of ...(Inclusive), Descendants of..., Descendants of ...(Inclusive), Parents of...(Inclusive), Ancestors of, Ancestors of...(Inclusive), and AllMembers. This control is enabled only if you selected Left from the Horizontal drop-down list.
Click Apply to apply the text alignment options to the cells.
Click OK to confirm the text alignment options you specified and close the dialog box.