Change Row Height or Column Width

Change Row Height or Column Width (Report Builder and SSRS)

 

Applies To: SQL Server 2016

When you set a row height, you are specifying the maximum height for the row in the rendered report. However, by default, text boxes in the row are set to grow vertically to accommodate their data at run-time, and this can cause a row to expand beyond the height that you specify. To set a fixed row height, you must change the text box properties so they do not automatically expand.

When you set a column width, you are specifying the maximum width for the column in the rendered report. Columns do not automatically adjust horizontally to accommodate text.

If a cell in a row or column contains a rectangle or data region, the minimum height and width of the cell is determined by the height and width of the contained item. For more information, see Rendering Behaviors (Report Builder and SSRS).

System_CAPS_ICON_note.jpg Note


You can create and modify paginated report definition (.rdl) files in Report Builder and in Report Designer in SQL Server Data Tools. Each authoring environment provides different ways to create, open, and save reports and related items.

To change row height by moving row handles

  1. In Design view, click anywhere in the tablix data region to select it. Gray row handles appear on the outside border of the tablix data region.

  2. Hover over the row handle edge that you want to expand. A double-headed arrow appears.

  3. Click to grab the edge of the row and move it higher or lower to adjust the row height.

To change row height by setting cell properties

  1. In Design view, click a cell in the table row.

    Selected Cell in a Table

  2. In the Properties pane that displays, modify the Height property, and then click anywhere outside the Properties pane.

    Properties Pane for selected table cell

To prevent a row from automatically expanding vertically

  1. In Design view, click anywhere in the tablix data region to select it. Gray row handles appear on the outside border of the tablix data region.

  2. Click the row handle to select the row.

  3. In the Properties pane, set CanGrow to False.

    System_CAPS_ICON_note.jpg Note


    If you cannot see the Properties pane, from the View menu, click Properties.

To change column width

  1. In Design view, click anywhere in the tablix data region to select it. Gray column handles appear on the outside border of the tablix data region.

  2. Hover over the column handle edge that you want to expand. A double-headed arrow appears.

  3. Click to grab the edge of the column and move it left or right to adjust the column width.

Tablix Data Region (Report Builder and SSRS)
Tablix Data Region Cells, Rows, and Columns (Report Builder) and SSRS
Tables (Report Builder and SSRS)
Matrices (Report Builder and SSRS)
Lists (Report Builder and SSRS)
Tables, Matrices, and Lists (Report Builder and SSRS)

Community Additions

ADD
Show:
© 2016 Microsoft