Show SSRS Reports on SSRS report server using ReportViewer

[Dheeraj Rao]

Hello,

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:

index.cshtml:

                <ej-report-viewer id="reportviewer1" report-service-url="../Home" processing-mode="Remote" 

                    ReportServerUrl="http://dev-sql2016/ReportServer" 

                    ReportPath="/Epic Reports/Client Statements/ClientInfo">

                </ej-report-viewer>

HomeController.cs:

/// <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("[e-mail]", "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.

Dheeraj

[Mageshyadav M]

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. 

 

Regards, 

Mageshyadav.M 

[Dheeraj Rao]

Forgot to mention, Yes using shared datasource.

[Dheeraj Rao]

Thank you for the reply.

ReportViewer version:16.3.0.21

Reporting Services:

Using shared datasource.

appreciate your help in getting this resolved.

Dheeraj 

[Dheeraj Rao]

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"