R
anking
G
raph (Sales % Increase)
write(WriteCustomSelections())
var Rank = "0"; cursor = database.cursor( "Select c.CustName, "+ " SUM(CurrentSales) SumCurrentSales, "+ " SUM(PriorSales) SumPriorsales, "+ " (SUM(CurrentSales) / SUM(PriorSales)-1.0)*100 Inc "+ "from SalesInformation s, Customer c, Product p "+ "where c.CustID = s.CustID "+ "and s.ProdID = p.ProdID "+ BuildQuery(client.CustID, client.ProdID, client.CustGroupID, client.ProdGroupID)+ "group by c.CustName "+ "order by Inc Desc"); while( cursor.next() ) { Rank = parseInt(Rank,10) + 1; write("
\n"); write("
\n"); } cursor.close();