We recently upgraded from SSRS 2008 R2 to SSRS 2012. A good portion of our existing reports are now rendering with some columns cutting off right-aligned text.
We used BIDS 2008 to develop the reports and then deploy the RDL's to SSRS 2012 server.
I cannot replicate the issue locally, which leads me to believe there is some server configuration that could be changed.
I've verified that the fonts used are installed on the server.
Anyone have any ideas?
Update
Simply adding 2pt right indent to the affected textboxes prevents the cutoff. This is obviously a band aid, and it would be better to determine the actual cause and fix.
To adjust page size and margins, double-click Settings in the Section tree on the right side of the Report Designer. Click Page Setup to adjust page margins. Click Printer Settings to adjust paper size. Click OK to accept the changes and close the dialog box.
So to justify text, we basically need to divide the text into paragraphs by carriage returns, then by words with spaces, and measure the size of how each word will render in the selected font to determine how many words will fit on each line, and as a result, how many Unicode "hair space" characters are needed between ...
Placeholders are markers in a template that tell users what data items they should add to the report. A placeholder can show which data item the user should fill it with. It can also perform a calculation using the data item the user fills it with, and show the result in the report.
A placeholder allows you to segment out the parts and pieces of a textbox and actually format them individually. In either case, you need to understand which pieces and parts you would like to highlight, change, or adjust. We will use the Adventure Works databases as the basis for our SSRS reports.
Adding an indent does work, but for us it made the column headers not in sync with the data.
I set ShrinkToFit = true
.
That fixed the problem without moving it over.
I had the same issue on a new RDLC 2012 report. Though not all numbers were cut. Thanks to andy I was able to focus on the CanGrow
and CanShrink
Properties of the Cell. I had set CanGrow=False
and CanShrink=False
. Setting either of this to true did fix the issue.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With