SQL Server 2008 RS Version Issue

Posted on 2012-09-17
Last Modified: 2012-09-17
I have sql server 2008 r2 loaded on my PC, but when I work on this current ssrs report (using sql server 2008 r2) that uses ROTATE270 I get below error:

Error      1      The WritingMode value 'Rotate270' is not supported in SQL Server 2008 Reporting Services. Set the WritingMode to either 'Horizontal' or 'Vertical' or change the ReportServerTargetVersion to a version that supports a WritingMode of 'Rotate270'.      C:\Workspaces\PECCS\Main\Reports\PECCS_Reports\Timeline.rdl      0      0

I did not write this report, just been told to make a change to it.

Exactly what version of SQL do I need ?  Or what am I missing ?
Question by:thayduck
    LVL 25

    Expert Comment

    Writing mode ROTATE 270 can be used only in Reporting Services 2008R2. You have to upgrade the ssrs version.

    Author Comment

    So, having Sql Server 2008 R2 does not mean you also have Reporting Services 2008R2 ?

    You have to do a separate upgrade of Reporting Services to R2 ?
    LVL 25

    Accepted Solution

    Yup. You can check the sql server version in http://reportserver/reportsfolder. there in the bottom you have the version of your ssrs installed shown.

    Author Closing Comment

    Thank You

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
    Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now