Assign data to tablix data region

The table, matrix and list report items can display data from a single dataset. You can also assign conditional expressions to filter or sort the dataset columns.

Assign dataset

There are two ways to assign the dataset to the tablix:

• Assign dataset from data assign menu
• Assign dataset in Dataset property of tablix

Assign dataset from data assign menu

1. Select any cell in the tablix data region, then click the Data Assign menu icon to open the data assign menu. If the report does not have a dataset, the data assign menu will have following options.

   Click on the Add Datasource option in the menu and add dataset using the steps provided in Create Data section.

2. By default, the menu displays the fields of the first dataset in the report.

3. The available datasets in the report will be listed in the first dropdown. To assign different dataset, choose desired dataset in the dropdown.

4. Now, the fields of selected dataset will be listed in the data assign menu like below.

Assign dataset from properties panel

1. Select the tablix report item in design area, now the respective tablix properties will be listed in the properties panel.
2. The available datasets in the report will be listed in the Dataset property dropdown. You can choose the desired dataset from the drop-down.
3. Now, the fields of selected dataset will be listed in the data assign menu like below.

Assign fields to tablix cell

There are a few different ways to assign the fields into a tablix cell:

• Drag and drop data fields from the DATA panel.
• Select the field from the data assign menu provided in each cell.

Drag and drop data fields

1. Open the DATA panel and expand the required dataset.
2. Drag a field from the list and drop into a required cell.

Assign fields using data assign menu

1. Select the tablix cell and click on the Data assign menu icon to open data assign menu.

2. Click on the required data field name in the menu.

   The fields of the dataset which is assigned to Dataset property of tablix will be listed in the menu.

3. Now, the respective field will be assigned to the respective cell like below.

Assign or edit expression into table cell

There are two ways to assign or edit the expression into a tablix cell:

• Set expression using the Add Expression and edit expression using the Edit Expression option in data assign menu
• Set or edit expression using Multi-Text Run Editor Dialog

Set expression using data assign menu

The Data Assign Menu is recommended for quickly assigning a single TextRun expression to a tablix cell. It offers a direct path to the Expression Editor.

1. Select a table cell and click on the Data assign menu icon to open data assign menu.

2. Click the Add Expression option in the data assign menu. Now, the Expression builder will be launched like below.

   To learn more about handling expressions in report designer refer Expressions section.

3. Set the Expression in the Expression editor.

4. Click OK to assign added expression into the respective tablix cell.

Set expression using Multi-Text Run Editor Dialog

The Multi‑Text Run Editor Dialog is ideal when you need to manage multiple TextRuns within the same tablix cell. It allows you to combine static text and expressions, giving flexibility for complex formatting or mixed content scenarios.

1. Select the tablix cell and click the Text Editor icon to open the Multi-Text Run Editor Dialog.
2. The Multi-Text Run Editor Dialog will open as shown below, allowing you to add an expression.
3. Right-click within the editor area to open the context menu.
4. From the context menu, click the Expression option to open the Expression Editor.
5. Set the Expression in the Expression editor and click OK.
6. The [Sales] expression will now appear in the Multi-Text Run Editor Dialog.
7. Click Save to assign added expression into the respective tablix cell.

You can specify dataset fields, parameters, or built-in functions in the Expression Editor, then click OK. The label denoted in the table cell varies based on the assigned values in table cell. The following snap depicts the label text variations.

Edit expression using data assign menu

1. Select a table cell in which you need to edit the expression and click on the Data assign menu icon to open data assign menu.
2. Click the Edit Expression option in the data assign menu. Now, the Expression builder will be launched like below.
3. Modify the expression as required and click on the OK button.

Edit expression using Multi-Text Run Editor Dialog

1. Select the tablix cell and click the Text Editor icon to open the Multi-Text Run Editor Dialog.
2. The Multi-Text Run Editor dialog will appear, allowing you to modify the existing Expression.
3. Right-click within the expression context to edit the Expression.
4. From the context menu, click Expression option to open the Expression Editor.
5. Update the Expression in the Expression editor and click OK.
6. The [Sum(Sales)] expression is updated to the Multi-Text Run Editor dialog.
7. Click Save to assign modified expression into the respective tablix cell.

Tablix Cell Editors

Each tablix cell provides flexible editing options to manage text and expressions. These options simplify report design with quick access to text entry or expression assignment.

1. Text Editor icon: Opens the Multi-Text Run Editor dialog.
2. Data Assign Menu icon: Opens a menu with options to add text or expression.

Text Editor Icon

1. Opens the Multi-Text Run Editor dialog to enter static text or expressions.
2. Right-click inside the editor to open the context menu, then select Expression to launch the Expression Editor.
3. Supports adding single TextRun or multiple TextRuns.

Data Assign Menu Icon

The Data Assign Menu provides two options:

1. Add Text: Opens the Multi-TextRun Editor dialog to enter static text or expressions.
2. Add Expression: Opens the Expression Editor directly. This option allows adding only a single TextRun, enabling faster report creation.

Below options shown in the Data Assign Menu depend on the current state of the tablix cell:

Double-Click Actions in Tablix Cells

Double-clicking a tablix cell provides a shortcut to open the appropriate editor: