cancel
Showing results for 
Search instead for 
Did you mean: 

Displaying contents of an array

Former Member
0 Kudos

I need to collect and display a large number of Outlook distribution lists (strings) into one long stream on a report (ex. #DLxxxxxxxx1;#DLxxxxxxx2;#DLxxxxxxxx3...), but cannot use a string variable due to it's 254 character limit. I've been successful storing the distribution lists in an array, but haven't figured out how to display the entire contents of the array at the end of the report. Can someone help me with that?

Thanks,

Nancy

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

what version of CR you are using? because as far as I have heard the limit of 254 chr has overcome in CR2008

Regards

Jehanzeb

Former Member
0 Kudos

I am using CR 8.5.

I have tried using join(arryname,";"), but it appears to run into the same character limit.

Seems that I need to be able to loop through the array and print each value on the report, but I've not found a way to do that. I can display any one element in the array, but not all of them.

Nancy

Former Member
0 Kudos

may be you can try this like

join(arrayname[1 to 100],";")

create another formula like

join(arrayname[101 to 200],";")

so..on...........

and concatenate all together

Regards,

Raghavendra

Answers (1)

Answers (1)

Former Member
0 Kudos

Try this formula in report footer

join(arryname,";")

Regards,

Raghavendra