The initial problem was a report was cutting off some the text. I investigated and determined it was a result of the view being used. The field was using a CHAR(30), which would cut off text after 30 characters.

I decided to change it to a VARCHAR(256) just to ensure it has plenty of room. The data in the view looked great, but when I ran the report in SSRS, it looked like it was triple spaced: the data in the report was organized in a list-like format. The space between the lists was extreme. It doubled the page count of the report. I reverted to VARCHAR(64), but there’s still some string text that exceeds 64 characters.

I checked the properties on the field in the RDL. It’s set to ‘increase height,’ which I thought would take care of the formatting issue.

It doesn’t appear that there’s a lot of white space causing the issue. Frankly, I’m not sure why it was set to CHAR(30) using a CONVERT to begin with —it’s a text field, so I don’t see a need for it to be converted since it’s being displayed as text (string).

What do you suspect the issue is? The annoying thing is my initial changes worked fine in a test environment, but as soon as it went to production, it created the triple spacing.