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 data from data assign menu
Select any cell in the tablix data region. Click on the Data assign menu icon to open data assign menu. If the report has no dataset, then 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.
By default, the menu displays the fields of the first dataset in the report.
The available datasets in the report will be listed in the first dropdown. To assign different dataset, choose desired dataset in the dropdown.
Now, the fields of selected dataset will be listed in the data assign menu like below.
Assign data from properties panel
Select the tablix report item in design area, now the respective tablix properties will be listed in the properties panel.
The available datasets in the report will be listed in the Dataset property dropdown. You can choose the desired dataset from the drop-down.
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.
Go to the textbox’s properties and assign field in Content property.
Drag and drop data fields
Open the DATA panel and expand the required dataset.
Drag a field from the list and drop into a required cell.
Assign fields using data assign menu
Select the tablix cell and click on the Data assign menu icon to open data assign menu.
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.
Now, the respective field will be assigned to the respective cell like below.
Textbox properties
Select a cell in the tablix, now the respective textbox properties will be listed in the properties panel.
In the Content property, type the value or set the data field using the expression editor.
Refer Set expression section to open expression menu and to set expression.
Here, the =Fields!Sales.Value expression is entered in the content property field to assign Sales data field into the respective cell.
Now, the Sales field will be denoted in 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 in Content property of a cell in properties panel
Set expression using data assign menu
Select a table cell and click on the Data assign menu icon to open data assign menu.
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.
You can specify dataset fields, parameters or any other built-in functions and click on the OK button.
The label denoted in the table cell varies based on the assigned values in table cell. The following snap depicts the label text variations.
Set expression in properties panel
Select a cell in the tablix, now the respective textbox properties will be listed in the properties panel.
Click on the square icon in the right corner of the Content property.
Click on the Expression option in the menu. Now, the Expression builder will be launched like below.
You can specify dataset fields, parameters or any other built-in functions and click on the OK button.
The label denoted in the table cell varies based on the assigned values in table cell. The following snap depicts the label text variation.
Edit expression using data assign menu
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.
Click the Edit Expression option in the data assign menu. Now, the Expression builder will be launched like below.
Modify the expression as required and click on the OK button.
Edit expression in properties panel
Select a table cell, now the respective textbox properties will be listed in the properties panel.
Click on the square icon in the right corner of the Content property.
Click on the Expression option in the menu. Now, the Expression builder will be launched like below.
Modify the expression as required and click on the OK button. Now, the expression will be updated for respective cell.