Hello Adrien,
I've got several reports that bring together multiple tables and aggregate
repeatable fields (such as Extent) using SQL. My SQL is not very pretty, but it
might be helpful for you.
Below is the SQL I use to generate a list of Accession records with aggregated
Extents and Agents
Dear Colleagues,
We are considering creating three reports that are essentially data dumps of
various record types in a repository, e.g. all resource record level data; all
accession record level data; and all archival object level data associated with
a single resource record. You can see our