Thanks for responding.

I created the report in the Silverlight application. My DomainServices are located in my RIA services web project from which I obtain data for my silverlight application. When loading the report, it does not recognize that there are any Domain services on my server.

It is quite frustrating because when stepping through the (quite impressively detailed) walkthrough provided, it still gives me the same issue. One thing I noticed though was that when stepping through the walkthrough on the example code provided with the reporting download, I got it to recognize a custom domain service. That was however on the example code and not in my project.

I then decided to import the example reporting class project into my solution, reference it, create a domainservice in my webserver, compiled and still it did not identify any of the domain services on the webserver :)

I can connect to the domain services from my silverlight application, however the documentation says that is not the right way to do it.

The reason I want to use it with client side processing is because I already have the infrastructure set up for RIA services and I my domain services dynamically switch to different databases on instanstantiation. I also want the client to take the load (note that in an attempt to just get it to work I am using stock standard domain services, connected to the standard northwind database).

My alternative is to give up trying to get it to work with Ria services and put it on the server. If I have to do that then I have to work out how to switch database connection strings.

Hopefully you can help me.

Jody

Hi Jody,

RIA Services it's a core scenario for us, it should work.

We are obviously missing something but we can't figure out what. Would it be possible for you to send us a project where it does not work, so we can try debugging it? You can attach it to the reply, or email it directly to me (aaguiar at infragistics.com).

Thanks,

Andres

Hi Mark,

We'll work on it and include it in the examples that ship with the product. As soon as we have it we'll let you know.

Thanks,

Andres

Would a step-by-step and small example project be possible?  I'm having similar difficulties in getting SProcs to work.

Thanks,
Mark

Thanks Andres, it took me a while to get it right but in essence what I had to do was to create a separate entity class that maps the complex return type of the stored procedure one to one.

The entity class was then exposed by the domain service and available for using as data source for the report. It is important to note that the entity class must have a [Key] attribute, o/w the SL application containing the report will not compile.

I am listing my entity class and the domain service method fo calling the stored procedure for reference.

Thanks again for your help.

Regina

namespace ReportingSLApp.Web

{

    public class ActivitiesList

    {

        public string Type { get; set; }

        ..

        public string Assigned_To  { get; set; }

        [Key]       

        public System.DateTime Added { get; set; }

        ...

        public string Status { get; set; }

    }

public IQueryable<ActivitiesList> GetActivitiesList()

{

            var query = from rpal in this.DataContext.ReportProc_ActivitiesList(0, 0, "", "", null, null, null, null)

                        select new ActivitiesList

                        {

                            Added = rpal.Added,

                            ...

                            Assigned_To = rpal.Assigned_To,

                            ...

                            Status = rpal.Status,

                            ...

                            Type = rpal.Type,

                            ...

                        };

            return query.AsQueryable();

}

Hi Regina,

Could you send it to my personal email address? aaguiar at infragistics.com.

The datatype you get in the SL project should be something like <Namespace>.<DomainServiceName>, and there there should be a property for each entity in the model.

Thanks,

Andres