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