I'd like to create a separate report for each different "ProjectNumber". On the report I'd like to create of list of each "Address" with the same "ProjectNumber".
ProjectNumber Address 1000 42 Abc Dr. 1000 32 Def Rd. 1000 22 Ghi St. 1001 77 Xyz Dr. 1001 66 Uvw Rd.
So for an example, using the above table, I would like to generate 2 reports. They would show the project number then list all associated addresses.
Report1 ProjectNumber: 1000 Addresses: 42 Abc Dr. 32 Def Rd. 22 Ghi St.
Report2 ProjectNumber: 1001 Addresses: 77 Xyz Dr. 66 Uvw Rd.
I am unsure how to do this. Could someone please point me in the right direction?
Thank you.