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?
Answer
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
+8Hi
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
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.