align paragraph in ssrs report

Question

Post reply

align paragraph in ssrs report

arkiboys

Hall of Fame

Points: 3958
More actions
November 18, 2013 at 3:32 am

#285352

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

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

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

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 1

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

arkiboys Hall of Fame Points: 3958 More actions · Answer 2

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

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 3

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

arkiboys Hall of Fame Points: 3958 More actions · Answer 4

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

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 5

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

arkiboys Hall of Fame Points: 3958 More actions · Answer 6

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 ?

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 7

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

arkiboys Hall of Fame Points: 3958 More actions · Answer 8

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

caio.a.lourenco SSC Rookie Points: 43 More actions · Answer 9

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?

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 10

Thanks for sharing 😉

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