Building Reports

Create reports and data exports

Overview

qqq provides built-in reporting capabilities including data exports, scheduled reports, and custom report definitions.

Export Formats

Supported export formats:

CSV - Comma-separated values

Excel - XLSX spreadsheets

JSON - Structured data

PDF - Formatted documents (with qBit)

Table Exports

Every table supports exports from the list view. Users can:

1. Apply filters to narrow data

2. Select columns to include

3. Choose export format

4. Download or schedule delivery

Custom Reports

Define custom reports with specific queries and formatting:

Java

@QReportMetaData(name = "monthlySales")
public class MonthlySalesReport implements ReportMetaDataProducer {
    @Override
    public QReportMetaData produce(QInstance qInstance) {
        return new QReportMetaData()
            .withName("monthlySales")
            .withLabel("Monthly Sales Report")
            .withDataSources(List.of(
                new QReportDataSource()
                    .withName("sales")
                    .withSourceTable("order")
                    .withQueryFilter(buildFilter())
            ));
    }
}

Scheduled Reports

Automate report delivery:

Email delivery on schedule

SFTP upload

S3 storage

Webhook notification

Next Steps

Testing - Test reports

Deployment - Deploy to production