Microsoft Dynamics NAV (Archived)

Hiding Cost From The Reports For Specific user

(0) Share

Report

Posted on by Community Member

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 have the same question (0)

All responses (7)

Answers (0)

Amol Salvi 18,698 on at

Like (0)

Report

You can use visibility expression on column to hide the cost column

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (2)

Report

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.

Was this reply helpful? Yes No
Tina Menezes 2,582 on at

Like (2)

Report

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)

Was this reply helpful? Yes No
Suggested answer

Binesh 7,885 on at

Like (2)

Report

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)

Was this reply helpful? Yes No
Suggested answer

Alexander Ermakov 28,096 on at

Like (1)

Report

This might also be helpful: dynamicsuser.net/.../hiding-report-fields

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I will try this and I will feedback thank you binesh

Was this reply helpful? Yes No