Working with Table Data

View mode provides the following operations with table data:

Sorting and Filtering

Table range sorting enables the user to quickly sort selected range of regular report sheet. It is available in the desktop application.

TIP. Do not apply sheet range sorting to table cells. Use native sorting options of table visualizer, data area, relational data area.

To sort values in the selected sheet range:

Click the / button in the Sorting and Filtering group on the Data ribbon tab or select the Sort Ascending/Sort Descending item of the Sorting and Filtering button drop-down menu on the Home ribbon tab.
If the selected range has adjacent data, it is prompted to expand the selected range:

To sort:

All Found Data. Select the Expand the Selection checkbox
Selected Range Data. Select the Continue with the Current Selection checkbox.

Click the Sort button.

The selected range values are sorted by the first column. The minimum (ascending sorting) and the maximum (descending sorting) value will be highlighted in bold.

Example or sorting

Filtering is a method of finding a data subset and working with this data in the list. A filtered list shows only the rows that meet the conditions set for the given column. The rows that do not meet the filter condition, are hidden. It is available in the desktop application.

The regular report contains several types of filtering:

Table visualizer filtering
Data area filtering
Sheet range autofilter.

Searching and Replacing

The report sheet provides a possibility to find and replace data and/or text.

Find

To find text on the report sheet:

Select the Find and Replace > Find item in the Filtering and Searching group on the Home ribbon tab.
Press CTRL + F.

The dialog box view depends on the sheet type used for the report:

The Find and Replace dialog box opens for table sheet.
The Search dialog box opens for text sheet.

In the Find box enter the search text or select the search text used before in the drop-down list. If required, set the Match Case parameters to match character case and Match Whole Word to search text that exactly matches the text from the field. Select search direction by selecting the appropriate checkbox in the Direction group.

Find and Replace

To search and replace:

Select the Replace item in the drop-down menu of the Find and Replace button on the Home ribbon tab.
Press CTRL + H.

The dialog box view depends on the sheet type used for the report:

The Find and Replace dialog box opens for table sheet.
The Replace dialog box opens for text sheet:

In the Find What box enter the search text, in the Replace With box enter the text that will replace the searched text. It is available to select text in the drop-down lists. If required, set the Match Case parameters to match character case and Match Whole Word to search text that exactly matches the text from the field. Select search direction by selecting the appropriate checkbox in the Direction group.

Editing and Saving

To edit cell contents:

Select a cell in the report sheet and enter required data
Double click in the selected cell area
Select a cell and press F2, after this enter the data.

NOTE. Data editing in cells when the Do Not Calculate Report on Open checkbox is selected is available after report update.

To introduce changes to the report, save changes by clicking the Save Changes button. To undo changes, click the Undo Changes button on the Home ribbon tab.

NOTE. The Save Changes and Undo Changes buttons are available if any data has been entered or modified in table cells.