Base report stoped working, no message

[goedible]

This base report stopped working and there is no error message.

I can see in edit mode that everything seems to still be in order.

When I open it I get a blank page?

The LANdpLAN database can be downloaded here: https://www.dropbox.com/scl/fo/i9x73baljkyejbnn4ch7g/ABTaiRZ930FZ6-FVVGcWriU?rlkey=lo3ybfyw9yl9exdadea7o4m3l&st=m3sec38r&dl=0

Does it work on your computer? Any ideas why it doesn’t work on mine? LO 7.2.7.2 on linux lite.

plot_list_and_medicinal_uses still works. They are almost identical except they use different queries. I duplicated plot_list_and_medicinal_uses and changed the query to edible uses. It stopped working? Something about that query is making the report unable to load???

Thanks for help

[RobertG]

First have a look at the query you use for this report.
You are using an external HSQLDB, so it couldn’t be tested by many people with the Base file.

[goedible]

yes the query was not returning any results. I removed one of the filters so that I got results and then everything worked again. Thank you.