A string can be most 254 characters long in CR 8.5

See more:

VB

CrystalReports

I used formula as indexbuild syntax as below for generating table of content........

WhilePrintingRecords;
shared StringVar Array catArry;
shared NumberVar Array pageArry;
IF NOT (GroupName({Ledger.ACCODE1})& "-" & mid({Ledger.name1},1,100) IN catArry) THEN (
Redim Preserve pageArry[UBound(pageArry) + 1];
pageArry[UBound(pageArry)] := PageNumber;
Redim Preserve catArry[UBound(catArry) + 1];
catArry[UBound(catArry)] := trim(ToText ((GroupName ({Ledger.ACCODE1})))) & "-" & mid({Ledger.name1},1,100);
);
"";

-----------------------------------------------------------------------------------
I used formula as indexprint syntax as below for Printing table of content........

WhilePrintingRecords;
NumberVar i;
NumberVar j;
shared StringVar Array catArry;
shared NumberVar Array pageArry;
StringVar Array Output;
Redim Output[UBound (catArry)];
FOR i := 1 to UBound (catArry) do (
Output[i] := mid(Left(CStr(ToText(pageArry[i],0))+" " + "|",5)+mid(catArry[i]+space(100),1,100) ,1,200);
);
Join(Output,CHR(13))

But it gives error a string can be most 254 characters long.

if u have another method to generate table of contents then please give me a solution for more then 600 or 10000 pages.

Thanks in Advance