Skip to navigation

Write a report with SQL

  1. Open Reports and select New Report → Write SQL yourself. Pro opens an Untitled Report with a starter table.

  2. Select Edit manually, enter a title, and select Apply.

  3. On the starter table, select Edit table and enter a read-only SELECT query against an available reporting view. For a small preview of animal care providers, start with:

    SELECT animal_care_provider_id, animal_care_provider_name
    FROM report_animal_care_providers_v
    ORDER BY animal_care_provider_name
    LIMIT 5;
  4. Select Apply, then Preview changes. Check the returned rows and resolve any validation messages.

  5. Select Save to keep your changes.

If a view is unavailable, check the reporting schema shown in the editor and your workspace’s data access. See view and export report results for the next step.