Tutorial: Writing a report

Prerequisites

• A basic understanding of SQL and XML

• A warehouse containing some records

• Latter parts of the tutorial assume you have a Drupal site ready to add report pages to

This tutorial guides you through the process of writing a custom database report for Indicia.

• 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