Hi @markp,
The query associated with that report, named “Birds Label - Frontside” (/specify/query/217/), does not have the ‘Preparation - Remarks’ field included, leaving the report unable to present the data from that field.
Even if you add the string ID to the report (e.g. $F{1,63-preparations.preparation.remarks}), if the data is not returned by the query associated with the report, the report runner will display null in its place.
If I add the preparation.remarks field to the query, it increases the number of returned results (from 23411 to 23532) since there are cases where more than one preparation is linked to a Collection Object.
To show only the remarks for the preparation while still leaving the preparations aggregated, you could prepare a table format and aggregation that only displays the “Remarks” field value for all preparations and select it explicitly in the query builder for this report only:
Query Builder in Specify 7
Some tables can be aggregated or formatted, outputting the structure specified in the schema once queried. If multiple formats or aggregations have been defined for one table, you may choose your preferred format/aggregation by clicking the(gear) icon. Otherwise, the default record formatter indicated in the schema will be used automatically. Learn more about record formatters here.
Would you like me to update this query directly? I can also help set up the table format and aggregation for this purpose!