SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software Kodyaz Development Resources
Development resources, articles, tutorials, code samples and tools and downloads for ASP.Net, SQL Server, R Script, Windows, Windows Phone, AWS, SAP HANA and ABAP, like SAP UI5, Screen Personas, etc.

Software Development



Can not Rotate Text so Set Writing Mode is from Bottom to Top

Hello all MS SQL Reporting Services developers,

I'm developing Microsoft SQL Server Reporting Services reports using SSRS Business Intelligence Development Studio (BIDS) both SSRS 2005 and SSRS 2008.
I want to write all text in a table's header columns from bottom-to-up but I could not find a solution which gives me what I want.
Reporting Services rotates text in textbox by 90 degrees where a 270 degree rotate will solve by problem.

There are some solutions by converting the text into image and displaying as an image.
But since I want to serve the report as an EXCEL report, and since the report user might not like an image I'm stucked covering this request.
I have played with Direction and WritingMode properties of textbox in SQL Reporting Services 2008 and played with text direction and writing mode properties in format tab of textbox properties window; LTR and RTL, lr-tb and tb-rl


I have tried to find a solution as a work around by typing the column headers in reverse order like "REDAEH" instead of "HEADER" and using one true type upside-down fonts like Upside Down JJ or Blufunken.
But I'm not sure how this will result actually. I'm working on it.


Here is the current situation, a confusing problem because SSRS is not capable of rotating the text 270 degrees.


Here is the view I want to have. I have marked the bottom-to-up text writing mode with red borders.



Rotate Text Solution
Here is an update for the solution of Rotate Text in SQL Server Reporting Services reports with previous SSRS version than SQL Server 2008 R2, please refer to Jason Thomas blog for creating images on the fly as table column headers instead of rotating text.
Thanks Jason for his solution, very helpful for whom working with SQL Server Reporting Services versions before SQL2008 R2


Published Thursday, March 12, 2009 5:17 PM
Filed Under: , , ,

Comments

 

eralper said:

If you check the above URL you will see that with new Microsoft SQL Server version, MS SQL Server 2008 R2 November CTP the Reporting Services is now improved in order to rotate text 270 degrees. Business Intelligence developers will be able to use text in Reporting Services reports with 270 degree text rotation.
November 11, 2009 4:12 AM
 

eralper said:

Hello all BI Developers working on SQL Server Reporting Services,
If you are reading this post probably you have a similar problem, rotate text in 270 degree problem in your SQL Reporting Services reports.
MS SQL Server 2008 R2 Reporting Services now enables report developers to rotate text in 270 degree to solve their problems.
May 19, 2010 10:59 AM
Anonymous comments are disabled

About eralper

SQL Server administrator and T-SQL developer including BI components Web programming with HTML, HTML5 and ASP, ASP.NET and .NET Framework developer SAP ABAP and SAPUI5 development, Web Dynpro and Smart Form Siemens HiPath Center CTI development
Copyright © 2004 - 2020 Eralper YILMAZ. All rights reserved.
Community Server by Telligent Systems