Hi, I'm new to CR XI, and to Crystal Reports in general.  I'm modifying a report that currently works fine and involves only two tables.  I need to add table 3 that contains a field called "Pay_Method" I want on the report.  Table 1 has field "Account" that links with table 3 field "ID", except sometimes there isn't a value in "Account" for whatever reason.  Whenever I link these two tables, add "Pay_Method" to the report, and run it I get an error processing the report.  I'm wondering of the null or zero value in Account from table 1 isn't causing the issue?  I'm trying to figure out a formula to ignore the error if it happens, but I'm not doing very well.  Could someone please point me in a direction to run?  Thank you very much in advance for reading this!
Mike

Sure, thanks for the quick reply!  Table1 (br_deposit) links to table 2 (db_bank_account) via the common field Acct_Code, and data from both tables is printed in the report.  I am adding table 3 (cr_receipt_payment) of which I want the field "Pay_Method" to print on the report.  The only fields I can link the third table with are br_deposit.misc_integer_1  to  cr_receipt_payment.Receipt_No .  Both are number field types.  Thanks again!

Yes, that is correct, to see what was entered as the pay method - sorry for the late reply!

Edited by mjfmn - 27 Dec 2010 at 8:50am