none
Report Builder 3.0 'backward' compatibility?? RRS feed

  • Question

  • I've been asked to deploy Report Builder -- a new deployment, it's never been deployed before.

    Can RB 3.0 create reports against all versions of SQL Server -- 2005, 2008, and 2008 R2??

    I understand that they might not be backward-compatible with earlier versions of Report Builder.

    Can Report Builder 3.0-created reports be used and seen within WSS 3.0 running on SQL 2008?? -- what would be necessary to make this happen??

    The present reporting server files installed to the Citrix servers and SharePoint server are SQL 2008 Reporting Services files (10.x), I imagine installing Report Builder 3.0 would be compatible??

    Thank you, Tom

    Wednesday, July 21, 2010 7:12 PM

Answers

  • RB 3.0 can be used for SQL Server R2 only.

    If you try to connect RB 3.0 to a SQL Server 2008 SSRS, it will give you an error.

    If you save a RDL you created in RB 3.0 then manually upload to  SQL Server 2008 SSRS, it will also give you an error.

    "The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition' which cannot be upgraded. (rsInvalidReportDefinition)" 

    This means you can only use RB 3.0 to create reports for SQL Server 2008 R2.  You can however use BIDS R2 to deploy to either a SQL Server 2008 or SQL Server 2008 R2 server.  There is a TargetServerVersion in Project Properties.

    The best way is to upgrade SQL Server 2008 to SQL Server 2008 R2 in order to use RB 3.0.

    Hope this helps!


    Thanks, Michael Mei
    Wednesday, July 21, 2010 7:50 PM
  • Nope. Each report processor (built into Reporting Services, the BI tools preview window, Report Builder and the ReportViewer control) is matched to one of the four (or more) RDL formats. To see what format your RDL is using, simply open the RDL file and inspect the first line. If it says 2010 then it only works with RB3 and the SS2K8R2 Reporting Services RP. 2008 works with RB2 and SS2K8...

    This is a "by design" issue. While the 2008 R2 tools know how to choose the RP, it only supports one or the other.


    __________________________________________________________________
    William Vaughn
    Mentor, Consultant, Trainer, MVP
    http://betav.com
    http://betav.com/blog/billva
    http://www.hitchhikerguides.net

    “Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)”

    Please click the Mark as Answer button if a post solves your problem!

    Wednesday, July 21, 2010 10:15 PM

All replies

  • RB 3.0 can be used for SQL Server R2 only.

    If you try to connect RB 3.0 to a SQL Server 2008 SSRS, it will give you an error.

    If you save a RDL you created in RB 3.0 then manually upload to  SQL Server 2008 SSRS, it will also give you an error.

    "The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition' which cannot be upgraded. (rsInvalidReportDefinition)" 

    This means you can only use RB 3.0 to create reports for SQL Server 2008 R2.  You can however use BIDS R2 to deploy to either a SQL Server 2008 or SQL Server 2008 R2 server.  There is a TargetServerVersion in Project Properties.

    The best way is to upgrade SQL Server 2008 to SQL Server 2008 R2 in order to use RB 3.0.

    Hope this helps!


    Thanks, Michael Mei
    Wednesday, July 21, 2010 7:50 PM
  • Can I use Report Builder 2.0 against SQL Server 2008 R2 if necessary??

    Thank you, Tom
    Wednesday, July 21, 2010 7:55 PM
  • I just tried to create a RDL in RB 2.0 and is able to upload to SQL Server 2008 R2.

    Actually my current client might be facing similar situation, we have not upgraded to SQL Server 2008 R2 yet but the business users want to use RB 3.0.

    Hope this helps!


    Thanks, Michael Mei
    Wednesday, July 21, 2010 8:24 PM
  • Nope. Each report processor (built into Reporting Services, the BI tools preview window, Report Builder and the ReportViewer control) is matched to one of the four (or more) RDL formats. To see what format your RDL is using, simply open the RDL file and inspect the first line. If it says 2010 then it only works with RB3 and the SS2K8R2 Reporting Services RP. 2008 works with RB2 and SS2K8...

    This is a "by design" issue. While the 2008 R2 tools know how to choose the RP, it only supports one or the other.


    __________________________________________________________________
    William Vaughn
    Mentor, Consultant, Trainer, MVP
    http://betav.com
    http://betav.com/blog/billva
    http://www.hitchhikerguides.net

    “Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)”

    Please click the Mark as Answer button if a post solves your problem!

    Wednesday, July 21, 2010 10:15 PM
  • As noted, RB2.0 can publish to SQL 2008 R2 just fine.  However, RB3.0 works only against 2008 R2 and not 2008.  Note that you must have an R2 license to use RB3.0 so using RB3.0 against 2008 server is unlikely.
    Thursday, July 22, 2010 10:23 PM
    Moderator
  • I managed to manually tweak the XML to get my RB3 report successfully deployed on SSRS 2008...

    It would be nice if RB3.0 would show some options on File | New | Report

    • "Report for Reporting Services 2005"
    • "Report for Reporting Services 2008"
    • "Report for Reporting Services 2008 R2"

    Even though RB3 is not able to do that, at least it should show a warning or something:

    "Reports for Reporting Services 2008 should be developed with RB2.0"


    Peter Gfader
    Tuesday, August 31, 2010 11:12 PM
  • Any chance of you posting the XML tweaks?   I would concur that having some level of backward compatibility (or warning to that effect) would be a good addition.
    Wednesday, September 1, 2010 11:09 PM
  • This is not a recommended practice. While some have tweeked reports and gotten it to work, this is not guaranteed to work on  more sophisticated reports--especially when trying to get an older engine to support newer RDL. Conversion from old to new is easy--let the BI tools do it for you automatically.

    __________________________________________________________________
    William Vaughn
    Mentor, Consultant, Trainer, MVP
    http://betav.com
    http://betav.com/blog/billva
    http://www.hitchhikerguides.net

    “Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)”

    Please click the Mark as Answer button if a post solves your problem!

    Monday, October 4, 2010 4:43 PM