I am using crystal reports for the 1st time trying to create labels for one of our customers. I have the label created, I am just trying to see how to write a formula for a lot #. Our customer wants for example, our Supplier ID and lot # together. I wanted to see if we could have the supplier id set standard and auto fill in the lot # from IQMS.
Example: 5730-1. The 5730- is a supplier id that needs to be standard on every label. The 1 would be the auto-fill lot # from IQMS that we have set.
Need help creating this formula if possible.