Failed to load the appropriate report editor in PerformancePoint Dashboard Designer in SharePoint Server 2013

When I tried to create a new report with Reporting Service template via PerformancePoint Dashboard Designer.

PPReprtingservicereport

I got the following error

Failed to load the appropriate report editor

failedppssrs

Cause:

You seem to be missing Microsoft Report Viewer 2012, which you need in order to create Reporting Services reports in Dashboard Designer.

reportviwer2012

Solution:

First, make sure that Microsoft System CLR Types for SQL Server 2012 has been installed before installing Microsoft Report Viewer 2012 to avoid the following error.

Setup is missing an installation prerequisite : 
Microsoft System CLR Types for SQL Server 2012

CLRRequired

To download and install Microsoft system CLR Types for SQL Server 2012 check this link

  • Click Download.

Microsoft® SQL Server® 2012 SP1 Feature Pack

  • Select Select \x64\SQLSysClrTypes.

clrdownload

  • After installing Microsoft system CLR Types, go back to download and install Microsoft Report Viewer 2012

To download and install Microsoft Report Viewer 2012

  • Download it from the following link
  • Or click on the link within Information dialog that will download Microsoft Report Viewer 2012 automatically.
  • Click run to install it.

Now close the PerformancePoint Dashboard designer and reopen it again that should be now working properly 🙂

showssrsppworking

Enjoy 🙂

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s