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 menu will display an Add Datasource option.

   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

In a tablix cell, expressions can be set or edited through the Text Editor dialog.

Set expression using Text Editor Dialog

1. Select the tablix cell and click the Text Editor icon to open the Text Editor Dialog.
2. In the Text Editor Dialog, enter the desired content or expression directly.
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 Text Editor Dialog.
7. Click Save to assign [Sales] data field 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 Text Editor Dialog

1. Select the tablix cell and click the Text Editor icon to open the Text Editor Dialog.
2. The Text Editor dialog will appear, allowing you to modify the existing content or edit the 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 Text Editor dialog.
7. Click Save to assign [Sum(Sales)] data field into the respective tablix cell.