I need some help with a form and sub report that we are using to obtain the alias part descriptions for some of our forms.
My issue is that I wish to ignore all the C type (customer type) alias data and only use the G type (general) details.
The sub report appears to be working properly and only giving me the data that is desired however the crystal report is further using the C type details if the inventory item has this type of alias as well it is then printing both my alias description PLUS my inventory description.
My goal is to print the Item description of the Alias G type if it exists or always print my Inventory item description (not both)
Type | item code | item description | ||
Inventory | 123 | ABC | ||
Alias "G" | 123 | ZZZ | ||
Alias "C" | ABC | ABC | ||
My goal is to print the "G" description ONLY, if present | ||||
OR | ||||
print the item description ONLY if "G" is not present | ||||
Any help on how to accomplish this task would be greatful.