A new feature of Reporting Services 2008 R2 is the ability to 'easily' rotate text 270 degrees. This was very difficult to do in the past and required that you create images for your headers instead of using text. YUCK! Naturally, this is not a preferred work around. So in this blog post I will show how easy this is in the future version of SSRS.
Let's start with my boring report:
In this report you can see that the data for the Business Entity field takes up much left space left to right than it's header. For reports where we have all this whitespace, we often want to rotate the headers 270 degrees so that we can fit more data on the page. This report is simply an example, but as you can imagine, if you had a large number of these fields you would gain a lot of horizontal real estate by rotating the header text.
The first thing you will do is select the column or columns that you want to rotate in the header row. For this example, I selected the entire row.Next, in the properties window under the Localization section, choose the dropdown for WritingMode and choose the new "Rotate270" option.
After you select "Rotate270", you will need to expand the header row height by dragging the bottom of the row down far enough for the text to not wrap.Last step is to shrink the Business Entity column to save that precious real estate and run the report.
It should look something like this.
Be sure to check out the other posts in this series.
New features of SSRS 2008 R2 - Part 1 Naming Excel sheets when exporting reports
New features of SSRS 2008 R2 - Part 2 Report Part Gallery
New features of SSRS 2008 R2 - Part 3 Map and spatial data visualization
I am having trouble with the rotated text appearing correctly oriented in the reportviewer control on an ASP.NET web app. The report renders correctly in preview in BIDS and in Report Manager, but not in our web app using the control. I've tried the Report Viewer 2008 control and that has the text appearing top to bottom. While Report Viewer 2010 renders the text horizontal! Have you had success with bottom to top rotation via the Report Viewer control? If so, how? My clients have been waiting for this functionality for over 2 years now and it was one of items that we told them was coming with our SQL Server migration.
Good post! The following blog shows how to do it in SSRS 2005 and 2008 too