Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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 hereenter image description here

like image 458
JsonStatham Avatar asked Feb 23 '12 11:02

JsonStatham


1 Answers

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.

like image 187
Ian Preston Avatar answered Oct 14 '22 11:10

Ian Preston