Search results

Load SharePoint integrated reports

To render SharePoint integrated SSRS reports set the reportServerUrl, reportPath, and reportServiceUrl properties as in the following code snippet.

    <div style="height: 100%; width: 100%;">
        <div style="height: 600px; width: 950px; min-height: 400px;" id="viewer"></div>
        <script type="text/javascript">
            $(function () {
                $("#viewer").ejReportViewer({
                    reportServiceUrl: "/api/SharePointReports",
                    reportPath: "http://mvc.syncfusion.com/dev_report/SSRSSamples/Territory Sales.rdl",
                    reportServerUrl: "http://mvc.syncfusion.com/dev_report/reportserver"
                });
            });
        </script>
    </div>

You can view the Web API service used in the above code from the Reporting Service git hub location. For more information, see Samples and demos. In SharePoint integrated mode, the reportServerUrl will be same as your site URL. The reportPath is relative to the Report Server URL with the file extension.

Forms credential for SharePoint server

The Forms credentials are required to connect with the specified SharePoint integrated SSRS Report Server using the Report Viewer. Specify the ReportServerFormsCredential property in the Web API Controller OnInitReportOptions method.

public void OnInitReportOptions(ReportViewerOptions reportOption)
{
    //Add ReportServerFormsCredential for server
    reportOption.ReportModel.ReportServerFormsCredential = new Syncfusion.Reporting.Web.ReportServerFormsCredential("ssrs", "RDLReport1");
}

Set data source credential for shared data sources

The shared data source credentials can be added to the DataSourceCredentials property to connect with the database.

public void OnInitReportOptions(ReportViewerOptions reportOption)
{
    //Add ReportServerFormsCredential and data source credentials
    reportOption.ReportModel.ReportServerFormsCredential = new Syncfusion.Reporting.Web.ReportServerFormsCredential("ssrs", "RDLReport1");
    reportOption.ReportModel.DataSourceCredentials.Add(new Syncfusion.Reporting.Web.DataSourceCredentials("AdventureWorks", "ssrs1", "RDLReport1"));
}

Data source credentials must be added for shared data sources that do not have credentials in the connection strings.

  • Build and run the application. Preview and edit the result using the following.
index.html
index.js
SharePointReportsController.cs
    <body style="overflow: hidden; position: static; margin: 0; padding: 0; height: 100%; width: 100%;">
    <div id="viewer" style="position: absolute; height: 100%; width: 100%;"></div>
    <script src="index.js"></script>
    </body>
$(function () {
    $("#viewer").ejReportViewer({
                    reportServiceUrl: "https://reports.syncfusion.com/demos/services/api/SharePointReports",
					reportPath: "http://mvc.syncfusion.com/dev_report/SSRSSamples/Territory Sales.rdl",
                    reportServerUrl: "http://mvc.syncfusion.com/dev_report/reportserver"
                });
});
public void OnInitReportOptions(ReportViewerOptions reportOption)
{
    //Add ReportServerFormsCredential and data source credentials
    reportOption.ReportModel.ReportServerFormsCredential = new Syncfusion.Reporting.Web.ReportServerFormsCredential("ssrs", "RDLReport1");
    reportOption.ReportModel.DataSourceCredentials.Add(new Syncfusion.Reporting.Web.DataSourceCredentials("AdventureWorks", "ssrs1", "RDLReport1"));
}