C# MS RDLC Report Designer SQL Query -- 2

Job ID: 36131967

Budget: $30 – $250 CAD

DB Diagram Attached.
Sample Data and Report design attached.

Client needs a RDLC report with data from the following Tables:
Customer, Invoice, Customer Payments

The report is an Account Summary Statement.
Report needs to be designed as shown in uploaded file.