SSRS textbox clipping when exporting to PDF

1
votes

I was working with an SSRS report that uses multiple textboxes in a list control. I found that when I ran and exported my report to PDF (and printed/exported to .XPS), certain textboxes would just ever so slightly get clipped.

Note: when the report rendered in SSRS development env., every textbox looked fine and the text never got clipped. The issue just occurs when exporting, and on seemingly random textboxes (random to me).

I've tried adjusting the height and width properties of the textboxes, and the CanGrow property to true/false. Even making the text a different size (like 5 point) or even a different font made no difference. The amount of text that filled the field didn't matter. I made sure the margins on the page were sufficient. I also made sure there were no other report objects that were overlapping the offending textboxes. Neighboring textboxes that displayed fine were set to be perfectly aligned vertically with ones that had the text problems, and still no luck.

None of these options above worked. I have also seen a few questions on stackoverflow that are similar, but not exact.

How do I keep these textboxes from clipping the text when exporting to PDF?

Thank you.

Sample: textbox text is cut off very slightly on SSRS report exported to PDF for certain textboxes

1
sqlpdfreporting-servicesbusiness-intelligencessrs-2012
I have also seen this occasionally. In our case, it happens when a numeric field is all 1s before the decimal point, '$11,111.45' cuts off the 5 ever so slightly. – Jeff Cuscutis

1 Answers

1
votes

I have solved my own issue after some tinkering, though perhaps its not the best solution out there but it works.

I hard coded a space character at the end of each textbox field's expression that had the clipping issue,

For example:

=First(Fields!zipCode.Value) + " "

The only minor draw back is that it shifts the alignment of the text left by one space. Hope this helps.