'in array' and 'redim preserve'

[ramkrish11]

I am using Crystal REports XI and have a problem with arrays.

We have customer_ids and account_ids. You can have multiple account_ids for each customer id. I need to 0 out some the numeric values when account ids are repeated for a customer. yes. it is sorted as needed.


I am trying to accomplish this by creating an array of account_ids for each customer as i print it.

when the customer changes I redim the array and start over.
otherwise I search in the array and set a flag if found
if not found, add in the array and continue

2 issues.

1. This array wont grow more than 2 using 'redim preserve'
2. 'in array' never succeeds; returns False and adds the same value twice

i will appreciate it if Anyone can shed some light and sense into this.

Thanks a ton

 

[lbass]

I think you're going to have to share the formulas you have created.

-LB

 

[ramkrish11]

thanks for your input...

there is nothing that can be solved by a day of headbanging

Seems we have to specify the "in array" as

"variable in arrayname[1 to i]" i being the upperbound on the array

I was specifying it as

"variable in arrayname "

which is more intuitive..