Regional Report - Click on Map to Change write(WriteCustomSelections()) cursor = database.cursor( "Select c.Region, "+ " SUM(s.CurrentSales) SumCurrentSales,"+ " SUM(s.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.Region "+ "order by c.region, Inc desc "); while( cursor.next() ) { write(""); write(" "); write(" "); write(" "); write(" "); write(""); } cursor.close();
Region Current YTD Prior YTD Inc %
" + cursor.Region + "$" + NRound(cursor.SumCurrentSales,0) + "$" + NRound(cursor.SumPriorSales,0) + "" + NRound(cursor.Inc,2) + "%