var RegionName=""; RegionName=request.name RegionLength=RegionName.length write("
" + RegionName.substring(0, 1) + "
" + RegionName.substring(1, RegionLength) + " ");
R
egion
R
eport -
C
lick on
M
ap to
C
hange
write(WriteCustomSelections());
Customer Name
Current YTD
Prior YTD
Inc %
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("
" + cursor.CustName + "
"); write("
$" + NRound(cursor.SumCurrentSales,0) + "
"); write("
$" + NRound(cursor.SumPriorSales,0) + "
"); write("
" + NRound(cursor.Inc,2) + "%
"); write("
"); } cursor.close();