You must create a formula in a Crystal report that will evaluate an array, determine if the field value is already present in the array and add the value if it does not exist as an array member. You must keep all existing array members when new values are added. There are 900 potential array members. You develop the following formula, but find that it does not work as required:

shared idarray() as number shared rtI as number if onfirstrecord or {Customer.Country} <> previousvalue({Customer.Country}) thenredim idarray(1) rtI := 0 end if if not({Orders.Order ID} in idarray) then rtI := rtI + 1 formula := idarray(rtI) Which modification will make the following formula work correctly?

Question

You must create a formula in a Crystal report that will evaluate an array, determine if the field value is already present in the array and add the value if it does not exist as an array member. You must keep all existing array members when new values are added. There are 900 potential array members. You develop the following formula, but find that it does not work as required:

shared idarray() as number shared rtI as number if onfirstrecord or {Customer.Country} <> previousvalue({Customer.Country}) thenredim idarray(1) rtI := 0 end if if not({Orders.Order ID} in idarray) then rtI := rtI + 1 formula := idarray(rtI) Which modification will make the following formula work correctly?

Accepted Answer

C. Change the assign operators from Crystal to Basic syntax.

Answer

A. Increment a second counter.

Answer

B. Re-declare the variables with a new scope.

Answer

D. Add another array variable to account for all potential array members.

You must create a formula in a Crystal report that will evaluate an array, determine if the field value is already present in the array and add the value if it does not exist as an array member. You…

Question

Options

How the community answered

Community Discussion