SSRS Report textbox text-align:Justify

Thiru S 21 Reputation points
2022-01-20T09:25:39.193+00:00

Hi,

I have built out the SSRS Report and in that I have a textbox and I'm showing text summary with 10 lines. I was trying to find a text align to be "Justify", but i cannot find.

I tried googling, to figure out a solution for text-align: justify;

I tried by placing a textbox and to render a HTML text , it does not work the text gets left aligned.
(Note: placeholder with text-align:left is working expected, but text-align:justify only not working)

How can we implement any ideas ?
Please help on this,

Not working : ="<p style=""text-align:justify"">"+Fields!PortfolioUpdate.Value+"</p>"
Working : ="<p style=""text-align:left"">"+Fields!PortfolioUpdate.Value+"</p>"

166746-image.png

166690-image.png

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,716 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,799 questions
0 comments
Accepted answer
  1. Joyzhao-MSFT 15,566 Reputation points
    2022-01-21T06:03:38.197+00:00

    Hi @Thiru S ,
    In SSRS justify is normaly not supported. You could try using custom code: SQL Server Reporting Services (SSRS): How to Justify Text (Part 2).
    Best Regards,
    Joy

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ronen Ariely 15,096 Reputation points
    2022-01-20T09:59:52.38+00:00

    I did not try it but check the solution in this thread:

    https://stackoverflow.com/questions/11133644/justify-text-in-sql-reporting-services

    0 comments
  2. Thiru S 21 Reputation points
    2022-01-20T12:42:18.697+00:00

    Thank you @Ronen Ariely ,

    I tried with that link(Image 1), I am able to get the justify text, but after downloading pdf from server and open in local PC, i could see only Junk characters(see Image 2), not displaying exact font(Verlag Book font),

    I used below C# code to convert the text into as Justified with <div> Tags and using Placeholder html transformation

    166778-2022-01-20-18-00-00.png

    166767-image.png

  3. Thiru S 21 Reputation points
    2022-01-21T06:12:48.59+00:00

    Thank you @Joyzhao-MSFT & @Ronen Ariely
    I tried your both solutions, it is working fine 90%,
    After applying above logic, yesterday, what was facing font issue in local PC after PDF download, that issue also fixed,
    It is a mistake i used OTF font, finally i used TTF, issue fixed,
    Once again thanks for you both.

    0 comments
  4. Sripriya Kunaratnam 0 Reputation points
    2024-02-17T01:22:49.7566667+00:00

    can you give a solution for justify alignment in SSRS?

    0 comments