Add the report table

Add the table (Tablix)

1. Drag and drop the table widget to the main section of the report.
   Make sure to select outside of the element to clear the selection and then select it again to view all the Table widget properties.
2. Enter the table Name.

   The table name must not include spaces.

3. In the Data section, select the appropriate Dataset from the dropdown.

Add fields to the second row of the table

1. Hover over the first cell on the table's second row and select the list icon () to view the dataset's fields.
2. Click the icon in the cell to view the dataset's fields.
3. Optionally, use the Search field to filter the fields.
4. Select the appropriate field.
5. Optionally, to add or delete columns, select the appropriate cell, right-click, and select Insert or Delete Column as needed.
6. Repeat the steps above for each cell on the table's second row.

Add expression fields

1. Select the appropriate cell on the table's second row.
2. In the properties, select the square icon () next to the Content field and select Expression.
3. Select Fields from the Data dropdown to view the dataset's fields list.
4. Optionally, double-click the appropriate field to add it to the expression.

   You can also manually enter the appropriate expression in the Set Expression for : Content field.

5. Select OK.

Add column headings to the table's first row

1. Select the appropriate cell on the table's first row.
2. In the properties, enter the column name in the Content field and update the styling as needed.

   For example, set the Background Color to black and the Font color to white.

3. Repeat the above steps for the remaining cells as needed.

Specify the text alignment

You can align text within column headings or fields, such as left, center, or right, depending on your layout needs. This is especially useful for currency fields.

1. Select the appropriate cell.
2. In the Alignment section of the properties, select the Text Alignment from the dropdown.

Adjust the column width

1. To select the entire column, select just above the first row of the table.
2. In the Position section of the properties, set the Width to the appropriate value.

Set up table sorting

1. Select the top-left corner of the table to ensure the entire table is selected.
2. In the properties, go to the Data section and select SET SORTS...
3. In the Sorting dialog, select + ADD, then select the field you want to sort by and the sorting order.
4. Repeat step 3 for each additional field you want to sort by.
5. Select OK.

Adjust the table's final position and width

While you can set the table’s position and width when it’s first added to the report, you can also adjust these settings later.

1. Select the left top corner of the table.
2. In the properties, adjust the Position and Size as needed.

Specify the final position of the header and the footer

After adjusting column widths, the elements added to the header and footer section might need to be repositioned.

1. Select the appropriate element in the header or footer.
2. In the properties, adjust the Position and Size as needed.