Custom Report Generation

Report Generation using Database Views

Xano offers an easy way to share read-only views of your database tables. If the data is already presented in a readable format, you can quickly share it with others, even if they are not Xano users.

Database Views

Report Generation in the Function Stack

Sometimes, your data may not be in what would be considered a human readable format, and you need to make modifications to it, or present it in an alternative format.

Using APIs

If you need reports to be generated on demand, use an API endpoint for this functionality.

APIs

Using Background Tasks

If you want to generate reports based on a schedule, utilize a background task.

Background Tasks

Key Functions and Concepts

For most report generation, you'll want to ensure familiarity with the following concepts, depending on your specific needs.

Query All Records

For retrieving data from your database

For Each Loops

For iterating through retrieved records and transforming the data

Filters

Filters are typically used to apply modifications to pieces of data, such as math operations or comparing values.