SSRS SharePoint Integrated Mode – Cells grow vertically to fit content

I have come across this issue several times that even the “Can Grow” property  of the cell is set to false, the cell grows vertically to fit contents forcing the same row to stretch to the height of the cell distorting the rendering of the report on the browser though it might display correctly in Report Builder or SQL data tools in Visual Studio.

Can Grow is set to False from the cell property.

CanGrow_False

Cell displayed correctly Report Builder

DisplayCorrectly_ReportBuilder

Report does not display correctly from report library in SharePoint 2013

DisplayIncorrectly_Browser

Fix

  1. Clear the cell, i.e. delete the textbox and right click on the cell to add a rectangle.

Insert_Rectangle

2. After adding the rectangle control, right click to add a textbox

Insert_TextBox

3. Select the field to display in the textbox and set writingmode to 270.

TextBoxInsideRectangleSetTo270

4. Save the report from Report Builder and run the report from browser.

fixed_Resize

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s