Hi,
We have a situation where in the data is inconsistent.
As we have two system. development client and Integration client.
table entry for data is blank in development client as the field checks for the workfield as '00000000'
in report it gives correct output, date field is blank means its initial or '00000000' but in other system
its blank and as our check is for '00000000' it passes through.
Analysis done as checked the data type, although a check can be placed workfield eq space then it will work but inconsistency is issue.
Regards
Mohinder Singh Chauhan