Design an SSRS RDL table report with multi text run in Bold Reports®

To combine static text and expressions in a single tablix cell, design an SSRS RDL table report with multi textrun in the Bold Reports® Web Report Designer. You add a table with the Tablix Wizard, set styled header text, and add and edit expressions.

How do I add a table using the Tablix Wizard?

You add the table in the Bold Reports® Web Report Designer with the Tablix Wizard and then style it.

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

How do I set header text for tablix data?

You set styled header text in a tablix cell with the Multi-Text Run Editor dialog of the Bold Reports® Web Report Designer.

  1. Select the tablix cell and click the Text Editor icon to open the Multi-Text Run Editor Dialog. Tablix

  2. Review the Multi-Text Run Editor dialog that opens, which lets you enter and format the content. Multi-Text Run editor dialog

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

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

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

  5. Click Save after applying the desired properties to the header text, to apply the changes to the tablix cell. Multi text run Tablix

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

How do I add an expression in a tablix cell?

You add the [Sales] expression into a selected tablix cell in the Bold Reports® Web Report Designer by following the steps in the Set expression using Multi-Text Run Editor Dialog section. Multi text run Tablix

How do I edit an expression in a tablix cell?

You update a tablix cell with the [Sum(Sales)] expression in the Bold Reports® Web Report Designer by following the steps in the Edit expression using Multi-Text Run Editor Dialog section. Multi text run Tablix

What does the report preview show?

The Bold Reports® report preview displays the product sales report of a company, as shown in the following image.

Multi text run report

Download the table with multi text run report design (RDL).

Frequently asked questions

Can I style part of the text in one cell differently?

Yes. In the Multi-Text Run Editor dialog, you can set Font Weight to Bold on the header portion and Font Style to Italic on the descriptive part.

How do I open the Multi-Text Run Editor dialog?

Select the tablix cell and click the Text Editor icon.

See also