Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Articles / DevOps

Manage Data Source Screen Is Not Working for SSRS Report in SharePoint 2013 - Chrome Browser

5.00/5 (2 votes)
2 Jul 2016CPOL 8.1K  
Manage Data Source Screen Is Not Working for SSRS Report in SharePoint 2013 - Chrome Browser

Introduction

We noticed a couple of times that a Sharepoint site is erroring out when we add a new report and map the report to data source. We are not able to go to the data source folder to select the necessary data source.

Steps to reproduce issue:

  1. Navigate to SharePoint library where we hosted SSRS report
  2. Select the report and click "..." later will open a popub
  3. In the Popup window, again click "..." and select "Manage Data Sources" from the menu

    Image 1

  4. Click link on the Manage Data Source Screen

    Image 2

  5. Then click "..." buttton on below screen

    Image 3

  6. The data source screen will be blank, suppose it should be displayed all the folders are available in the site collection.

     

    Image 4

Solution

  1. Navigate to the Sharepoint Server Machine where your site deployed (WFE)
  2. Open the path C:\Program Files\Common Files\microsoft shared\Web Server Extensions\15\TEMPLATE\LAYOUTS\ReportServer
  3. Opent the file RSItemPicker.aspx and add the code in ContentPlaceHolderID="PlaceHolderDialogBodySection" section.
    HTML
    <style>
    .ms-settingsframe {
    overflow:visible!important;
    }
    </style>
  4. Finally, the file will look like below:
    ASP.NET
    <%@ Page language="C#" Codebehind="RSItemPicker.aspx.cs" 
    AutoEventWireup="true" 
    Inherits="Microsoft.ReportingServices.SharePoint.UI.RSItemPickerPage,
    Microsoft.ReportingServices.SharePoint.UI.ServerPages,Version=12.0.0.0,Culture=neutral,
    PublicKeyToken=89845dcd8080cc91" 
    MasterPageFile="~/_layouts/15/pickerdialog.master" %>
    <%@ MasterType VirtualPath="~/_layouts/15/pickerdialog.master" %>
    
    <asp:Content ID="DialogImageContent" 
    ContentPlaceHolderID="PlaceHolderDialogImage" runat="server">
    <asp:Image ID="DialogImage" runat="server" />
    </asp:Content>
    
    <asp:Content ID="WindowTitleContent" 
    ContentPlaceHolderID="PlaceHolderDialogHeaderPageTitle" 
    runat="server">
    <asp:Literal ID="WindowTitle" 
    runat="server"></asp:Literal>
    </asp:Content>
    
    <asp:Content ID="TitleAreaContent" 
    ContentPlaceHolderID="PlaceHolderDialogTitleInTitleArea" 
    runat="server">
    <asp:Literal ID="TitleAreaTitle" runat="server"></asp:Literal>
    </asp:Content>
    
    <asp:Content ContentPlaceHolderID="PlaceHolderSiteName" runat="server">
    <br>
    </asp:Content>
    
    <asp:Content ContentPlaceHolderID="PlaceHolderHelpLink" runat="server">
    </asp:Content>
    
    <asp:Content ID="DialogBodyContent" 
    ContentPlaceHolderID="PlaceHolderDialogBodySection" 
    runat="server">
    <style>
    .ms-settingsframe {
    overflow:visible!important;
    }
    </style>
    <asp:PlaceHolder ID="InsideMainContent" runat="server" />
    
    </asp:Content>

History

  • 2nd July, 2016: Initial version

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)