Hi, all!
I am building a report that shows certain order information for six ship tos of one company. I have a group header for ship to, but I'd like it to print the plant's name rather than 01 for the ship to. I know there is a way to write an expression that will have report builder use the names in place of the numbers.
iif(OrderHed.ShipToNum='01','plantnamehere','')
works for the first one. I don't know how to extend that expression out for more variables. Thanks in advance for the help!
Gary Grenier
Bell Manufacturing Co.
ggrenier@...
[Non-text portions of this message have been removed]
I am building a report that shows certain order information for six ship tos of one company. I have a group header for ship to, but I'd like it to print the plant's name rather than 01 for the ship to. I know there is a way to write an expression that will have report builder use the names in place of the numbers.
iif(OrderHed.ShipToNum='01','plantnamehere','')
works for the first one. I don't know how to extend that expression out for more variables. Thanks in advance for the help!
Gary Grenier
Bell Manufacturing Co.
ggrenier@...
[Non-text portions of this message have been removed]