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 : November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

SSRS confusion

Thread ID:

Created:

Updated:

Platform:

Replies:

117092 Aug 8,2014 03:32 PM UTC Sep 1,2014 06:05 PM UTC ASP.NET MVC (Classic) 3
loading
Tags: ReportViewer
Rob Keiser
Asked On August 8, 2014 03:32 PM UTC

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?


Sundaraj Muthunarayanan [Syncfusion]
Replied On 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.


Krittikorn Deeraksa
Replied On 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

Sundaraj Muthunarayanan [Syncfusion]
Replied On 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.

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;