Replacing Text

When working with cells in a grid, you can replace values in a cell with different text. This replaces all text in all selected cells with the replacement text you specify. You can also specify to include related content links that will display if certain conditions are met.

  To replace a value in a grid selection:

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

    Figure 22. Replace Tab in the Format Cells Dialog Box

    Replace Tab in the Format Cells Dialog Box

  5. Select the Replace value with check box to enable the text box, then enter the replacement text in the text box.

    Note:

    If the check box is selected and no text is entered in the text box, the selected cells are displayed as blank in the report.

  6. Select Add Related Content to specify related content links. The related content links will display when certain conditions are met. For conditional formatting, see Applying Conditional Formatting on Grids.

  7. Click Setup to Add Related Content dialog where you can select the related content links. See Modifying the Properties for Related Content

  8. Click Apply to apply the text replacement to your selected cells.

  9. Click OK to confirm the replacement of the specified text string.