Perfect! Now let's configure the data source.

Step 2: Configure the SQL Data Source

In ReportBurster's top menu, go to:

1. Configuration → Sales by Customer Summary
2. On the left side, click on Report Generation

Now configure these settings:

2.1. Choose Database Connection

• Find Data Source section
• From the dropdown, select Northwind (our SQLite connection)

2.2. Configure SQL Query

• Look for SQL Query text area
• Paste this query:

SELECT
    c.CustomerID,
    c.CompanyName,
    c.ContactName,
    c.Country,
    c.City,
    COUNT(DISTINCT o.OrderID) as TotalOrders,
    SUM(od.Quantity * od.UnitPrice * (1 - od.Discount)) as TotalRevenue,
    SUM(od.Quantity * od.UnitPrice * (1 - od.Discount)) / COUNT(DISTINCT o.OrderID) as AvgOrderValue,
    SUM(o.Freight) as TotalFreight,
    MIN(o.OrderDate) as FirstOrderDate,
    MAX(o.OrderDate) as LastOrderDate
FROM Customers c
LEFT JOIN Orders o ON c.CustomerID = o.CustomerID
LEFT JOIN "Order Details" od ON o.OrderID = od.OrderID
GROUP BY c.CustomerID
ORDER BY TotalRevenue DESC

2.3. Test the Query

• Click Test (or "Run Query") button
• You should see a preview of the customer summary data

What the query does:

• Joins 3 tables: Customers → Orders → Order Details
• Calculates: order count, total revenue, average order value, freight costs, date range
• Groups by customer (one row per customer)
• Orders by highest revenue first (so your top customers appear at the top)