Hello, I am having a need to get the report runner’s information on the report. Like the phone and email. I studied “Rowaccessinfo”, from which I can just get the DispalyName, UserName, Company, something like this. I coud not get email and phone from it.
Does anyone know a way to do this?
Solved
Get the report runner information , like phone and email.
Best answer by lauraj46
Hi
I recommend taking a look at this thread:
Read through and there is an explanation how to add the Users DAC table to your report by using a parameter that defaults to the current user. You can extend this logic to add the Contact table to the report using the relationship Users.PKID = Contact.UserID . The Email, Phone1 and Phone2 fields are available on the Contact record.
Hope this helps!
Laura
+9Hi
I recommend taking a look at this thread:
Read through and there is an explanation how to add the Users DAC table to your report by using a parameter that defaults to the current user. You can extend this logic to add the Contact table to the report using the relationship Users.PKID = Contact.UserID . The Email, Phone1 and Phone2 fields are available on the Contact record.
Hope this helps!
Laura
Login to the community
No account yet? Create an account
Social Login
Login with your Acumatica accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.