Step 1: Create the Report

1 Go to Configuration → Reports

In the ReportBurster top menu, navigate to Configuration → Reports.

2 Click New

Click the New button to create a new report.

3 Enter the report name

Report Name: piv-sales-country-year-duckdb

4 Enable Report Generation

Under Capabilities, check the Report Generation checkbox.

This unlocks the Reporting menu entry where you'll configure the data source and pivot table.

5 Click Save

Save the new report configuration.

After saving, you should see a new "Reporting" entry in the left menu for your report. That's where we'll configure the DuckDB data source next.