I use crystal report version 1o
I want to bring a value fron a table, but the sales order is in one company and the shipment isi in other company (in the same database)
how can I display dis value . I can display the the received name but not the global id number . asigned to this name
this is the field i need to display
CUSTTABLE.MGSITRACKCHEPGLID}
if({SALESTABLE.CUSTACCOUNT} = "0012";{SALESTABLE.INTERCOMPANYCOMPANYID}) = "vcc" then
{SALESTABLE.DELIVERYNAME}
else
{CUSTTABLE.MGSITRACKCHEPGLID}
Software/Hardware used:
Software/Hardware used:
ASKED:
July 27, 2009 7:47 PM
UPDATED:
July 28, 2009 5:14 PM
Answer Wiki:
Try this instead
<pre>
if({SALESTABLE.CUSTACCOUNT} = "0012" <b>AND</b> {SALESTABLE.INTERCOMPANYCOMPANYID}) = "vcc" then
{SALESTABLE.DELIVERYNAME}
else
{CUSTTABLE.MGSITRACKCHEPGLID}
</pre>
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
