# Fields from the preparation table displaying as null in jaspersoft reports despite data

**URL:** <https://speciforum.org/t/fields-from-the-preparation-table-displaying-as-null-in-jaspersoft-reports-despite-data/2555>\
**Category:** Get Help\
**Created:** [May 13, 2025, 11:05pm UTC](https://speciforum.org/t/fields-from-the-preparation-table-displaying-as-null-in-jaspersoft-reports-despite-data/2555 "2025-05-13T23:05:23Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![Grant](https://yyz1.discourse-cdn.com/flex029/user_avatar/speciforum.org/grant/32/4255_2.png) [@Grant](https://speciforum.org/u/Grant)\
**Post date:** [June 5, 2025, 3:09am UTC](https://speciforum.org/t/fields-from-the-preparation-table-displaying-as-null-in-jaspersoft-reports-despite-data/2555/5 "2025-06-05T03:09:59Z")

</div>

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](https://speciforum.org/t/editing-table-formats-and-aggregations-in-specify-7/1558) 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](https://speciforum.org/t/query-builder-in-specify-7/289#:~:text=Some%20tables%20can,formatters%20here)**  
> 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_: (gear) icon. Otherwise, the default record formatter indicated in the schema will be used automatically. Learn more about record formatters [here](https://speciforum.org/t/editing-table-formats-and-aggregations-in-specify-7/1558).
> 
> ![image](https://canada1.discourse-cdn.com/flex029/uploads/specifysoftware/original/2X/1/10b5ef48bf93f642260e0f551c49c51aff51f62b.png)

Would you like me to update this query directly? I can also help set up the table format and aggregation for this purpose!

---

_[View the full topic](https://speciforum.org/t/fields-from-the-preparation-table-displaying-as-null-in-jaspersoft-reports-despite-data/2555)._