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. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Show SSRS Reports on SSRS report server using ReportViewer

Thread ID:

Created:

Updated:

Platform:

Replies:

143289 Mar 13,2019 03:37 AM UTC Mar 14,2019 09:15 AM UTC ASP.NET Core 5
loading
Tags: ReportViewer
Dheeraj Rao
Asked On March 13, 2019 03:37 AM UTC

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("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.
Dheeraj


Mageshyadav M [Syncfusion]
Replied On March 13, 2019 07:41 AM UTC

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
Replied On March 13, 2019 12:20 PM UTC

Forgot to mention, Yes using shared datasource.



Dheeraj Rao
Replied On March 13, 2019 12:34 PM UTC

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
Replied On March 13, 2019 03:50 PM UTC

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"