Issue when creating new “Report Data Source”, “Report Builder Report” or “Report Builder Model”

If after installing the Reporting Services 2012 Add-in on a SharePoint Server 2013 Farm, you get the following message when you try to create a new “Report Data Source”, “Report Builder Report” or “Report Builder Model”:

‘New Document’ requires a Microsoft SharePoint Foundation-compatible application and web browser. To add a document to this document library, click the ‘Upload Document’ button.

This issue is related to the property “RequireClientRenderingOnNew” that is not set to the correct value for the Content Types “Report Data Source”, “Report Builder Report”, “Report Builder Model”.

By default, the value of the property “RequireClientRenderingOnNew” is $false for these Content Types. It can happen that the value is switched to $true, which prevents the creation of new items based of these Content Types so we need to change it back to $false.

To roll back to the default value, the following script can be used:

$siteUrl = "https://intranet.contoso.com"

$docLibName = "Documents"

$reportingServicesCTs = "Report Data Source", "Report Builder Report", "Report Builder Model"

$spWeb = Get-SPWeb -Identity $siteUrl

foreach ($reportingServicesCT in $reportingServicesCTs)

{

$contentType = $spWeb.ContentTypes[$reportingServicesCT]

if($contentType.RequireClientRenderingOnNew -eq $true)

{

$contentType.RequireClientRenderingOnNew = $false

$contentType.Update()

Write-Host $contentType.Name "updated (web level)" -ForegroundColor Yellow

}

else

{

Write-Host "No update needed for (web level): " $contentType.Name

}

$docLib = $spWeb.Lists[$docLibName]

$docContentType = $spWeb.ContentTypes[$reportingServicesCT]

if($docContentType.RequireClientRenderingOnNew -eq $true)

{

$docContentType.RequireClientRenderingOnNew = $false

$docContentType.Update()

Write-Host $docContentType.Name "updated (DocLib level)" -ForegroundColor Yellow

}

else

{

Write-Host "No update needed for (DocLib level): " $docContentType.Name

}

}

Thanks to Radu CARAIVAN for having reviewed my post.

Matthieu RUNTZ