Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Allow a Text Box to Grow or Shrink (Report Builder and SSRS)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

By default, text boxes are a fixed size. You can set options that let the text box expand or shrink based on its contents. These options correspond to the CanGrow or CanShrink properties in the Properties pane.

Note Note

You can create and modify report definitions (.rdl) 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. For more information, see Designing Reports in Report Designer and Report Builder (SSRS) on the Web at microsoft.com.

To Allow a Text Box to Grow or Shrink

  1. Right-click the text box and click Text Box Properties.

  2. Click the General tab.

    • To allow the text box to expand vertically based on its contents, select Allow height to increase.

    • To allow the text box to shrink based on its contents, select Allow height to decrease.

Community Additions

ADD
Show:
© 2015 Microsoft