January 9, 2017 at 2:01 pm
I have system report I am trying to modify by eliminating some columns, making the report narrow enough to fit on a portrait page instead of the original landscape. The report designer created a tablix and then added rectangles to each line. Within the rectangles they added individual text boxes. I've deleted some and moved others. No single line has only one text box. All the rectangles are stuck on 10.375". I can't resize the tablix and I can resize the rectangles. I really don't want to have to create a new tablix unless I have to. This one has 4 groups and lots of properties so I'm sure I will miss something if I have to go that route. Any ideas?
John
SQL Rebel without a Where Clause
SQL/Epicor/Prophet21/VISUAL/e.i.e.i.o.
January 10, 2017 at 4:08 am
Unfortunately, if you have objects inside an object (and then in your case, another object inside that object), then you have to shrink each object before shrinking it parent.
SSRS won't be "clever" and scale any objects inside a object which is being shrunk. In your case, having a textbox inside a rectangle, inside a tablix means you would have to:
1. Shrink the textboxes
2. Shrink the Rectangles
3. Shrink the Tablix
If it's a complex report, or have a lot of object, it's not going to be quick, sorry.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 10, 2017 at 8:00 am
I found it! One stupid line that was almost hidden in a rectangle.
John
SQL Rebel without a Where Clause
SQL/Epicor/Prophet21/VISUAL/e.i.e.i.o.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply