I'm using the dynamic height property in a horizontal bar chart successfully, but as the chart grows, the legend and the visual element of the chart itself is shifting downwards: With only a few rows, note that the legend and chart are at the top of the window But as chart grows using DynamicHeight, legend and chart are now spaced out:

Hi There Thanks for your posting. Can you please try to put your chart inside List control and see if it make any diffence. so please do the following 1.Drag a List control to the Design surface. Click the list, right-click on the row handle of the list to open the Tablix Properties pane. Set the DataSet Name to the same dataset as the chart. 2.Click the list, open the Group Properties dialog from the Grouping pane. Click Add, and select [group field in the drop-down list. 3.Drag the chart to the list. If you have any questions please do ask Many Thanks Syed Qazafi Anjum

When I placed the chart in the list control (and set the options as you specified) i still get the issue of the legend and chart moving around and now each course (like CS5=643, CS597-1 in the original image) is on its own page (so i only get one course barchart per page) It seems like there must be a way to specify the absolute top and left of the legend and the absolute top and left of the chart...

Hi There Thanks for your posting. would that not be possibility to put the legend not on top but on the side somewhere Please place the chart control into a table/tablix. I added an empty table, deleted the details row and the two extra columns, and added my chart that was giving me problems. Everything appears to re-size correctly now. For more info http://stackoverflow.com/questions/3578829/reporting-services-2008-chart-dynamicheight-property-creates-extra-space Many thanks Syed qazafi Anjum

Hi Syed - thanks for responding. I created a new table, deleted the row group and the header row as well as the two extra columns, then set the tablix properties to use DataSet1 (the chart dataset) and added the chart to the cell. Then set the legend to appear on the right hand side instead of above. Unfortunately still getting the same behavior:

Hi Syed - unfortunately the behavior is the same even with CanGrow set to false, the entire area stretches and the chart visual area shifts downwards almost as if its trying to center itself in the newly expanded space...

Just to make sure I don't have another setting causing an issue, created a brand new blank report that just queries sys.objects and returns TOP n rows, with DynamicHeight set to =(1 + COUNTROWS("DataSet1")) & " in") Really disappointing - our managers have been eyeing OBIEE for some time now, and while I've been pusing to retain SSRS it is increasingly difficult given issues like this one, given that this is such an obvious bug. Really hoping someone can assist....

Bump - hoping that someone from MS can acknowledge this as another known issue with SSRS - the test case I provided above (using sys.objects) is very easy to reproduce.

Hi, This worked in my case. Placed the chart inside the rectangle before placing inside the list.Shine

Anyone found a solution to this? Is there a Microsoft Connect Bug for this one? I've tried adding the chart to retangle and tablix and neither is prevent the centering action.

Microsoft Connect submission: http://connect.microsoft.com/SQLServer/feedback/details/769305/ssrs-chart-dynamicheight-dynamicwidth-and-whitespace-management