To summarize what I am trying to do, I first want to provide some information. We currently are using TFS 2013 and have Reporting Services setup for TFS. The TFS 2013 Deployment and Reporting Services (SQL 2012) are on separate servers. Reporting works fine and I can create custom reports from TFS data.

We also have TFS 2013 integrated with SharePoint 2013. TFS 2013 and SharePoint 2013 are on separate servers as well. The TFS integration with SharePoint works as expected. We are using the Release Dashboard to provide TFS data.

So in summary, TFS 2013, SharePoint 2013, and Reporting Services are all on separate servers.

My question:

I would like to be able to add the "Report Viewer Web Part" on certain SharePoint sites. Under the list of web parts I can add, the Report Viewer Web Part isn't listed in any category.

From looking around online, it seems I must have the "SQL Server 2012 Reporting Services Add-in for SharePoint" installed on the SharePoint servers.

1) Is installing the add in on the SharePoint servers the only way to make the report viewer web part available?

2) If there is another way to make the Report Viewer Web Part available, what is it?

3) Does any changes have to be made on the SQL/Reporting Server?

My current workaround is to add the "Page Viewer Web Part" and add the URL of the report file on the reporting server. This doesn't give me as much functionality.

Thanks for any help that can be provided!

Hi,

1. No, it is not the only way to make the report viewer web part available.

2. You could make the report view web parts available through the RSWebParts.cab filecoming with SQL Server Reporting Services. This report view web part works with Reporting Services in native mode.

3. If you make report view web part available by installing the reporting service add-in. You could integrate report server with SharePoint server. You could refer to the articles below for more detailed information.

The article below is about how to: Configure Report Server Integration in SharePoint Central Administration.

https://technet.microsoft.com/en-US/library/Bb326213(v=SQL.105).aspx

The article below is about Install or Uninstall the Reporting Services Add-in for SharePoint.

https://msdn.microsoft.com/en-us/library/aa905871.aspx

The article below is about Where to find the Reporting Services add-in for SharePoint Products.

https://msdn.microsoft.com/en-us/library/gg426282.aspx

If you make report view web part available through RSWebParts.cab file, you could switch the report server to native mode. NOTE: RSWebParts.cab in SQL Server 2008 R2 version can works for SharePoint 2013. You could refer to the case below.

https://social.msdn.microsoft.com/Forums/en-US/b2ea4860-0017-4c19-b6ae-7c3769b40640/sharepoint-2013-and-native-mode-ssrs-web-parts

For more detailed information, you could refer to the articles below.

The article below is about View and Explore Native Mode Reports Using SharePoint Web Parts (SSRS).

https://msdn.microsoft.com/en-us/library/ms159772.aspx

Best regards,

Sara Fan

Hi,

1. No, it is not the only way to make the report viewer web part available.

2. You could make the report view web parts available through the RSWebParts.cab filecoming with SQL Server Reporting Services. This report view web part works with Reporting Services in native mode.

3. If you make report view web part available by installing the reporting service add-in. You could integrate report server with SharePoint server. You could refer to the articles below for more detailed information.

The article below is about how to: Configure Report Server Integration in SharePoint Central Administration.

https://technet.microsoft.com/en-US/library/Bb326213(v=SQL.105).aspx

The article below is about Install or Uninstall the Reporting Services Add-in for SharePoint.

https://msdn.microsoft.com/en-us/library/aa905871.aspx

The article below is about Where to find the Reporting Services add-in for SharePoint Products.

https://msdn.microsoft.com/en-us/library/gg426282.aspx

If you make report view web part available through RSWebParts.cab file, you could switch the report server to native mode. NOTE: RSWebParts.cab in SQL Server 2008 R2 version can works for SharePoint 2013. You could refer to the case below.

https://social.msdn.microsoft.com/Forums/en-US/b2ea4860-0017-4c19-b6ae-7c3769b40640/sharepoint-2013-and-native-mode-ssrs-web-parts

For more detailed information, you could refer to the articles below.

The article below is about View and Explore Native Mode Reports Using SharePoint Web Parts (SSRS).

https://msdn.microsoft.com/en-us/library/ms159772.aspx

Best regards,

Sa

Hi,

If you do not integrate SQL Reporting with SharePoint, you could use native mode. But only the RSWebParts.cab in SQL Server 2008 R2 version can works for SharePoint 2013.  And in your environment, it only has SQL 2012. So you could use the SharePoint mode. And you should integrate SQL Reporting with SharePoint and install the reporting service add-in.

Best regards,

Sara Fan