I have a report in CR 2008 that works great with Crystal itself, but bombs in Business Objects Infoview with the following error:

Error in File ~tmp1d4c7219297c020.rpt: Error in formula TheMonth: '// Find month/year value from footer and add up running total. ' A subscript must be between 1 and the size of the array. Details: errorKind

The job has a pair of arrays that are dimensioned at 13 each. The formula that the job bombs in looks like this:

     // Find month/year value from footer and add up running total.
     local numberVar xx;
     local numberVar yy;
     global stringvar array monyear;
     global numbervar array running;
     redim preserve monyear [13];
     redim preserve running [13];
     for xx := 1 to 13 do
     (
     If monyear[xx] = GroupName ({V_IMG_STUDY.END_EXAM_DTTM}, "monthly") Then
      (yy := xx;
      running [xx] := Count ({V_IMG_STUDY.END_EXAM_DTTM}, {V_IMG_STUDY.END_EXAM_DTTM}, "monthly")));
     monyear[yy] & " --> " & running[yy]

The formula originally did NOT have the redim statments. I added those to see if it would help and it didn't.

Has anyone else run into this? Ideas?

Surprise, I figured it out!

Look closely at the last line in the formula. I display a couple values from the array to have something declared in the formula, and also for debugging purposes. I was using the variable “yy” as a subscript for the two arrays to show what was in them when done. But “yy” was being set only when the If statement was satisfied, otherwise it was 0.

Turns out the data I have coming in assured due to my selection criteria that the If statement would always be satisfied. It worked fine in Crystal Reports and displayed the values properly.

But BOE must be fussy when it interprets the running of the formula and kicks out the error.

So, I changed the last line to just say “done” and that cleared it up. Phew!

Thanks, again.

Brad