Share
ReportHello Experts,
I need to Hide the Cost from the Reports for a specific user, Any idea?
Thanks in advance!
*This post is locked for comments
You’re offline. This is a read only version of the page.
Hello Experts,
I need to Hide the Cost from the Reports for a specific user, Any idea?
Thanks in advance!
*This post is locked for comments
I will try this and I will feedback thank you binesh
.
This might also be helpful: dynamicsuser.net/.../hiding-report-fields
Hello Hamam Akram,
As per other members suggestion you have to do.
1: Create a field "ShowCost" or [based on your policy] field in User Setup.
2: Make this field true that users you want to shoe cost.
3: In Report declare IsShowCost boolean variable.
4: In Report DataItem OnAfterGetRecord write code:
IF UserSetup.GET(USERID) THEN BEGIN
CLEAR(IsShowCost);
IF UserSetup.ShowCost THEN
IsShowCost := TRUE
ELSE
CLEAR(IsShowCost);
END;
5: Add a Coulmn under DataItem IsShowCost.
6: Open Report Layout and go for Cost coulmn, Make Hidden experession
=iif(Fields!IsShowCost,false,true)
Hi,
You can get the cuurent USERID and store it in a variable say UserName and then set visibility expression for cost in Show or hide based on an expression
=iif(Fields!UserName.Value="NAV\CFADMIN",false,true)
You need to add a boolean on the user setup to specify who has permission or not and then use that value in the report visibility expression to hide the cost.
You can use visibility expression on column to hide the cost column
All responses (
Answers (
28,094
