Skip to Content
0
Jul 20, 2016 at 12:23 PM

Get email of Sales Employee into CrystalReport

49 Views

Hello,

is somehow(sql select) possible get email of user to CrystalReport. I have user connected to Sales Employee and my goal is get the email from card ORDR - Sales Order.

what I did try:

SELECT
T0.DocNum, T0.CardCode, T0.CardName, T1.ItemCode, T1.Quantity, T1.Price, T2.[SlpCode], T2.[SlpName], T3.[E_Mail] FROM ORDR T0 INNER JOIN RDR1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OSLP T2 ON T0.SlpCode = T2.SlpCode INNER JOIN OUSR T3 ON T2.SlpName = T3.E_Mail

but this doesn't work as I need

Thank You