Gap Analysis write(WriteCustomSelections())
cursor = database.cursor( "Select c.CustName, "+ " SUM(MATCHES(p.ProdGroupID,1,s.CurrentSales,0.00)) DeskSales, "+ " SUM(MATCHES(p.ProdGroupID,2,s.CurrentSales,0.00)) WUSales, "+ " SUM(MATCHES(p.ProdGroupID,3,s.CurrentSales,0.00)) ChairSales, "+ " SUM(MATCHES(p.ProdGroupID,4,s.CurrentSales,0.00)) FCSales "+ "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 c.CustName "); while( cursor.next() ) { write(""); write(" "); write(" "); write(" "); write(" "); write(" "); write(""); } cursor.close();
Customer Name Desks Wall
Units
Chairs File Cabinets
" + cursor.CustName + "$" + NRound(cursor.DeskSales,0) + "$" + NRound(cursor.WUSales,0) + "$" + NRound(cursor.ChairSales,0) + "$" + NRound(cursor.FCSales,0) + "