Q:
Duplicate Record formula in Crystal 11
I have a formula written as such:
If onfirstrecord then {CHART_IMPORT_ERROR.ERROR_MESSAGE} else
If {CHART_IMPORT_ERROR.ERROR_MESSAGE} = previous({CHART_IMPORT_ERROR.ERROR_MESSAGE})
then """" else {CHART_IMPORT_ERROR.ERROR_MESSAGE}
Currently " is showing up if the record above is a duplicate. However, I would like it to display nothing instead of ". I'd prefer it to actually count the number of duplicates but I can deal with nothing also.
If onfirstrecord then {CHART_IMPORT_ERROR.ERROR_MESSAGE} else
If {CHART_IMPORT_ERROR.ERROR_MESSAGE} = previous({CHART_IMPORT_ERROR.ERROR_MESSAGE})
then """" else {CHART_IMPORT_ERROR.ERROR_MESSAGE}
Currently " is showing up if the record above is a duplicate. However, I would like it to display nothing instead of ". I'd prefer it to actually count the number of duplicates but I can deal with nothing also.
ASKED:
Jan 6 2009 5:00 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
