How to create string array of more than 1000 elements

[makk07]

Hi Everyone,

I am using Crystal Reports XI and I want to create an array of 5000+ elements,and I know there is a limitation of 1000 elements in crystal reports.

Its urgent,please suggest how to do that.

Please help me out.

Thanks in advance

 

[IanWaterman]

I needed a 3000 element array and got around it this way.

In report header added a formula which initiated 3 arrays with 1000 elements

global numbervar array ClientList;
global numbervar array ClientList2;
global numbervar array ClientList3;
global numbervar CliCnt;


If not({RPT_BFS_CLIENT_DETAILS.CLIENT_KEY} in ClientList) and not({RPT_BFS_CLIENT_DETAILS.CLIENT_KEY} in ClientList2) and
not({RPT_BFS_CLIENT_DETAILS.CLIENT_KEY} in ClientList3) and {RPT_BFS_QUOTE_ANALYSIS.POL_CRT_DATE} in [{?FROMDATE} to {?TODATE}]
and CliCnt <= 1000 then ClientList [CliCnt]:={RPT_BFS_CLIENT_DETAILS.CLIENT_KEY}
else
If not({RPT_BFS_CLIENT_DETAILS.CLIENT_KEY} in ClientList) and not({RPT_BFS_CLIENT_DETAILS.CLIENT_KEY} in ClientList2) and
not({RPT_BFS_CLIENT_DETAILS.CLIENT_KEY} in ClientList3) and {RPT_BFS_QUOTE_ANALYSIS.POL_CRT_DATE} in [{?FROMDATE} to {?TODATE}]
and CliCnt > 1000 and CliCnt <= 2000 then ClientList2 [CliCnt-1000]:={RPT_BFS_CLIENT_DETAILS.CLIENT_KEY}
else
If not({RPT_BFS_CLIENT_DETAILS.CLIENT_KEY} in ClientList) and not({RPT_BFS_CLIENT_DETAILS.CLIENT_KEY} in ClientList2) and
not({RPT_BFS_CLIENT_DETAILS.CLIENT_KEY} in ClientList3) and {RPT_BFS_QUOTE_ANALYSIS.POL_CRT_DATE} in [{?FROMDATE} to {?TODATE}]
and CliCnt > 2000 then ClientList [CliCnt-2000]:={RPT_BFS_CLIENT_DETAILS.CLIENT_KEY};

If not({RPT_BFS_CLIENT_DETAILS.CLIENT_KEY} in ClientList) and not({RPT_BFS_CLIENT_DETAILS.CLIENT_KEY} in ClientList2) and
not({RPT_BFS_CLIENT_DETAILS.CLIENT_KEY} in ClientList3) and {RPT_BFS_QUOTE_ANALYSIS.POL_CRT_DATE} in [{?FROMDATE} to {?TODATE}] then
CliCnt:= CliCnt+1;