Search results

Load SharePoint Integrated Reports

To render the SharePoint integrated SSRS reports, set the report-server-url, report-path, and report-service-url properties as shown in the following code snippet.

    <sf-report-viewer id="viewer" report-service-url="/api/ReportViewer" processing-mode="Remote" report-server-url="http://mvc.syncfusion.com/dev_report/reportserver" report-path="http://mvc.syncfusion.com/dev_report/SSRSSamples/Territory Sales.rdl">
    </sf-report-viewer>

In SharePoint integrated mode, the report-server-url will be same as your site URL. The report-path is relative to the Report Server URL with the file extension.

Forms credential for SharePoint Server

The forms credentials are required to load the SharePoint integrated SSRS report from 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 to 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 should be added to shared data sources that do not have credentials in the connection strings.