Menu
I am wondering how the row heights in an SSRS tablix are calculated.
For instance, I have data for which the displayed and grouped by columns are close enough to be identical. However, some rows will for some unknown reason have a massive height with a lot of blank space. If you inspect the HTML output you can see that these rows have a rowspan and height applied to them.
This is not a wrapping issue as I can do an IIf on that row's item id and simply display "a" instead of the actual values and still get abnormal height. I have also disabled CanGrow on all textboxes/rows etc. and have set manual heights yet the issue persists.
What causes this behaviour and how are the row heights usually calculated?
302
To change row height by setting cell propertiesIn Design view, click a cell in the table row. In the Properties pane that displays, modify the Height property, and then click anywhere outside the Properties pane.
In Report Builder, the tablix data region is a generalized layout report item that displays paginated report data in cells that are organized into rows and columns. Report data can be detail data as it is retrieved from the data source, or aggregated detail data organized into groups that you specify.
Right-click outside of the report body and click Report Properties. In Page Setup, select a value from the Paper Size list. Each option populates the Width and Height properties.
There are a couple of possibilities as to what is going on:
113
Try setting the following properties for your rows and see if it helps.
21
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
