Crystal 10 formula help

45 Views

I am trying to write a formula that will show 2 names if they exist on the same record instead of showing the record twice, once with each value. This is what I tried:

If({case_record_billing_queue.crbq_stock_urn}=4259)then "ANNERVE" else

if({case_record_billing_queue.crbq_stock_urn}=2836)then "ANCONT" else

If({case_record_billing_queue.crbq_stock_urn}=(4259 + 2836))then("ANNERVE" + "and"+ "ANCONT")

I get the formula to show ANNERVE on the 1st row of information, and if the 2nd condition is met, ANCONT shows on the 2nd line (in the detail section) with all the same information in line 1 except ANNERVE. Not all records have both conditions, maybe 1 out of 8. How can I get a formula to work that would display both ANNREVE and ANCONT on the same line if conditions are met?