Rpt Builder


(system) #1
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]

(system) #2
Gary, you need to join the "ShipTo" table to "OrderHed" using Company,
CustNum, and ShiptoNum. This will give you access to the Shipto.Name.

Good Luck
Jim Stetter

-----Original Message-----
From: Gary Grenier [mailto:ggrenier@...]
Sent: Wednesday, July 26, 2000 4:44 PM
To: vantage@egroups.com
Subject: [Vantage] Rpt Builder


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]


----------------------------------------------------------------------------
--



----------------------------------------------------------------------------
--
We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go
to www.egroups.com, login and be sure to save your password, choose My
Groups, choose Vantage, then choose Files. If you save the password, the
link above will work the next time you try it.)



[Non-text portions of this message have been removed]