I have 3 numeric fields in a database i.e. {abc.a},{abc.b} & {abc.c}.
Data in RECORD fields {abc.a} + {abc.b} should equate data in record field {abc.c}.
To check this, I created a new report file (using the active database) in Crystal and named it Data_Check. Data_Check displays {abc.c} and the result of a + b for comparison.
The formula to find the result of a + b is {abc.a} + {abc.b}and the formula {@data_check}was created. I then placed an argument code in the details-format field-suppress-visibility {@data_check}= {abc.c} which should show all records where a + b <> c.
It worked, but some records with the same figures were still being displayed. The aim was to find the records where a + b <> c , records that did not match. I have checked my database (dBase) and found no errors.
Where am I going wrong?
Your help will be appreciated. Am using v8.5
Claude
Data in RECORD fields {abc.a} + {abc.b} should equate data in record field {abc.c}.
To check this, I created a new report file (using the active database) in Crystal and named it Data_Check. Data_Check displays {abc.c} and the result of a + b for comparison.
The formula to find the result of a + b is {abc.a} + {abc.b}and the formula {@data_check}was created. I then placed an argument code in the details-format field-suppress-visibility {@data_check}= {abc.c} which should show all records where a + b <> c.
It worked, but some records with the same figures were still being displayed. The aim was to find the records where a + b <> c , records that did not match. I have checked my database (dBase) and found no errors.
Where am I going wrong?
Your help will be appreciated. Am using v8.5
Claude