Issue:

The K2 Out of the Box Reports in the K2 Process Portal and SharePoint 2007 have version requirement conflicts with regards to the Microsoft Report Viewer.  Miss-configured environments can occur where the user will receive an error when trying to open a K2 Out of the Box Report. This KB article shows how to fix these environments, ensuring that the conflicts are resolved.

Error Scenarios:

The error might occur in one of the following scenarios:

  • If the environment has been upgraded from SharePoint 2007 to SharePoint 2010 and the Microsoft Report Viewer Redistributable 2005 SP1 has been removed or was not installed for any reason.
  • On a SharePoint 2007 environment where the Microsoft Report Viewer Redistributable 2005 SP1 is not installed

Microsoft Report Viewer Product Prerequisites:

Microsoft SharePoint 2007 requires the following to be installed for reporting purposes:

  • Microsoft Report Viewer Redistributable 2005 SP1

Microsoft SharePoint 2010 requires the following to be installed for reporting purposes:

  • Microsoft Report Viewer Redistributable 2008 SP1

K2 Out of the Box Reports requires the following to be installed:

  • Microsoft Report Viewer Redistributable 2008 SP1

From the above one can see that on the same web site the K2 Out of the box Reports requires the 2008 version whilst Sharepoint 2007 requires the 2005 versionThe Microsoft Report Viewer 2005 SP1 was not designed to work side by side with the Microsoft Report Viewer 2008 SP1 on the same web site.  However there is a way to get them to work using web.config modifications.  K2 used this method for Sharepoint 2007 and the K2 Out of Box Reports.

Error:

The following error will be displayed if the above error scenarios have been met and the user is trying to access one of the Out of the Box Reports:

Solution:

In order to resolve the error, the following steps can be applied:

Microsoft SharePoint 2007:

  • Install Microsoft Report Viewer Redistributable 2005 SP1
  • Perform an iisreset

Upgrade from SharePoint 2007 to SharePoint 2010:

  • Install Microsoft Report Viewer Redistributable 2005 SP1, then perform an iisreset

or

  • Remove the web.config entries

Removing the web.config entries:

The file can be located here:

C:\Inetpub\wwwroot\wss\VirtualDirectories\[PORT OR HOST HEADER]

Remove the following entries:

<dependentAssembly>

        <assemblyIdentity publicKeyToken="b03f5f7f11d50a3a" culture="neutral" />

        <bindingRedirect oldVersion="8.0.0.0" newVersion="9.0.0.0" />

      </dependentAssembly>

      <dependentAssembly>

        <assemblyIdentity publicKeyToken="b03f5f7f11d50a3a" culture="neutral" />

        <bindingRedirect oldVersion="9.0.0.0" newVersion="8.0.0.0" />

      </dependentAssembly>

Combination Requirements:

Apply the applicable solution above depending on the version of SharePoint installed, but do not uninstall Microsoft Report Viewer Redistributable 2008 SP1.

Environment configuration could be as follows:

  1. Microsoft SharePoint 2007 + K2 = Microsoft Report Viewer Redistributable 2005 SP1 and Microsoft Report Viewer Redistributable 2008 SP1
  2. Microsoft SharePoint 2010 + K2 = Microsoft Report Viewer Redistributable 2005 SP1 and Microsoft Report Viewer Redistributable 2008 SP1
  3. Microsoft SharePoint 2010 + K2 = Microsoft Report Viewer Redistributable 2008 SP1 and removing the web.config entries.

Notes:

  • If non K2 Reports are not used in Microsoft SharePoint 2007, it is possible to remove the web.config entries and the K2 Reports will work with only Microsoft Report Viewer Redistributable 2008 SP1.
  • On a clean Microsoft SharePoint 2010 environment that was not upgraded from Microsoft SharePoint 2007, the environment will be as shown above in (3) and no miss-configuration issues can occur.

Downloads:

The Microsoft Report Viewer Redistributable 2005 SP1 can be found in the following location:

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=e7d661ba-dc95-4eb3-8916-3e31340ddc2c

The Microsoft Report Viewer Redistributable 2008 SP1 can be found in the following location:

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=bb196d5d-76c2-4a0e-9458-267d22b6aac6