FusionCharts Sample Template for Demo Application

SELECT DISTINCT YEAR(OrderDate) As Year FROM Orders ORDER BY 1 SELECT TOP 5 Country, SUM(ExtendedPrice) As Total, COUNT(DISTINCT OrderID) As orderNumber FROM Invoices WHERE YEAR(OrderDate)= #curYear# GROUP BY Country ORDER BY SUM(ExtendedPrice) DESC "> "> ">

FusionChart Demo Application

Please select the year for which you want to see the reports: