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
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.
( " - includepartialoverlap Either 'no' to exclude partial overlap or 'yes' to include. Applies only to SamplesinPolygon and LocationsinPolygon.)
<?xml version='1.0' ?>
XML Report by Mike Weideli of Littlefield Consultancy
Version 1 14 May
<CustomReport title="Ex1 ExampleReport" menupath="Example reports"
SELECT Item_Name FROM Location_Name
"Location_key" operator="equal" type="Location" entrycount="-1"
Location_Key = ' %s'
For more information on using the <Where> tag see Advanced Where .
Either 'No' to exclude partial overlap or 'Yes' to include. Applies only to SamplesinPolygon and LocationsinPolygon.