SSAS developer
SSAS developer

Reputation: 33

Report elements on left getting pushed down when tablix on the right side expands

I have a report with a tablix on the right side and several textboxes arranged in rows and columns on the left. While previewing the report, the tablix gets expanded with the separate values in them and because of which some of the text boxes are also getting pushed down leaving blanks spaces and making the report look unformatted.

I have attached the report format. Please let me know if you have any solution to this issue.

report format

Upvotes: 2

Views: 3349

Answers (4)

Krin
Krin

Reputation: 21

Go to Report Properties to select columns number from 1 to 2 to see information side by side instead of going to next page.

Report Properties

1

Upvotes: 0

A Simple Programmer
A Simple Programmer

Reputation: 644

I think I know why rectangles didn't work for you. I have a similar report I am trying to create with the same format. I had the same problem you mentioned where white space appeared above my report objects, and the objects on the left still did not appear in the correct places.

What I found was that you need to create the rectangle first and then add objects into it. It appears that the above problem occurs when you try to place a rectangle on top of your report objects.

I know this is 4 years late, but I thought this might hopefully save someone some time.

Upvotes: 1

iamdave
iamdave

Reputation: 12243

You need to place your report items in rectangles to stop them interacting with each other. Put your items on the left all into the same one and the table on the right into it's own.

Upvotes: 6

JesalynOlson
JesalynOlson

Reputation: 513

Have you tried setting the Can Grow attribute to False or did you need it to expand? If so I would actually increase your Tablix size to the max it can to not push the text boxes and then set the property to Can Grow to false.

Upvotes: 0

Related Questions