Ranking Report write(WriteCustomSelections()) var Rank = 1; 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() ) { write(""); write(" "); write(" "); write(" "); write(" "); write(" "); write(""); Rank = parseInt(Rank,10) + 1; } cursor.close();
Rank Customer Name Current YTD Prior YTD % Inc
" + Rank + "" + cursor.CustName + "$" + NRound(cursor.SumCurrentSales,0) + "$" + NRound(cursor.SumPriorSales,0) + "" + NRound(cursor.Inc,2) + "%