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.

SSRS confusion

I've tried to modify the sample app to call our SSRS server but when I do I always get the same error. The viewer is displayed, the spinner starts and then this:

Sf_exception - In Load callback getting following exception:System.InvalidOperationException: Sequence contains no elements at Syncfusion.RDL.Data.ReportModel.ProcessReport() at Syncfusion.ReportViewer.Mvc.ReportViewerLayoutModel.LoadReport() at Syncfusion.ReportViewer.Mvc.ReportViewerHtmlActionResult.ExecuteResult(ControllerContext context)


I cannot find any reference to this error - in fact the amount of documentation on how to setup the reportviwer to talk with an SSRS server is, to put it mildly, lacking.

So what am I doing wrong and how do I fix it?


3 Replies

SM Sundaraj Muthunarayanan Syncfusion Team August 11, 2014 10:24 AM UTC

Hi Rob,

Thanks for the using Syncfusion products.

We regret to let you know that we are unable to reproduce the reported issue. However, We have created a simple “ASP.NET MVC (Classic)” sample to show SSRS report in ReportViewer and It can be downloaded from the below link. We hope it will be helpful for your concern.

Sample Location:

http://www.syncfusion.com/downloads/support/directtrac/124921/ssrs_report512479889.zip

Please try this sample and let us know if it meets your requirement. Else, could you please provide us a simple sample which replicates the reported issue. which will help us to provide a solution earlier.  

Please let us know if any concerns.

Regards,

Sundaraj M.



KD Krittikorn Deeraksa August 31, 2014 02:53 PM UTC

please explain these 3 line.

cred.Name = "AdventureWorks";
cred.UserId = "ssrs1";
cred.Password = "RDLReport1";

What is userID & Passwords , SSRS use Windows Authentication ?
thk


SM Sundaraj Muthunarayanan Syncfusion Team September 1, 2014 06:05 PM UTC

Hi Krittikorn, 

Thanks for the update.

If you are using SQL Authentication for connecting data source, you have to give credentials that database name, user id, and password. Else, if you are using Windows Authentication for connecting data source you no need to give credential details.

Please let us know if you have any doubts.

Regards,
Sundaraj M.

Loader.
Live Chat Icon For mobile
Up arrow icon