var QueryStr=""; var CharPosition=0; var QueryLength=0; var CustomWhere=""; cursor = database.cursor("SELECT * FROM Custom_Reports WHERE Custom_Reports.Name = \"" + request.RptName + "\" and category=\"" + client.RptGroup + "\""); write("Running Report - " + request.RptName + ""); write(WriteCustomSelections() + "") if (cursor.next()) { QueryStr = cursor.Query; CharPosition=QueryStr.indexOf("GROUP BY"); if (CharPosition==-1) { CharPosition=QueryStr.indexOf("ORDER BY"); } CustomWhere=BuildQuery(client.CustID, client.ProdID, client.CustGroupID, client.ProdGroupID); QueryLength=QueryStr.length; QueryStr=QueryStr.substring(0, CharPosition) + " " + CustomWhere + " " + QueryStr.substring(CharPosition, QueryLength) cursor.close() } else { write("

Error -- Could not collect report information! [" + request.RptName + "]

"); cursor.close(); } // Create a new cursor with the stored query... // cursor = database.cursor(QueryStr); //Space out the columns to look better write(""); write(""); for(i=0;i < cursor.columns(); i++) { write(""); } write(""); while( cursor.next() ) { write(""); for(i=0;i < cursor.columns(); i++) { if (cursor.columnName(i)=="custname") write(" "); if (cursor.columnName(i)=="region") write(" "); if (cursor.columnName(i)=="address1") write(" "); if (cursor.columnName(i)=="city") write(" "); if (cursor.columnName(i)=="state") write(" "); if (cursor.columnName(i)=="zip") write(" "); if (cursor.columnName(i)=="phone") write(" "); if (cursor.columnName(i)=="fax") write(" "); if (cursor.columnName(i)=="email") write(" "); if (cursor.columnName(i)=="custgroupname") write(" "); if (cursor.columnName(i)=="leadname") write(" "); if (cursor.columnName(i)=="prodname") write(" "); if (cursor.columnName(i)=="groupname") write(" "); if (cursor.columnName(i)=="sumcurrentsales") write(" "); if (cursor.columnName(i)=="sumpriorsales") write(" "); if (cursor.columnName(i)=="sumplansales") write(" "); if (cursor.columnName(i)=="currentprior") write(" "); if (cursor.columnName(i)=="currentplan") write(" "); } write(""); } cursor.close(); write("
"); if (cursor.columnName(i)=="custname") write("Customer Name"); if (cursor.columnName(i)=="region") write("Region"); if (cursor.columnName(i)=="address1") write("Address"); if (cursor.columnName(i)=="city") write("City"); if (cursor.columnName(i)=="state") write("State"); if (cursor.columnName(i)=="zip") write("Zip Code"); if (cursor.columnName(i)=="phone") write("Phone"); if (cursor.columnName(i)=="fax") write("Fax"); if (cursor.columnName(i)=="email") write("Email Address"); if (cursor.columnName(i)=="custgroupname") write("Customer Group"); if (cursor.columnName(i)=="leadname") write("Lead Source"); if (cursor.columnName(i)=="prodname") write("Product Name"); if (cursor.columnName(i)=="groupname") write("Product Group"); if (cursor.columnName(i)=="sumcurrentsales") write("Current YTD"); if (cursor.columnName(i)=="sumpriorsales") write("Prior YTD"); if (cursor.columnName(i)=="sumplansales") write("Planned YTD"); if (cursor.columnName(i)=="currentprior") write("% Inc"); if (cursor.columnName(i)=="currentplan") write("% to Plan"); write("
" + cursor[i] + "" + cursor[i] + "" + cursor[i] + "" + cursor[i] + "" + cursor[i] + "" + cursor[i] + "" + cursor[i] + "" + cursor[i] + "" + cursor[i] + "" + cursor[i] + "" + cursor[i] + "" + cursor[i] + "" + cursor[i] + "$" + NRound(cursor[i], 0) + "$" + NRound(cursor[i], 0) + "$" + NRound(cursor[i], 0) + "" + NRound(cursor[i], 2) + "%" + NRound(cursor[i], 2) + "%
");