Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

We have a need to upgrade from SP2010+PWA to SP2013+PWA. Our database server will be SQL Server 2008 R2.

According to Technet, the SQL 2008 R2 Reporting Services add-in for SharePoint isn't compatible with SP2013 (it only plays nicely with SQL2012's reporting add-in);

For SharePoint 2013, you can ONLY use the SQL Server 2012 SP1 version of the Reporting Services add-in for SharePoint.
http://msdn.microsoft.com/en-au/library/gg492257.aspx

Our requirement is to show a report in a page of SharePoint. Previously we had used the Report Viewer Web Part but now we need an alternative method.

What alternative ways are there to embed a report within a SharePoint (2013) page?

share|improve this question
    
What do you plan to do with SSRS? Leave it in a 2010 version, or move it to a native (non-integrated) instance? There used to be a regular html view that was available which could be hosted in a web page viewer web part. –  Mike Oryszak Apr 4 '13 at 12:59
    
Hi Mike, ta for the words. Our SSRS is already in Native mode c/o some other applications on the server. I do believe our 2013 deployment is getting it's own DB instance on a new DB server so I'm hoping we may get an upgrade to SQL 2012. I have been thinking that the Page Viewer webpart may be a suitable workaround & have suggested that to the dev however I just want to check for any more elegant options! –  Beeblebrox Apr 4 '13 at 21:59
add comment

2 Answers

One alternative would be to use Excel Services to display a report. (details would depend on your specific requirements and data sources though).

share|improve this answer
    
Thanks @lwbecker2. I think the trick to that is that we already have an existing SSRS report that we're trying to retain. I must admit I don't know much about SSRS & Excel reporting services, is it a trivial operation to move an SSRS report to Excel services or is it a complete redevelopment effort? –  Beeblebrox Apr 4 '13 at 22:02
add comment

As an update, we're going to try this: - install SQL Server 2012 Reporting Services (SSRS) only on the SP box - Configure the reporting service to use the SQL 2008 R2

This should bring in the required webparts. The 'iffy' part of all this is the license ramifications (which we'll know more about on Monday) + whether it's possible to run this config & have it still be supported when using a standard SQL edition rather than enterprise.

Will update when we have some answers.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.