SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Resize Tablix that contains rectangles


Resize Tablix that contains rectangles

Author
Message
TexasJohn
TexasJohn
SSC Eights!
SSC Eights! (950 reputation)SSC Eights! (950 reputation)SSC Eights! (950 reputation)SSC Eights! (950 reputation)SSC Eights! (950 reputation)SSC Eights! (950 reputation)SSC Eights! (950 reputation)SSC Eights! (950 reputation)

Group: General Forum Members
Points: 950 Visits: 88
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/e.i.e.i.o.
Thom A
Thom A
SSC Guru
SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)

Group: General Forum Members
Points: 53457 Visits: 16666
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 :-P

Please always remember to encapsulate your code in IFCode Markup. For example [code=sql] [/code].
Click here to read Jeffs Guide on how to post SQL questions, and get swift and helpful answers from the community
TexasJohn
TexasJohn
SSC Eights!
SSC Eights! (950 reputation)SSC Eights! (950 reputation)SSC Eights! (950 reputation)SSC Eights! (950 reputation)SSC Eights! (950 reputation)SSC Eights! (950 reputation)SSC Eights! (950 reputation)SSC Eights! (950 reputation)

Group: General Forum Members
Points: 950 Visits: 88
I found it! One stupid line that was almost hidden in a rectangle.

John
SQL Rebel without a Where Clause
SQL/Epicor/Prophet21/e.i.e.i.o.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search