Skip to Content

Linking OCRD to CRD1 with condition

May 17, 2017 at 01:05 PM


avatar image


I am working on a Crystal report where I need to pull CRD1.TaxCode. I linked the table CRD1 to OCRD where OCRD. CardCode = CARD1.CardCode and OCRD. ShipToDef = CARD1.Address. How can I make a conditional link so I can get information only where CRD1.AdresType = ā€œSā€. Currently when I run a report, it gives me two lines for each client because most of our BP Shipping address id is same as billing address id.

Thank you.


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers