Developing Reports

• Tutorial: Writing a report
  • Our baseline query
  • Converting the query to a report
  • Controlling the column output
  • Using the advanced pagination facility
  • Setting up column filtering
  • Integrating with website permissions
  • Parameterising the report
    • Standard parameters
  • Integrating with custom attributes
  • Images and maps
    • Including photos in report grids
    • Outputting your records onto a map
  • Aggregate functions in reports
• Example queries for report writers
• Report File Format
  • Element <report>
    • Attributes of <report>
    • Child elements of <report>
    • Example of <report>
  • Element <query>
    • Attributes of <query>
    • Replacements Tokens
    • Example of <query>
  • Element <count_query>
  • Element <order_bys>
    • Child elements of <order_bys>
  • Element <order_by>
  • Element <field_sql>
    • Example of <field_sql>
  • Element <params>
    • Child elements of <params>
  • Element <param>
    • Attributes of <param>
    • More information on the idlist datatype
    • Parameters which require additional filters in the WHERE section
    • Parameters which require additional joins
    • Optional custom attributes
  • Element <columns>
    • Child elements of <columns>
  • Element <column>
    • Attributes of <column>
    • Declaring SQL for each column
  • Element <vagueDate>
  • Standard Report Parameters
• Standard parameters in reports
• Occurrence report standard parameters