Re: Unable to use report
Can someone please point out the, presumably blindingly obvious, error that I cant see in the following report file, that prevents it from loading into Recorder?
<?xml version="1.0" ?>
- <!-- GB Test 1
Locations without gridsquares
11 August 2011
Menupath
-->
- <CustomReport menupath="System reports\XML Examples" title="GB1-Loc grid" description="GB test 1 - locations without gridsquares">
<SQL>SELECT L.LOCATION_KEY, LN.ITEM_NAME, LN.PREFERRED, COUNT(GS.SPATIAL_REF) AS Expr1, L.SPATIAL_REF FROM LOCATION L LEFT OUTER JOIN LOCATION_NAME LN ON L.LOCATION_KEY = LN.LOCATION_KEY LEFT OUTER JOIN GRID_SQUARE GS ON L.LOCATION_KEY = GS.LOCATION_KEY WHERE (LOCATION_NAME.PREFERRED = 1) GROUP BY L.LOCATION_KEY, LN.ITEM_NAME, LN.PREFERRED, L.SPATIAL_REF HAVING (COUNT(GS.SPATIAL_REF) = 0) ORDER BY ITEM_NAME</SQL>
</CustomReport>
Biological Survey Data Manager
National Trust