Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

In SSRS, can you set a rectangle to grow with its contents?

I'm working on a report in SSRS (SQL Server Reporting Services) right now, and I'm having a problem getting a rectanlge I draw on the page in the report designer to grow. Basically, I've got a rectangle drawn, and then I put a text field inside of it. The contents of this text field can be either very short or very long, so I want it to grow to accomodate its contents.

But when I enter the long text, the textbox grows and then sticks outside of the lines of the rectangle. From the SSRS documentation I read, it says rectangles should grow to contain the items within them, and that those items are "peers".

What gives?

like image 241
Sam Schutte Avatar asked Oct 30 '25 02:10

Sam Schutte


2 Answers

The only way I can get a textbox to breach the border of a rectangle is if the textbox is not actually inside the rectangle, but instead is underneath it.

When the textbox is inside the rectangle, and when the textbox property CanGrow = TRUE then the textbox and its rectangle both grow vertically downward to accommodate large amounts of text.

like image 69
Erick B Avatar answered Nov 02 '25 00:11

Erick B


I was seeing the same issue. My problem was that I had the text boxes first and then put the rectangle around it and sent it to the back. Once I dragged the text boxes off and then back onto the rectangle, it grew properly.

like image 37
epotter Avatar answered Nov 02 '25 00:11

epotter



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!