Find and Replace

To find and replace data, use the Find and Replace dialog box. If one cell is selected, data search and replacement involves the entire table. If a cell range is selected, data is searched and replaced only in the selected cell range.

In the desktop application:

In regular reports. Select the Find item in the drop-down menu of the Find and Replace button on the Home ribbon tab.
In express reports. Click the Find and Replace button on the Table ribbon tab.
In dashboards. Click the Find button on the Table ribbon tab.
Press CTRL + F to find data.
Press CTRL + H to replace data.

In the web application:

In regular reports. Click the Find button on the Home ribbon tab.
In express reports and dashboards. Click the Find button on the Table: Designer ribbon tab.

NOTE. Data replacement is available only in the desktop application.

Finding Data

NOTE. Default search is executed in the entire report by rows, without accounting the format of searched cells and other parameters. Search is executed by value in the table cells.

NOTE. Formatting can be set up only in the desktop application.

To select the format of searched value, click the Format button. The menu with the following items opens:

Set Format. The Cell Format dialog box opens where the format of the searched value should be set. The specified format is displayed in the Sample box. If the format is not set, the box displays the "No Format Set" text.
Choose Format from Cell. It hides the Find and Replace dialog box. After the report cell is selected, the dialog box is displayed again, the Sample box displays format of the selected cell.
Clear Find Format. It resets the selected format. The Sample box displays the "No Format Set" text.

To take the character case into account in the searched text, select the Match Case checkbox.

To find only the cells, which contain the whole value, entered in the search field, select the Whole Cell checkbox.

NOTE. Search scope can be selected only in the desktop application.

To select search scope, use the Search Scope drop-down list that contains the following values:

In report.
On sheet. This search scope is available only in regular report.

To select search area, use the Search Order drop-down list containing the following values:

By Rows.
By Columns.

To select search object, use the checkboxes:

Value. Search is executed by cell values.
Text. Search is executed by text displayed in cells. The displayed text may differ from cell value due to data format settings. For example, a cell may contain the 2.5879 value and display the 2.59 text.
Formula. Search is executed by formulas, by which cell values are calculated.
Metadata. Search is executed by table cell metadata. Calculated elements are searched by their formula.
Metadata includes data source name and names of the dimension elements corresponding to this cell. In regular reports, selected cell metadata is displayed at the end of formula bar.

NOTE. The Formula and the Metadata checkboxes are available only in the desktop application.