Aligning Text in Grids

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:

  1. Create a grid in a report in the Report Designer, or open an existing report containing a grid.

  2. Select the cells you want to format.

  3. Select Format, and then Cells to access the Format Cells dialog box.

  4. Select the Alignment tab to specify alignment for the selected cells.

    Figure 19. Alignment Tab in the Format Cells Dialog Box

    Alignment Tab in the Format Cells Dialog Box

  5. From the Horizontal drop-down list, select an alignment option. The options are Left, Center, and Right.

  6. From the Vertical drop-down list, select an alignment option. The options are Top, Middle, and Bottom.

  7. 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.

    Note:

    This control is enabled only if you selected Left from the Horizontal drop-down list.

  8. To indent the row headings of each generation of a selected member:

    1. 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.

    2. 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 example: If Indent contains a 2 and Indent Increases For Each Generation By contains a 4, the output would resemble the following example:

      ValueResult

      East Hartford (2+4+4+4=14)

      120

      West Hartford (2+4+4+4=14)

      130

      Hartford (2+4+4=10)

      250

      Springdale (2+4+4+4=14)

      140

      Glenbrook (2+4+4+4=14)

      112

      Stamford (2+4+4=10)

      252

      CT (2+4=6)

      502

      NY (2+4=6)

      406

      East (2)

      908

      Note:

      For Planning Details, you must select Show Supporting Detail to view detail items. Also, for all database connections including Planning Details, you must 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.

  9. Click Apply to apply the text alignment options to the cells.

  10. Click OK to confirm the text alignment options you specified and close the dialog box.