Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Analysis Server and Reporting Services (2008)  Vertical Text

Author  Topic  tonyem Starting Member 1 Post Posted - 2009-10-27 : 08:53:37 In converting a matrix report from 2005 to 2008, I noticed vertical text in one of the data columns was not spread out to fill the box, but was being 'wrapped' to the next line each time a space was encountered. Put these on their sides (Rotate 90 degrees c/w): I wanted: ____________________________________________ | | 11. Fully-Furnished Arcturian Widgets with | Fake Leopard-Fur Linings and Ebony Grab | Handles |____________________________________________ So I set the textbox properties to - Writing Mode: Vertical, TextAlign: Left, VerticalAlign: Middle. (Direction: LTR <Left-To-Right>) I got the exact result I wanted in Preview with & without Print Layout, but when I deployed the report to the report server, the same text boxes looked like this: ____________________________________________ | | 11. Fully-Furnished | Arcturian Widgets | with Fake | Leopard-Fur Linings | and Ebony Grab | Handles |___________________________________________ As you can see (Rotate 90 degrees clockwise..) The matrix columns had -- w i d e n e d --, and as these are column headers for 4-digit max quantities, the 30 such columns would no longer fit my landscaped print page (A4: 29.7 x 21.5 cm). It turns out that I must use the text box properties, general, sizing options, and check the "Allow height to increase" option. Now this option stretches the box height to the length of the maximum text data read, i.e. _____________________________________________________________________________________________ | | 11. Fully-Furnished Arcturian Widgets with Fake Leopard-Fur Linings and Ebony Grab Handles | |_____________________________________________________________________________________________ So the width of the report is now preserved, i.e. on one sheet, but the height will force this report over two pages - huhh. I actually found that: 1) You get what you set with SSRS 2005; 2) It looks like you get wider columns or longer columns, when you preview the deployed report in 2008; BUT .. When you print the deployed report in 2008 via the Report Server, the elongated columns, due to my checking the "Allow height to increase" option, revert back to the originally-configured height, and the text is WRAPPED within the originally-configured width. So all is well again. Moral: Don't believe what you see in the deployed preview, print the report out and see for yourself.