Does anyone know if there is an equivalent function in the report designer to the @Me function in generic inquiries? I need to restrict salespeople/ users so they only see their sales information.
thanks !
Solved
@Me function in Report Designer
Best answer by vkumar
Hi
You can use ‘AccessInfo’ DAC ( the values in this table are dynamically generated, no permanent data exists in this DAC/table ), and an expression : =Report.GetDefUI('RowAccessInfo.UserName') to fetch the logged on user name (login name).
I have added this column on an AR Invoice report to test and here are relevant screenshots :
Added the DAC on schema builder
Added the UserName field
Hope this helps.
Regards,
+19Hi
Naveen B
1 person likes this
Hi Naveen ,
Thanks for the response. I am able to use the @Me in the generic inquiry. My problem is that i need to use the same function in report design but it doesn’t work in the report designer. So , i am looking for something that will work the same. So i can restrict the current user.
+19.
+19
hope this helps!
Hi
You can use ‘AccessInfo’ DAC ( the values in this table are dynamically generated, no permanent data exists in this DAC/table ), and an expression : =Report.GetDefUI('RowAccessInfo.UserName') to fetch the logged on user name (login name).
I have added this column on an AR Invoice report to test and here are relevant screenshots :
Added the DAC on schema builder
Added the UserName field
Hope this helps.
Regards,
VijayKumarU
thanks vkumar,
That is what i am looking for, but when i put it in my report i get an error Invalid object name 'AccessInfo'. i tried joining using the below two options
Team,
I have a requirement for the report, where I need to obtain the code of the logged user and print it.
Could you please assist with this
Regards
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.