I'm using CR 10 and have a report where the formula only works on some records. Here is my formuala below:

Code:
WhilePrintingRecords;

Global BooleanVar blnProductXref;

if {tblProducts.AdventProductCD} > "" then
    (
        blnProductXref := true;
        {tblBatchDetail.prodCode} & "/(" & {tblProducts.AdventProductCD} & ")"
    )
else
    (
        blnProductXref := false;
        {tblBatchDetail.prodCode} & "/(Unk)"
    )
Problem is for the record in question....it should be taking the else path and printing the value in {tblBatchDetail.prodCode} (which contains a value) but it's not showing on the report. For other records that contain a value in the same field....they WILL show up on the report. It doesn't make sense to me.

Any ideas?

Thanks,