Getting this if I run my report on a system that I know has no data 3 years ago. I need it to return a 0 if there's no data. Can't, for the life of me, figure this out and I'm no Crystal expert. I'm trying to fix this report that was created by someone else. Here's the formula that's erroring...
whileprintingrecords;
shared stringvar partssoldYr3;
local stringvar temp1 := Left(partssoldYr3, len(partssoldYr3)-1);
tonumber(split(temp1,"^")[groupnumber]);
The highlighted portion when it errors is...
split(temp1,"^")[groupnumber]);
whileprintingrecords;
shared stringvar partssoldYr3;
local stringvar temp1 := Left(partssoldYr3, len(partssoldYr3)-1);
tonumber(split(temp1,"^")[groupnumber]);
The highlighted portion when it errors is...
split(temp1,"^")[groupnumber]);