I need to produce a formatted PDF for records in a table. I am using the Page Designer block, but I having some trouble aggregating the data so it appears in the required format. Here are the details:
Tables
• People
• Projects
• Assignments (People assigned to Projects)
o There may be multiple records of People-Project combinations which need to be aggregated and ultimately placed on a Page Designer block
o People-Project combinations may have different dates or other variables
Example Data
• People
o Bob
o Susan
• Projects
o ABCDE
o XYZ
• Assignments – separate records below
o ABCDE-Bob (Oct. 1-Nov. 15)
o ABCDE-Bob (Jan. 3 – March 10)
o ABCDE-Bob (March 22 – April 30)
o XYZ-Bob (Nov 21 – Dec 15)
o XYZ-Susan (Nov 21 – March 1)
Problem
Need to combine People-Project combination records together, maybe within Assignments, maybe within the People table where they are linked. I want to create a Page Designer block that will show each of the following as a separate record/page:
ABCDE – BOB
• Record 1 (Oct. 1-Nov. 15)
• Record 2 (Jan. 3 – March 10)
• Record 3 (March 22 – April 30
XYZ – BOB
• Record 1 (Nov 21 – Dec 15)
XYZ-SUSAN
• Record 1 (Nov 21 – March 1)
I hope this adequately explains my issue.
Thanks!
