Hi,
I am creating a Report Model Project in Visual Studio 2005. In the data source view, I am adding the entities that represent subsets of the data of my tables. For some tables, there is a 1-many relationship. For example, Entity A has a Primary Key of A_ID, and links to Entity B through this field which is present in both A and B. For one row in Entity A, there may be many linking rows in Entity B. So, I have dragged the A_ID field from Entity B to Entity A. I save the data source view and create the Report Model. I then deploy this to the server and browse to http://myserver/reports I click on the "Report Builder" icon and select the report model just created from the GUI that is presented. In the left (explorer) pane I am shown the Entities created. Now, I would like to create a report, with a subreport (or list as is otherwise known in Reporting Services). So, for example, I have the fields for Entity A, and in one cell, I want to place all the fields (for all linked rows through A_ID) of Entity B. Can this be done?
Thanks in advance, Tim