Skip to Content
0
Former Member
Jan 13, 2012 at 12:31 PM

Report/query result acting as a link to a PO document

100 Views

Hi,

Is it possible to have T0.[U_z1] (which is always the PO docnum) from the query below to act as link (i.e: orange arrow) so by clicking it the PO would open ?

SELECT T0.[DocNum], T0.[DocDate], T0.[U_z1] as 'nr.ZZtrans', T0.[U_Transport_nr_rej], 
T0.[DocStatus] as 'status', T0.[U_Wysylka_data], T0.[U_Wysylka_godzina], 
T0.[U_Awizacja_data], T0.[U_Awizacja_godzina] 
FROM OPOR T0  INNER JOIN POR1 T1 ON T0.DocEntry = T1.DocEntry

Any help would be appreciated.

Thank you,

Tomasz