C# MS RDLC Report Designer SQL Query

Job ID: 35088841

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.