Change row height or column width in a paginated report (Report Builder)
Applies to: Microsoft Report Builder (SSRS) Power BI Report Builder Report Designer in SQL Server Data Tools
When you set a row height, you're specifying the maximum height for the row in the rendered paginated report. However, text boxes in the row are set to grow vertically to accommodate their data at run-time by default. This setting 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 don't automatically expand.
When you set a column width, you're specifying the maximum width for the column in the rendered report. Columns don't automatically adjust horizontally to accommodate text.
If a cell in a row or column contains a rectangle or data region, the height and width of the contained item determines the minimum height and width of the cell. For more information, see Renderer behaviors (Report Builder).
Note
You can create and modify paginated report definition (.rdl) files in Microsoft Report Builder, Power BI Report Builder, and in Report Designer in SQL Server Data Tools.
Change row height by moving row handles
In Design view, choose anywhere in the tablix data region to select it. Gray row handles appear on the outside border of the tablix data region.
Hover over the row handle edge that you want to expand. A double-headed arrow appears.
Select the edge of the row and move it higher or lower to adjust the row height.
Change row height by setting cell properties
In Design view, choose a cell in the table row.
In the Properties pane that displays, modify the Height property, and then select anywhere outside the Properties pane.
Prevent a row from automatically expanding vertically
In Design view, choose anywhere in the tablix data region to select it. Gray row handles appear on the outside border of the tablix data region.
Select the row handle and choose the row.
In the Properties pane, set
CanGrow
to False.Note
If you can't see the Properties pane, from the View menu, select Properties.
Change column width
In Design view, select anywhere in the tablix data region to select it. Gray column handles appear on the outside border of the tablix data region.
Hover over the column handle edge that you want to expand. A double-headed arrow appears.
Select the edge of the column and move it left or right to adjust the column width.
Related content
Tablix data region (Report Builder)
Tablix data region cells, rows, and columns (Report Builder)
Tables (Report Builder)
Matrices (Report Builder)
Lists (Report Builder)
Tables, matrices, and lists (Report Builder)
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho