Loading table of contents...
XML Reports Help
Introduction
About XML Reports
Getting Started Guide
What you need
ReportTitles and File Names
Basic Structure
SQL Statements
Simple Filters
Quick Reports
Columns
Advanced Columns
Sort Order
Extrenal Files (Csv and Filter)
Using CSV Files
Usiing Filter Files
Filter File Format
Filters (<Condition> tag)
Text
Number
Date
VagueDate
TrueFalse
Location/Name/Taxon
Bounding Box
Grid Square Range
Spatial Reference
Location in Polygon
Samples in Polygon
Choose option
CSV Files
Special attributes
Grouping Conditions
Subsititute in SQL
Rucksacks
CurrentUserID
Advanced Techniques
Variables
Where tag (Advanced)
Temporary Tables
UDF's and Parameters
DMAP
SQL Queries - HowTo
Returning Records
Taxon Information
Location Hierarchy
Synonyms
Aggregate Functions
Survey Tags
T-SQL Functions
Using UDF's
Adding Sequential Number
UNION Statement
PIVOT (Crosstab)
Designations (Status)
Measurements
Subqueries
Sub Query Examples
Joins
Family
Additional Information
MSAccess to T-SQL
XML Structure
Error Messages
XML Reserved Chars.
Problems
Reserved Words
Adding Comments
Data Structure
ADDRESS
ADMIN_AREA
ADMIN_ AREA_ SOURCES
ADMIN_ BOUNDARY
ADMIN_RELATION
ADMIN_TYPE
BIOTOPE
BIOTOPE_ CLASSIFICATION
BIOTOPE_CLASSIFICATION_ TYPE
BIOTOPE_CLASSIFICATION_VERSION
BIOTOPE_ DESIGNATION
BIOTOPE_ DESIGNATION_ TYPE.
BIOTOPE_ FACT
BIOTOPE_DETERMINATION
BIOTOPE_LIST_ITEM
BIOTOPE_OCCURRENCE
BIOTOPE_OCCURRENCE_DATA
BIOTOPE_OCCURRENCE_SOURCES
BIOTOPE_RELATION
BIOTOPE_RELATION_JOIN
BIOTOPE_RELATION_ADMIN_AREA
BIOTOPE_RELATION_JOIN
BIOTOPE_SOURCES
COMMUNICATION
CONCEPT
CONTACT_NUMBER
DAMAGE_OCCURRENCE
DETERMINATION_TYPE
DETERMINER_ROLE
GRID_SQUARE
INDEX_TAXON_DESIGNATION
INDEX_TAXON_GROUP
INDEX_TAXON_HIERARCHY
INDEX_TAXON_NAME
INDEX_TAXON_SYNONYM
INDIVIDUAL
JOURNAL
LAND_PARCEL
LOCATION
LOCATION_ADMIN_AREAS
LOCATION_BOUNDARY
LOCATION_DATA
LOCATION_DESIGNATION
LOCATION_FEATURE
LOCATION_FEATURE_GRADING
LOCATION_FEATURE_SOURCES
LOCATION_FEATURE_TYPE
LOCATION_FEATURE_TYPE
LOCATION_NAME
LOCATION_RELATION
LOCATION_SOURCES
LOCATION_TYPE
LOCATION_USE
MANAGEMENT_AIM
MEASUREMENT_QUALIFIER
MEASUREMENT_TYPE
MEASUREMENT_UNIT
Measurement_Unit_Value
NAME
NAME_RELATION
NAME_SOURCES
NAMESERVER
ORGANISATION
ORGANISATION_TYPE
Organisation_Department
ORGANISM
POTENTIAL_THREAT
RECORD_TYPE
RECORDER_ROLE
REFERENCE
REFERENCE_AUTHOR
REFERENCE_EDITOR
REFERENCE KEYWORD
REFERENCE_NUMBER
RELATIONSHIP_TYPE
SAMPLE
SAMPLE_ADMIN_AREAS
SAMPLE_DATA
SAMPLE_RECORDER
SAMPLE_RELATION
SAMPLE_SOURCES
SAMPLE_TYPE
SETTING
SITE_STATUS
SOURCE
SOURCE_FILE
SPECIMEN
SPECIMEN_TYPE
SUBSTRATE
SURVEY
SURVEY_EVENT
SURVEY_EVENT_OWNER
SURVEY_EVENT_OWNER_TYPE
SURVEY_EVENT_RECORDER
SURVEY_EVENT_SOURCES
SURVEY_MEDIA
SURVEY_SOURCES
SURVEY_STATUS
Survey_Tag
SURVEY_TYPE
TAXON
TAXON_BIOTOPE_ASSOCIATION
TAXON_COMMON_NAME
TAXON_DESIGNATION
TAXON_DESIGNATION_SET
TAXON_DESIGNATION_SET_ITEM
TAXON_DESIGNATION_TYPE
TAXON_DETERMINATION
TAXON_FACT
TAXON_GROUP
TAXON_LIST
TAXON_LIST_ITEM
TAXON_LIST_TYPE
TAXON_LIST_VERSION
TAXON_OCCURRENCE
TAXON_OCCURRENCE_EXT_REF
TAXON_NAME_TYPE
TAXON_OCCURRENCE
TAXON_OCCURRENCE_DATA
TAXON_OCCURRENCE_RELATION
TAXON_OCCURRENCE_SOURCES
TAXON_RANK
TAXON_SOURCES
TAXON_TAXON_ASSOCIATION
TAXON_USER_NAME
TAXON_VERSION
TAXON_VERSION_RELATION
TENURE
TENURE_TYPE
TERM
THREAT_TYPE
USER_SURVEY_RESTRICTION
Tag Summary
CustomReport
CSVTables
CSVTable
CSVColumn
CSVFile
externalfilterfiles
externalfilterfile
SQL
Where
Condition
Option
Orderby
OutputTableOrderBy
Columns
Column
Change Control
XML Batch Updates Help
Introduction
About XML Batch Updates
Adding New records
Notes
XML Reports Help
