Unanswered: Novice to Crystal Reports: IF THEN ELSE condition
Hi Guys, i have a small dilemma and i have tried soooo many things but its obvious that i'm doing something very wrong. Here it is:
i have 4 tables which are INVENTORY, BVE_ORDER_DTL, BOM_TOP_LEVEL, BOM_SUB_LEVEL.
We have a distribution company and we have all kinds of items. In the BVE_ORDER_DTL is the detail of the orders and has the following infos:
so basically the KIT1 is a kit with all his components (KIT1.1, 1.2, 1.3).
In order to know if the item is a kit or not the INVENTORY.TYPE="V" means this item is a KIT item and the name which is "KIT1" is stored into the table BOM_TOP_LEVEL.top_code and all the components in the BOM_SUB_LEVEL.sub_code.
So my most important goal is to have this end product: