sql-serversql-server-2008reporting-servicesssrs-2008bids

Positioning tables and charts in BIDS SSRS


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


Solution

  • 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.