It is possible to include satus in the report. There is a User defined function LCFormatTaxonDesKind6 which takes various paramters and returns the Designations. You can see this in use in some of the other JNCC reports which report on Status. The problem is that this function slows down the reports to the point where large ones just take too long to run. You also have limited control over which status type are included in the output. If your circles do not have too many records in them then using this function might be an answer.
Take a copy of the circle report and rename it (convention would be to replace JNCC with your site id). Open the copy in Notepad then change the Titile of the report at the top so that you can identify it (title="Ci1 Records (inc. Status) within circle " ) and also the menu path (say to menupath="My Reports\Circle Reports")
. Substitute the first part of the Select statement with the following
SELECT tOcc.taxon_occurrence_key,S.Spatial_ref, LN.ITEM_NAME, S.LOCATION_NAME,
s.vague_date_start,s.vague_date_end,s.vague_date_type,
dbo.FormatEventRecorders(s.sample_key) as Recorders,dbo.FormatIndividual(I.title,I.Initials,I.Forename,I.Surname) as Determiner,
ITN.Preferred_name ,ITN.Authority,ITN.Common_Name,ITN2.Actual_Name, dbo.LCFormatAbundanceData(TOCC.Taxon_Occurrence_Key) as Abundance,TG.Taxon_group_name as TaxonGroup,
dbo.LCFormatTaxonDesKind6(ITN.taxon_List_Item_Key,0,'0','NHMSYS0020424779','0') as Kind1
You will also need to add a new column at the bottom (Kind1).
<Column name="Kind1" visible= "true" position = "13" caption = "Status" width = "300" />
Save the changes.
You can control to some extent what is included by altering the parameters in the UDF.
Mike
Mike Weideli