XanoReport 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 View
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.