Design ssrs rdl report using table with multi textrun

The following steps guides you to design ssrs rdl report using table with multi textrun.

Add a table to the report using Tablix Wizard

1. Refer to the Create a Matrix Report using Tablix Wizard section and assign the ProdCat, SubCat, OrderYear, OrderQtr and Sales fields in the initial matrix design.
2. Remove any unnecessary rows and apply styles to the Tablix item and its cells to improve visual clarity.

Set header text for Tablix data

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, allowing you to enter and format the content.

3. Enter the required header text in the Multi-Text Run Editor dialog.

4. Apply styling to the header text using the selected text properties available in theProperty Panel.

   a. Select all the text and set the Text Alignment to Center. b. Highlight the header portion and set Font Weight to Bold. c. Select the descriptive part of the heading and set Font Style to Italic.

5. After applying the desired properties to the header text, click Save to apply the changes to the tablix cell.

6. Repeat the same steps to format the header text for both the Product Sub Category and Order Year cells consistently.

Add Expression in Tablix Cell

To add the [Sales] expression into a selected Tablix cell, follow the steps outlined in the Set expression using Multi-Text Run Editor Dialog section.

Edit Expression in Tablix Cell

To update a Tablix cell with the [Sum(Sales)] expression, follow the steps outlined in the Edit expression using Multi-Text Run Editor Dialog section.

Report preview

On report preview, the product sales report of a company will be displayed like below,

Download the above report design from the link.