align paragraph in ssrs report

  • Hi,

    I have a query regarding aligning a paragraph in SSRS

    We are using sql server 2008 R2 and in teh reports we use paragraphs which are aligned on the left hand side.

    Question:

    How do I align the right hand side too please?

    Thanks

  • By choosing align right from the toolbar?

    (see screenshot in attachment)

    edit: you can also modify the TextAlign property

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Koen Verbeeck (11/18/2013)


    By choosing align right from the toolbar?

    (see screenshot in attachment)

    edit: you can also modify the TextAlign property

    Hi, Not quite because I would like to align left and right.

    Not just left or just right.

    Is this possible please?

    Thanks

  • Yes. Select the text you want right and allign it right.

    Select the text you want left (on another line of course), and allign it left.

    If both text are on the same line, you need multiple text boxes.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Koen Verbeeck (11/18/2013)


    Yes. Select the text you want right and allign it right.

    Select the text you want left (on another line of course), and allign it left.

    If both text are on the same line, you need multiple text boxes.

    Maybe I am not explaining this properly...

    I have a large textbox which takes multiple lines of text.

    At present, this text box is left aligned only.

    I would like to have both left and right alignment on this textbox so that the left side is all aligned as well as the right side.

    Thanks

  • You mean "fully justify".

    This is not possible (yet) in SSRS.

    full justification in reporting services 2008 needed

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Koen Verbeeck (11/18/2013)


    You mean "fully justify".

    This is not possible (yet) in SSRS.

    full justification in reporting services 2008 needed

    I see. What are my options? Get the sql server 2012 ?

  • arkiboys (11/18/2013)


    Koen Verbeeck (11/18/2013)


    You mean "fully justify".

    This is not possible (yet) in SSRS.

    full justification in reporting services 2008 needed

    I see. What are my options? Get the sql server 2012 ?

    As far as I know, the option lacks also in SQL Server 2012.

    In the connect item I linked to, there are some work around mentioned (most of them are custom plug-ins).

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Koen Verbeeck (11/18/2013)


    arkiboys (11/18/2013)


    Koen Verbeeck (11/18/2013)


    You mean "fully justify".

    This is not possible (yet) in SSRS.

    full justification in reporting services 2008 needed

    I see. What are my options? Get the sql server 2012 ?

    As far as I know, the option lacks also in SQL Server 2012.

    In the connect item I linked to, there are some work around mentioned (most of them are custom plug-ins).

    Thanks

  • Or you could use a placeholder in a textbox and place some html tags around the text you want to format. Few tags available if you ask me, but does the trick for some people. https://msdn.microsoft.com/en-us/library/cc627491(v=sql.100).aspx

    P.S.: I know, "late to the party pal", but I trailed this path alone and found the fountain so, why not share?

  • Thanks for sharing 😉

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply