Excellent detective work! You found it — the Report Generation capability needs to be enabled first. That's a great learning moment!

Now Let's Configure the SQL Data Source

In the ReportBurster top menu, go to:

1. Reporting → Sales by Customer Summary (you should now see this in the Reporting menu)

Now configure the SQL query:

2.1. Select Data Source

• Look for Connection or Data Source dropdown
• Select Northwind

2.2. Paste the SQL Query

• Find the SQL Query text area
• Paste this:

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 table with customer data