Hello,
I'm learning the XtraReports system for a ASP.NET web site. I use Entity Framework 6 for my SQL Server datastore and have been having trouble building a report that uses multiple entities in the DataSource. I set the DataSource to the EF component but leave the DataMember blank as I'm not tying to a single entity in the model which has 23 entities (tables). I dragged Entity1.Field1 to my Detail section and ran the report, the data that appeared was not correct and I'm not sure why, I have no idea what it was showing. If I set the DataMember on the report to Entity1 and then use Field1 it will show correctly.
Now what I need to do is build a report such that the header has fields from Entity12 and the detail has fields from Entity1, Entity2 etc. Is this possible? How can I build a report that is not tied to a single EF entity assigned in the DataMember property of the report? I also don't want to have to create a new EF component for each entity, I can also use a SQL Server datasource if needed and that's fine and would like to know how to do the same using that as a data source, building a single report from multiple tables.
Thank you