I have multiple dataset for a report. First dataset work as a Page header. Rest of the dataset has a one-to-many rlationship.  Take EmployeeDetails for example. EmployeeDetails has only one Row. For each employeeDetails there are two rows in PaymentDetails dataset. In addition to this, for each PaymentDetails there are multiple rows in TaxInformation dataset.  There are two common parameter for all the dataset.

How do I display this in a SSRS/RDLC report? Please suggest.

Hi,

If you would like to show almost every field of each datasets in a single report, it is better to use subreports. Assuming we create Report3 to show the records of TaxInformation dataset, Report2 to show the records of PaymentDetails dataset, and Report1 to show the records of EmplyeeDetails. Then, in Report2, we can add a subreport to show Report1 with passing PaymentId as the parameter; in Report1, we need to add a subreport to show Report2 with passing EmployeeId as the parameter. 

References:

• Subreports
• How to: Add a Subreport and Parameters

Regards,
Mike Yin

If you have any feedback on our support, please click here