");
for(i=0;i < cursor.columns(); i++)
{
if (cursor.columnName(i)=="custname")
write(" " + cursor[i] + " | ");
if (cursor.columnName(i)=="region")
write(" " + cursor[i] + " | ");
if (cursor.columnName(i)=="address1")
write(" " + cursor[i] + " | ");
if (cursor.columnName(i)=="city")
write(" " + cursor[i] + " | ");
if (cursor.columnName(i)=="state")
write(" " + cursor[i] + " | ");
if (cursor.columnName(i)=="zip")
write(" " + cursor[i] + " | ");
if (cursor.columnName(i)=="phone")
write(" " + cursor[i] + " | ");
if (cursor.columnName(i)=="fax")
write(" " + cursor[i] + " | ");
if (cursor.columnName(i)=="email")
write(" " + cursor[i] + " | ");
if (cursor.columnName(i)=="custgroupname")
write(" " + cursor[i] + " | ");
if (cursor.columnName(i)=="leadname")
write(" " + cursor[i] + " | ");
if (cursor.columnName(i)=="prodname")
write(" " + cursor[i] + " | ");
if (cursor.columnName(i)=="groupname")
write(" " + cursor[i] + " | ");
if (cursor.columnName(i)=="sumcurrentsales")
write(" $" + NRound(cursor[i], 0) + " | ");
if (cursor.columnName(i)=="sumpriorsales")
write(" $" + NRound(cursor[i], 0) + " | ");
if (cursor.columnName(i)=="sumplansales")
write(" $" + NRound(cursor[i], 0) + " | ");
if (cursor.columnName(i)=="currentprior")
write(" " + NRound(cursor[i], 2) + "% | ");
if (cursor.columnName(i)=="currentplan")
write(" " + NRound(cursor[i], 2) + "% | ");
}
write("
");
}
cursor.close();
write("