Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSRS 2012 right aligned text cut off

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.

like image 476
drizzie Avatar asked Jan 14 '14 14:01

drizzie


People also ask

How do you set margins in SSRS report?

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.

How do you justify text in SSRS report?

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 ...

What is a placeholder in a report?

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.

What is a placeholder in SSRS?

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.


2 Answers

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.

like image 100
andy Avatar answered Sep 20 '22 17:09

andy


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.

like image 38
Florian Avatar answered Sep 18 '22 17:09

Florian