Tue, 13 Aug 2019 12:33:10 GMT
I have just downloaded the 'Medical History with Log' report, and when I run it, get the following error '(1054, "Unknown column 's.SpeciesName' in 'field list'")' SQL is not my thing, so how do I resolve this please?
Tue, 13 Aug 2019 13:52:19 GMT
change the offending reference to sp.SpeciesName. Or, you could delete and reinstall the report, I've fixed it in the repository
Tue, 13 Aug 2019 18:50:54 GMT
Found another error - "INNER JOIN species sp ON s.ID = a.SpeciesID" is wrong (line 4), should be "INNER JOIN species sp ON sp.ID = a.SpeciesID" I changed that and the report works.