Aggregate data to use in a Page Design block

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!

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.