CODEWITHSUNDEEP
crystal-reports
Nuru Salihu
Nuru Salihu

Reputation: 4928

Crystal Report Formular always return Boolean

iN my Crystal Report i have two columns of currency data types. I want to add a formular to the column a . i.e "WHEN A CURRENCY IN A is > THAN B, THEN The value of A should euqal the value of B ". I wrote my formula as below

currencyVar formular := {ProcName.coll};
IF({ProcName.coll} > {ProcName.ref}) 
Then 
    formular = {ProcName.ref}

AND 

IF({ProcName.coll} > {ProcName.ref}) 
    Then 
        {ProcName.coll}= {ProcName.ref}

Both yielded the same boolean values.When I saved and named the formula above, i then insert the formula to my column . However, the result are all boolean True/False. I am ot sure how this happened i check the data type of the formula is indicating boolean as well.

Upvotes: 0

Views: 717

Answers (1)

mechanical_meat
mechanical_meat

Reputation: 169274

This is because you're testing equality not assigning the value as you wish to do. Change your last line to a statement of assignment by adding a colon before the equal sign:

...
    formular := {ProcName.ref}
    //       ^

Upvotes: 1

Related Questions