Trying to figure out how to make the Can grow / Can shrink properties actually DO their intended actions.
We have a custom version of the quote form that has the line description field inside Rectangle17. Same location as on the SSRS default version. So the value of txtLineDesc’s Parent property is Rectangle17.
Our line descriptions vary from 1 to 3 lines. We would like the space this field occupies to be as big as necessary, but no bigger. We have tried making the field size bigger and setting the Can Shrink property to TRUE; we have tried making the field size smaller and setting the Can Grow property to TRUE. Neither seems to work.
Is there something we are missing? I did not see Can Grow or Can Shrink properties on Rectangle17; is there some thing else that would affect the field properties?
From my experience, the CanShrink doesn’t do anything.
As far as CanGrow, make sure each parent element is also set. In your example, there’s the textbox, the rectangle it is in, and the tablix row containing the rectangle.
CanShrink does not work with RDLC when the textbox is within a data control like Table / Matrix
But when you place the textbox within a data control like TABLE / MATRIX, the CanShrink property is never honored. At the same time the CanGrow property will always work as expected.
Could not find a Can Grow property on either Rectangle17 or Tablix1 (parent of Rectangle17).
Also could not find a way to isolate just that row of the tablix.
And… looked for (but could not find) a “wrap text” property, so that data would flow to the next line.
The right-click Properties menu options seem to be tied to the ones in View | Properties pane, so the checking the “Allow height to increase” checkbox sets the “Can Grow” property to TRUE.
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.
What you are describing is what I expected to see (and exactly what I want to happen), but it’s not happening. So I am trying to figure out what else might be constraining the size of the textbox.
The textbox is in the rectangle and the textbox’s Can Grow property is set to TRUE.
Correction. That property doesn’t really pertain to the row, but as a way to set all the objects in that row. Setting the Row’s CanGrow to FALSE, sets all the cell’s CanGrow property (in that row) to FALSE.
Haven’t tested what a texbox in a rectangle in a tablix cell does …
One more thing to be aware of… Overlapping Textboxes are a bad idea. When the report is rendered, it may try to shove them around to maintain what it thinks are lines made up of multiple textboxes within a rectangle
Thanks. When click in the left margin (or whatever is selected in your image), I get Rectangle 17, not the row of the tablix. The rectangle has a non-editable Location property of 0,0, so I don’t know how to get around it to the underlying tablix.
“Can grow” on all the fields in the rectangle would be fine. The description would be the only thing to have enough content to grow.
Did adjust the field slightly so there is no overlap, but still no multi-line description:
OK, I am an idiot. The version I was updating was not the one that was being pulled into Epicor. I tested the export, just to ensure that what I thought I was loading was correct. And… the dates didn’t match when I exported back down. Epcior was looking in a different folder.
Can grow does work as it’s supposed to. And I have some directory clean-up to do… Sigh.
FWIW - When testing changes to SSRS reports I’ll often change the background color of the row I’m working on (like make it cyan), just to be sure its the one I think it is. If you had done that, then you would have realized that the changes weren’t to the one you were previewing.
