3

I am using SSRS 2016 to make a report.

I use MIDDLE for the Vertical Alignment so the text is in the middle of the box.

enter image description here

It changes to look correct in Design View but when I view it in Report Viewer, it looks like it's set to TOP.

More bizarrely, when it exports to Excel or PDF, it works fine. There are no extra spaces or Return characters - just static text.

enter image description here

Is there any way to get this working as it did in SSRS 2012? It used to work fine.

I have tried it in both Visual Studio and Report Builder with the same crappy results. Unfortunately, this report will mostly be viewed on-screen.

R. Richards
  • 24,603
  • 10
  • 64
  • 64
Hannover Fist
  • 10,393
  • 1
  • 18
  • 39
  • Does the Report Manager result vary from one browser (IE, Chrome, Edge. etc.) to another? – R. Richards Mar 04 '17 at 15:14
  • Have you checked to see if some css isn't affecting the alignment? – Snowlockk Mar 06 '17 at 13:00
  • It is possible that it is still trying to word wrap. Test it with a smaller font size and see if it still does that. If that is the case, you may need to increase the text box width just a bit. – Wes H Mar 06 '17 at 14:11
  • @R.Richards - it is working correctly with Chrome. I hadn't tried it before because Chrome usually doesn't display SSRS reports at all. – Hannover Fist Mar 06 '17 at 16:45
  • @WesH - It doesn't seem to be a Word Wrap issue - even **OCR** with the same size textbox is pushed to the top in IE (but apparently not Chrome). – Hannover Fist Mar 06 '17 at 16:49

2 Answers2

4

To fix this, within Text Box Properties - General, remove the checkbox for Sizing options - Allow height to increase. It works, but don't ask me why.

BruceW
  • 41
  • 2
  • 1
    Thanks, worked, but only on the second change. The setting in Report Builder 2016 is called CanGrow (at least for me) – AndyZ May 04 '18 at 08:15
1

Additionally, if your text has trailing spaces, it might be forcing it to the top of the field. Add a RTRIM to your column to remove the trailing spaces and see if that helps with alignment.

Jody Wood
  • 11
  • 1