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
Starting in 2019, the Reporting control is no longer included in Essential Studio. If you're experiencing issues with the Syncfusion Reporting Platform, Report Viewer, Report Designer, or Report Writer, we recommend migrating to Bold Reports, our dedicated reporting platform.

Bold Reports offers a comprehensive suite of tools and features for all your reporting needs, and we will help you make a smooth transition from the discontinued control. Our support team at https://support.boldreports.com/ is here to assist you with any questions or difficulties you may encounter during the migration process.

We thank you for choosing Syncfusion and appreciate your understanding.

Show SSRS Reports on SSRS report server using ReportViewer

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


5 Replies

MM Mageshyadav M Syncfusion Team 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 



DR Dheeraj Rao March 13, 2019 12:20 PM UTC

Forgot to mention, Yes using shared datasource.




DR Dheeraj Rao 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 



DR Dheeraj Rao 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"







MS Mahendran Shanmugam Syncfusion Team March 14, 2019 09:15 AM UTC

Hi Dheeraj, 

We have checked the mentioned issue with our SSRS Report Viewer sample and reports are rendering properly from our Local SSRS report server in our Report Viewer application. So we have prepared the sample for your reference and it can be downloaded from below location. Could you please confirm whether the sample is working or not at your end. 

Note: In above sample we have used in our local SSRS server. So could you please change your SSRS URL, Credentials and report path. 

Regards, 
Mahendran S. 


Loader.
Live Chat Icon For mobile
Up arrow icon