shared numbervar array myarray;
shared numbervar array myarray2;
shared numbervar am;

if Sum (table.field}, {table.datetime}, "daily") = 0 then
(redim myarray[1];
redim myarray2[1];

am := 0);

if NOT({table.field} in myarray or 
{table.field} in myarray2) then

(am := am + 1;
if am <= 1000 then (Redim Preserve myarray[am];myarray[am] := Sum ({table.field}, {table.datetime}, "daily"));
if am in 1001 to 2000 then (Redim Preserve myarray2[am-1000];myarray2[am-1000] := Sum (({table.field}, {table.datetime}, "daily"));
);

if am <= 1000 then myarray[am]
else if am in 1001 to 2000 then myarray2[am-1000]

 

I am using the same dynamic array in other parts of my report and have no isues. However, with this array it is randomly dropping the daily totals even though there is data in the field. Has anyone ever had this happened before?