R
egional
R
eport -
C
lick on
M
ap to
C
hange
write(WriteCustomSelections())
Region
Current YTD
Prior YTD
Inc %
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("
" + cursor.Region + "
"); write("
$" + NRound(cursor.SumCurrentSales,0) + "
"); write("
$" + NRound(cursor.SumPriorSales,0) + "
"); write("
" + NRound(cursor.Inc,2) + "%
"); write("
"); } cursor.close();