Write a report with SQL
-
Open Reports and select New Report → Write SQL yourself. Pro opens an Untitled Report with a starter table.
-
Select Edit manually, enter a title, and select Apply.
-
On the starter table, select Edit table and enter a read-only
SELECTquery against an available reporting view. For a small preview of animal care providers, start with: -
Select Apply, then Preview changes. Check the returned rows and resolve any validation messages.
-
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.