var RegionName=""; RegionName=request.name RegionLength=RegionName.length write("" + RegionName.substring(0, 1) + "" + RegionName.substring(1, RegionLength) + " "); Region Report - Click on Map to Change write(WriteCustomSelections()); cursor = database.cursor( "Select c.CustName, "+ " 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)+ "and c.region = " + request.region + "group by c.CustName "+ "order by Inc desc "); while( cursor.next() ) { write(""); write(" "); write(" "); write(" "); write(" "); write(""); } cursor.close();
Customer Name Current YTD Prior YTD Inc %
" + cursor.CustName + "$" + NRound(cursor.SumCurrentSales,0) + "$" + NRound(cursor.SumPriorSales,0) + "" + NRound(cursor.Inc,2) + "%