Hi, all.
Overview:
Unable to show all the details that I want in a report.
Application description:
1. A table named "Party" to store all the persons or organizations information such as name, DOB, company registration no. and etc.
2. A table named "Party_Relationship" to store all kinds of relationship between parties. For instance, "Party 1" (Party_Id_From) may have relationship called "Directorship Relationship" with "Party 2" (Party_Id_To).
3. A table named "Signatory_Assignment" to assign signatory group to each bank account.
Problem description:
Now I try to produce a report called "Resolution to open an bank account" which require the company name, bank name, signatory names, director name on the same report.
I have declared "Signatory Relationship", "Directorship Relationship" and "Financial Institution Relationship" in table "Party_Relationship" as followed:
From Bank A to Company ABC as Financial Institution Relationship
From Bank A to Company DEF as Financial Institution Relationship
From Signatory A to Company ABC as Signatory Relationship
From Signatory B to Company ABC as Signatory Relationship
From Signatory C to Company DEF as Signatory Relationship
From Signatory D to Company DEF as Signatory Relationship
From Director A to Company ABC as Directorship Relationship
From Director B to Company ABC as Directorship Relationship
I am not able to display appropriate record selected in the report. I tried many combination of sets but no luck for me to get the report I want.
Please download the attachment below to review my problems in the report and hopefully you will share your wisdom with me to resolve this problem.
Thank you very much. :)
Overview:
Unable to show all the details that I want in a report.
Application description:
1. A table named "Party" to store all the persons or organizations information such as name, DOB, company registration no. and etc.
2. A table named "Party_Relationship" to store all kinds of relationship between parties. For instance, "Party 1" (Party_Id_From) may have relationship called "Directorship Relationship" with "Party 2" (Party_Id_To).
3. A table named "Signatory_Assignment" to assign signatory group to each bank account.
Problem description:
Now I try to produce a report called "Resolution to open an bank account" which require the company name, bank name, signatory names, director name on the same report.
I have declared "Signatory Relationship", "Directorship Relationship" and "Financial Institution Relationship" in table "Party_Relationship" as followed:
From Bank A to Company ABC as Financial Institution Relationship
From Bank A to Company DEF as Financial Institution Relationship
From Signatory A to Company ABC as Signatory Relationship
From Signatory B to Company ABC as Signatory Relationship
From Signatory C to Company DEF as Signatory Relationship
From Signatory D to Company DEF as Signatory Relationship
From Director A to Company ABC as Directorship Relationship
From Director B to Company ABC as Directorship Relationship
I am not able to display appropriate record selected in the report. I tried many combination of sets but no luck for me to get the report I want.
Please download the attachment below to review my problems in the report and hopefully you will share your wisdom with me to resolve this problem.
Thank you very much. :)
Comment