I’m afraid I already know the answer, but is it possible to tighten up the spacing between rows? No matter what I do with row height or cell padding, it doesn’t seem to matter, this is as tight as the rows will go. I’d like to remove white space where the red lines are as I’m working with a small label and I’m running out of real estate.
Also, I can’t seem to find a way to bold the word supplier in this expression:
="Supplier: " & Fields!VendName.Value
I’ve found things online mentioning place holder work arounds, but I can’t get that to work.
Right on. Sort of tucked away setting that requires weird highlighting to see.
For the spacing, sounds like you have checked Row Padding/Cell Padding which is good. Make sure your padding is all zeros
I would recommend shrinking your rows beyond what they visibly look like they can handle, and make sure the CanGrow property is set to true. This will let SSRS determine the bare minimum space required.
Make sure you have no borders set
Beyond that I’m not sure how much tighter you could make it without hacking a overlapping solution.
Only limitations I have ran into are repeating column headers and showing totals at the bottom of reports (without consuming page footer space). Its frustrating for awhile for sure, but once you understand its quirks its tolerable and gets the job done.
If you are looking for granular control of field placement, try putting a rectangle inside of your cell. Then add a text box. This will allow you to control where you want your field inside the cell pixel by pixel. This is how Epicor designs their base forms when things don’t need to export cleanly to excel.
I was trying to stick with 1:1 row/field as I don’t like the tedious nature of fighting their text boxes and rectangles, but as we saw, that wasn’t working. So where I need tight spacing, I’ll have to add multiple fields per row, remove the padding from each field and basically overlap them in designer…even this doesn’t get them as close as desired(red box), but my options are few and it’s better than the spacing between rows (green box).