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 !
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 !
Hi
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.
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,
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
Never mind …… i see that i don’t join it !
Hi
You are right. No need to join, it can be just added to list of selected DACs.
Regards,
I have a similar problem, I need to get the code of the logged employee.
How can I do it?
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.