Hi there sir ... here's the code from the whole report cell ... the commented vResultSetSearches are my failed attempts ...
#include "sbasic_include.sbas"
var vListStart as date
var vListEnd as date
var vRSHandle as int
var vNoOfRecords as int
var vLoop as int
vListStart = (@Str(@Year(ListMo2) + "-" + (@Str(@month(ListMo2))) + "=" + "01"))
vListEnd = vListStart + 31
vListEnd = (@Str(@Year(vListStart) + "-" + (@Str(@month(vListStart))) + "=" + "01"))
// vRSHandle = @XResultSetSearch(@FN, "Debtors", SEARCH_MODE_AND, SEARCH_SYNTAX_QA, "!DBListed=">=vListStart, "!DBListed="<=vListEnd, "!DBCltNo="+CltString)
// vRSHandle = @XResultSetSearch(@FN, "Debtors", SEARCH_MODE_AND, SEARCH_SYNTAX_QA, "!DBListed=" + vListStart + ".." + vListEnd, "!DBCltNo="+CltString)
// *** CALCS ALL INVENTORY *** vRSHandle = @XResultSetSearch(@FN, "Debtors", SEARCH_MODE_AND, SEARCH_SYNTAX_QA, "!DBCltNo="+CltString)
vRSHandle = @XResultSetSearch(@FN, "Debtors", SEARCH_MODE_AND, SEARCH_SYNTAX_QA, "!DBListed=" + vListStart + "..", "!DBListed=" + ".." +vListEnd, "!DBCltNo=" + CltString)
if(vRSHandle > -1)
{
ListedString = 0
vNoOfRecords = @XResultSetTotal(vRSHandle)
for vLoop = 1 to vNoOfRecords
XResultSetCurrentPosition(vRSHandle, vLoop)
ListedString = @Appendstringarray(ListedString, @XResultSetValue(vRSHandle, "DBList"))
next
XResultSetClose(vRSHandle)
}
ListedString = @sumlistvalues(ListedString)