Positioning tables and charts in BIDS SSRS

sql-server sql-server-2008 reporting-services ssrs-2008 bids
JsonStatham picture JsonStatham · Feb 23, 2012 · Viewed 20.4k times · Source

See (image.1) - As you can see, in the design view I have my two tables on the left and two pie charts on the right, all neatly positioned.

See (image.2) - Now I preview the report, and as you can see, I am not allowed the second pie chart along side the tables, it has to go below them (but on the right) why is this? There is quite CLEARLY sufficient space available for the second pie chart.

Any answer or workaround to this would be appreciated.

enter image description here enter image description here

Answer

Ian Preston picture Ian Preston · Feb 23, 2012

SSRS makes its best guess at aligning objects in reports, but sometimes, especially when one element is fixed size and the other is variable, this doesn't always work.

The easiest way around the problem is to add a Rectangle object to the report, then move the two charts into the rectangle. Resize the rectangle to its minimum size and place appropriately. When done properly you will see that the Parent attribute will have changed from Body to the name of the Rectangle object.

Now, when rendering, SSRS will then align the charts within the rectangle, then align the rectangle against the table, and everything should match up as you expect.

Related questions

SSRS Query execution failed for dataset

Have just deployed my Project on to my reporting Server. I have multiple datasets which are referencing views which exist on the db on that server. When I try to go into any report part I am getting this message: …

Read More
"An item with the same key has already been added" Error on SSRS When Trying to Set Dataset

When i try to set the Dataset in SSRS IDE, i get the error you see in the snapshot. The query works totally fine in SQL Server Management Studio, i wonder where did i go wrong?! The connection to DB …

Read More
Comments in SSRS Report Expressions

I'm using some complicated expressions in Reporting Services to control the value, format etc of data in a report (see MSDN). Is it possible to insert code comments into these expressions, and if so, what is the syntax? By code …

Read More