Do you want to install/upgrade to the new version of Reporting Services 2012?

You can see below the different combinations that are compatible with this new version concerning databases, BIDS, Report Viewer, SharePoint and PowerPivot.

It is mostly compatible with prior versions, incompatibilities revolve around loss of support for SQL Server 2000, BIDS 2000 and Report Builder 1.0

RS databases, BIDS & Report Viewer

Create
  ReportServer database on SQL 2000

Not
  supported

Create
  ReportServer database on SQL 2005 and later

Supported

Upgrade
  ReportServer 2000 database on SQL 2000

Not
  supported

Upgrade
  ReportServer 2000 database on SQL 2005

Supported

Upgrade
  ReportServer 2005 and later database on SQL 2005 and later

Supported

Deploy
  from BIDS 2000 to Reporting Services 2012

Unsupported

Deploy
  from BIDS 2005 and later to Reporting Services 2012

Supported

Deploy
  Report Model projects to Reporting Services 2012

Not
  supported

Upgrade
  BIDS 2000 and later projects in BIDS 2012

Supported

Upgrade
  Report Model Projects in BIDS 2012

Not
  supported

Use
  ReportViewer 8.0 and later against Reporting Services 2012

Supported

Use
  ReportViewer 11.0 against Reporting Services 2000 or 2005

Not
  supported

Use
  ReportViewer 11.0 against Reporting Services 2008 and later

Supported

 

Reporting Services, SharePoint & Add-in, Data Alert and Power View reporting features

        
  

SharePoint
   Version

  
  

Report Server
   Add-in

  
  

Report Server
   Back-end

  
  

Power View and
   Alerting Available

  

Windows
  SharePoint Services 3.0

2005

2005

No

Microsoft
  Office SharePoint Services 2007

2005

2005

No

Windows
  SharePoint Services 3.0

2008

2008
  or 2008 R2

No

Microsoft
  Office SharePoint Services 2007

2008

2008
  or 2008 R2

No

SharePoint
  Foundation 2010

2008
  R2 or 2012

2008
  SP2 or 2008 R2

No

SharePoint
  Foundation 2010

2012

2012

No

SharePoint
  Server 2010 Standard Edition

2008
  R2 or 2012

2008
  SP2 or 2008 R2

No

SharePoint
  Server 2010 Standard Edition

2012

2012

No

SharePoint
  Server 2010 Enterprise Edition

2008
  R2 or 2012

2008
  SP2 or 2008 R2

No

SharePoint
  Server 2010 Enterprise Edition

2012

2012

Yes 1

 

SharePoint, databases, PowerPivot

     
  

SharePoint
   Version

  
  

SQL 2012Catalog

  
  

PowerPivot

  

SharePoint
  Foundation 2010

No

No

SharePoint
  Server 2010 Standard Edition

No

No

SharePoint
  Server 2010 Enterprise Edition

No

No

SharePoint
  Foundation 2010 Service Pack 1

Yes 2

No

SharePoint
  Server 2010 Standard Edition Service Pack 1

Yes 2

No

SharePoint
  Server 2010 Enterprise Edition Service Pack 1

Yes 2

Yes 3

 

Note:


  1.   Power View and Data Alerts require the new Business Intelligence Edition or the Enterprise Edition of both SQL Server Reporting Services and SharePoint Server 2010. These features are also available, for testing purposes, in Developer and Evaluation editions.

  2.   If you want to use PowerPivot 2012and/or SQL Server 2012 for the SharePoint Catalog database, then you must install Service Pack 1 for SharePoint 2010. These features do not work with the RTM version of SharePoint 2010.

  3.   PowerPivot only comes with the Enterprise Edition of SQL Server and requires the Enterprise Edition of
      SharePoint Server 2010 (SP1).

 

Note:

   The BI Edition contains all the Enterprise features of Reporting Services and Analysis Services, including Data-driven Subscriptions, Data Alerts, Power
   View, and PowerPivot. It comes with the Standard Edition equivalent of the SQL Server database engine, though.