R – bind subsonic object collection to Microsoft report (rdlc)

rdlcsubsonic

Has anyone been able to use a SubSonic generated collection as a "business object datasource" with Microsoft report (rdlc)? I have generated the SubSonic class code but for some reason the report datasource window is not seeing the class as a potential object collection datasource.

Is there something I need to do for this to work?

Thanks in advance…vsdotnetguy

Best Answer

I have loaded Reporting Service reports from business objects before (loaded via NHibernate -- which isn't exact but close enough for argument sake).

Couple of key points: 1. return your objects in List, even if you are only returning one object. 2. You want FLAT business objects. You might have to go thru a DTO transformation to get that. By flat, I mean the most complex property you can have in a business object is a string and a number (int, decimal, double). If you are expecting to grab a value like this: myObject.Customer.Name, forget it. Create a CustomerName property. 3. If you need data from multiple places try to break up your reports into subreports. You key off of the datasource key to figure out what data to return to the report.

I'll add more as I remember, it has been a few months since I've done this.

Related Solutions

RDLC: show child collection data without using subreports

I am not sure you can achieve what you're looking for. Either you must use subreports or by definition of master-child data you must use grouping.

I know this answer comes on late but this post still shows on search results and it has 1K views.

Hope this helps!

How to show images on an RDLC report

I don't know if this is the best solution, but I got it to work. It looks like the problem was in using System.Drawing.Image.

In my class, I created a new property called ImageByte of type byte[]. I didn't make a setter for ImageByte, but I made a getter that does the following:

MemoryStream ms = new MemoryStream();
Image.Save(ms, System.Drawing.Imaging.ImageFormat.Png);
return ms.ToArray();

I updated my report to have =Fields!ImageByte.Value for the Value and now everything appears to be working as expected :o)

Best Answer

Related Solutions

RDLC: show child collection data without using subreports

How to show images on an RDLC report

Related Topic