Report viewer create report with Parent Child tables

Question

I am trying to create a Report viewer report using VS Report designer. I have done a lot of reading that indicated a report could be created using related tables in a dataset. There are numerous tutorials on how to create simple reports but I have yet to find one that shows how one would create a report from two tables. I need to display Parent fields then a Child fields in a table below that. Kind of like the mockup below.

Answer 1

Hi @William Burke ,
Inner/Left/Right/Full Join two tables using Pkg_Id as key：

SELECT * FROM dbo.Package  
inner join dbo.Component  
on Package.Pkg_Id=Component.PC_Pkg_Id;  

Then select Table, Matrix, or List as required. see more: Tables, matrices, and lists in paginated reports (Report Builder).
Best Regards,
Joy

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.