Reporting Services - How to rotate text on a report

I've been trying to do this for a long time and even looked into writing some CLR code that would take some text and produce a graphic of the text rotated.

Well all my prayers have been answered by a colleague of mine. Thanks Andrew.

To get text rotated in reporting services all you have to do is set the WritingMode to "tb-rl". You may also want to set the TextAlign and VerticalAlign to position the text correctly. Remember though the text is rotated so to get the text appearing on the left you have to set the VerticalAlign to Bottom. To get the text to align with the bottom of the text box you have to set the TextAlign to Right


-
Published 01 June 2007 10:55 by simonsabin
Filed under: , ,

Comments

23 November 2007 05:25 by Tina

# re: Reporting Services - How to rotate text on a report

hi simon,

i can rotate the text alright using writingmode option. but how can i rotate the text so it starts from bottom to top. instead of from top to bottom.

26 November 2007 15:00 by simonsabin

# re: Reporting Services - How to rotate text on a report

I don't believe its possible I'm afraid.

13 February 2008 15:19 by Jürgen

# re: Reporting Services - How to rotate text on a report

Hi, there is a possibility. In SSRS you can use your private assemblies. So i wrote a little class which get some strings, convert them 2 an image, rotate the image and send it back to the report. There instead of a textbox i used a image control to view the rotated text.

03 January 2009 09:13 by SimonS Blog on SQL Server Stuff

# Rotating text in SQL Server Reporting Services

I was reminded this morning of text rotate to how in a report. I've also developed some code to do