QUICK REPORTS (<Where> tag)

Quick reports allow access to XML reports by right clicking when in a data screen. Quick reports use the <Where> tag to determine the source of the parameter. There are two attributes for the <Where> tag. While learning XML reports just use the default where tag.  <Where keytype="Default"> as in the following examples.

keytype 

• Name
• Location
• Taxon
• Biotope
• Admin
• Survey
• Event
• Sample
• Taxon_Occurrence
• Biotope_Occurrence
• SamplesinPolygon *
• LocationsinPolygon  *
• Default

If the keytype is set to Default then the WHERE clause it contains is run from the main report menu. If the keytype is anything else then the report can be run from the data screen using the appropriate key for the record(s) actually selected on the screen. The Quick reports are accessed by right clicking when in a data screen which has a Quick report. The available reports are displayed and can be selected. The following example illustrates the use of the <Where> tag in a simple situation. From the main report menu the 'default' WHERE clause is used (in green), but run as a quick report from Location the 'Location'  WHERE clause is used. The %s returns the Location_Key from the Location table.   

<?xml version='1.0' ?>

 <!--  Example Report
     XML Report by Mike Weideli of Littlefield Consultancy

     Version 1 14 May  2008 
-->
<CustomReport  title="Ex1 ExampleReport"  menupath="Example reports" 
description="" >
<SQL>
    SELECT Item_Name   FROM  Location_Name
    <Where keytype="Default">
          WHERE

         <Condition field= "Location_key" operator="equal" type="Location" entrycount="-1"  name="Location" />       
     </Where>
     <Where keytype="Location">
          WHERE 

        Location_Key = ' %s'

</SQL>
</CustomReport>

For more information on using the <Where> tag see Advanced Where .

NEXT PAGE