SSRS confusion

[Rob Keiser]

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]

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]

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]

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.