By using this website, you agree to our Terms of Use (click here)
Hello,
I am currently working on a report that prints Alt. ID. On this report, it shows both alternate IDs for the inventory ID. I have multiple Alternate IDs for the same Inventory Item. I have set it up for additional filters (Add viewer fields in report designer and its displayed when you go to run the report) and you can filter out which Alternate Type you want to see. Is there another way to do this in the report designer, such as changing some grouping or adding another relationship?
Thanks,
You could use a Parameter instead of the View Fields, but you'd still have the problem of it displaying multiple Alternate IDs.
@casey-hope Did you ever figure this out?
I've realized that all of our Global Alternate ID's start with a integer and all of our Customer Alternate IDs and Inventory IDs start with a letter. So, I can use Iff() or IsNull() for items that have a customer ID for that customer, or items that have no Global Alternate ID, but I'm having trouble selecting Alternate vs InventoryID based on the first character. This is normally a super easy process in any programming language or using regexp (something like IsInterger() or ^[0-9]). Does anyone know how I can do this in Report Designer?
@nmri It might make more sense to test the Alternate Type rather than the Alternate ID. Here's a sample formula:
=Switch([INItemXRef.AlternateType]='GLBL','My Global',[INItemXRef.AlternateType]='BAR','My Barcode',[INItemXRef.AlternateType]='0CPN','My Customer',[INItemXRef.AlternateType]='0VPN','My Vendor','Nothing')
Which returns the values in the last column of these results:
Online Members