Error: Too many items been given to this array

[c8ltgkue]

Using CR XI

Hello all

I only want to see data for the selected case IDs which I have in an Excel sheet. To achive this I put the following in the record selection formula:

{tblCase.CaseID} in [3378,
3513,
3517,
4261,
4757,
4853] the list is long.

I put about 4500 Case IDs in the above formula. When I check the formula it shows the following error:

Too many items have been given to this array.

Can any one shed light on how to come around this problem ?

Thanks in adv.

C8

 

[lbass]

You should identify why you want those particular 4500 and then use that criterion to limit the records if possible instead of manually identifying all 4500.

-LB

 

[c8ltgkue]

Thanks lbass

There is no logic behind it. We just wanted to see certain things for those pertucular numbers. But I found out that crystal can not take more than 1000 in an array.

 

[rjoubert]

That's good to know (about the limit of 1000). Couldn't you use 5 arrays then?

Like...

{tblCase.CaseID} in [1111, 1112, 1113...] OR {tblCase.CaseID} in [2222, 2223, 2224...] OR
{tblCase.CaseID} in [3333, 3334, 3335...] OR {tblCase.CaseID} in [4444, 4445, 4446...] OR
{tblCase.CaseID} in [5555, 5556, 5557...]

 

[xicana]

I'm having a similar issue, did breaking it into several arrays work?

Sandy

 

[lbass]

Try several arrays, but also try using "to" for sequential numbers, as in:

[1 to 29,30,32 to 38]

-LB