Notifications
Clear all
Topic starter
Does anyone know how to add the authorizing provider of an order onto a crystal report? We need to add it to a requisition; we've used it on other requisitions but I am not able to drag the field between reports.
Thanks much!
Posted : August 1, 2016 11:08 am
In Crystal Reports I have the ORDERS.AUTHBYUSRID left outer joined to USRINFO.PVID. I then have a formula field putting {USRINFO.FIRSTNAME} + " " + {USRINFO.MIDDLENAME} + " " + {USRINFO.LASTNAME} together as AUTHPROV. The use the AUTHPROV field in the report. Hope this helps.
Posted : August 4, 2016 7:40 am
