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.
Unfortunately, activation email could not send to your email. Please try again.

SSRS confusion

Thread ID:

Created:

Updated:

Platform:

Replies:

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

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 06:24 AM

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 10:53 AM

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 02:05 PM

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.

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.

;