We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Show SSRS Reports on SSRS report server using ReportViewer


Am trying to implement ReportViewer control in asp.net core using SSRS reports on SSRS reportserver, I followed the documentation and modified the sample project from the link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/ReportSample_core_2.01547272499

changes I made:
                <ej-report-viewer id="reportviewer1" report-service-url="../Home" processing-mode="Remote" 
                    ReportPath="/Epic Reports/Client Statements/ClientInfo">

/// <summary>
        /// Report Initialization method that is triggered when report begins to process.
        /// </summary>
        /// <param name="reportOptions">The ReportViewer options.</param>
        public void OnInitReportOptions(ReportViewerOptions reportOptions)
            //Adds SSRS Server and Database Credentials here.
            reportOptions.ReportModel.ReportServerCredential = new System.Net.NetworkCredential("administrator@devinternal.local", "pass123");
            reportOptions.ReportModel.DataSourceCredentials.Add(new DataSourceCredentials("DB_Main_SQL", "dev1", "pass1"));

I recieve following error:
_reportLoaded:Sf_Exception - Make sure that you typed the report name and path are correctly, and the report exists in the specified directory

Can you please help me in right direction. 

Thank you.

5 Replies

MM Mageshyadav M Syncfusion Team March 13, 2019 02:41 AM

Hi Dheeraj, 
Thanks for your interest in Syncfusion components. 
We have validated the reported problem and we suspect that this issue will occur due to the usage of lower nuget version. So, could you please confirm the nuget version referred in your sample and also confirm whether you are using shared datasource in your report. 
Note: The ASP.NET Core Report Viewer supports to load only the SQL 2017 Reporting services API reports only due to access restrictions in other services. 
So, could you please share the required details with us and it will be helpful for us to determine the exact cause and provide the solution at the earliest. 

DR Dheeraj Rao March 13, 2019 07:20 AM

Forgot to mention, Yes using shared datasource.

DR Dheeraj Rao March 13, 2019 07:34 AM

Thank you for the reply.

ReportViewer version:

Reporting Services:

Using shared datasource.

appreciate your help in getting this resolved.


DR Dheeraj Rao March 13, 2019 10:50 AM

Upgraded to SSRS 2017, also updated the nuget package and changed the datasource in the report to custom data source. Now I get a new error "Unknown Error with Report Intialization"