Resize Tablix that contains rectangles

  • TexasJohn

    Default port

    Points: 1476

    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

    SSC Guru

    Points: 98326

    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.

  • TexasJohn

    Default port

    Points: 1476

    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.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply