What to do when Microsoft SQL Server Reporting Services text boxes refuse to get into line
Posted Wednesday, September 2nd, 2009
Have you ever had to deal with recalcitrant text boxes in the Visual Studio SSRS development environment? You’ve sized them to grid, you’ve aligned them to grid, you’ve manually entered height and width dimensions, but nothing works: when you click the Preview tab, one text box extends just a couple of pixels past the other. You check the font size of the text in the box: no problem there, it fits in tidily.
The issue may be caused by internal padding in the text box. Right click a text box and select Properties. The following dialog box will pop up:
Now click the Format tab:
Check the amount of internal padding (“Amount of space to leave on each side of report item.”) The Top and Bottom padding, combined with the size of the text, might be just enough to push your text box out of kilter. Reduce the number of pixels around the text appropriately and your text box will be able to behave exactly the way you want it to:
Note that it is also possible to adjust multiple text boxes by displaying the standard Visual Studio properties box using the F4 key, and then changing the Padding property’s values:
However, there are some conditions that need to be met before the Padding values can be changed for more than one text box at a time using the standard VS properties box—in certain situations VS will not allow you to change the Padding for more than one text box at a time.
Gerhard Venter
Senior Consultant
I.B.I.S., Inc.
Posted in Dynamics GP, Reporting
Not yet using Dynamics GP? I.B.I.S., Inc. gives you the Dynamics GP options you want, and the business results you need.
Learn more about our Dynamics GP solutions
[...] in GP related SSRS work for the past several months has a new post up at DynamicsCare looking at taming savage text boxes. Definitely worth a read if you do any SSRS work. Published: Thursday, September 03, 2009, 12:00 [...]
[...] GP readers working on SSRS specifically. Here is the feast for you guys. Gerhard Venter’s What to do when Microsoft SQL Server Reporting Services text boxes refuse to get into line. Next comes the Rose Business Solutions Blog, multiple authors writing interesting stuff on [...]