CODEWITHSUNDEEP
sqlreporting-services
Rob
Rob

Reputation: 135

SSRS dashboard layout : set up height of all graphs the same

enter image description hereI am trying to build SSRS dashboard. In first tablix I have two tables. And rest 3 have graphs. I would like to set up height of all to same. I am having trouble with fist two tables. And getting extra spaces between all.

For first two tables I used rectangle and also rest three. But still getting extra space after first two tables and before graph number 3.

Upvotes: 0

Views: 187

Answers (2)

Andy Goode
Andy Goode

Reputation: 11

I've created multiple dashboards over the years using SSRS and I've found the best way to do this is to literally restrict the table data to a set number of records so you can gauge the height of the full tablix and adjust the charts accordingly. I did try using dynamic lengths based on records returned but it wasn't viable.

A good idea is to also place objects within rectangles when creating dashboards, its handy if you have more than one row of visuals and you want the next row to all be lined up.

Upvotes: 1

Strawberryshrub
Strawberryshrub

Reputation: 3389

This happens because SSRS doesnt know the height of the tables. This depends on the rows. You can either put the tables on the bottom and on top the charts or you add a page break after the first 3 visuals.

Upvotes: 1

Related Questions