Hide Dimension Value Columns for specific Dimension Code

(0) Share

Report

Posted on by DinB

4,070

I am adding following logic in the Dimension Values Page so that the columns "Name", "Dimension Value Type" and "Totaling" are invisible only for "DEPARTMENT" Dimension Code. It works as expected for "Dimension Value Type" and "Totaling" columns but it does not work for "Name" Column, even though the logic is similar. The "Name" Column also becomes invisible in other Dimension Code Values. Is there built-in restriction in BC for "Name" Column? How can I accomplish the desired result? Thank you.

pageextension 50100 DimensionValuesExt extends "Dimension Values"
{
    layout
    {
        modify(Totaling)
        {
            Visible = Visibleflag;
        }
        modify("Dimension Value Type")
        {
            Visible = Visibleflag;
        }
        modify(Name)
        {
            Visible = Visibleflag;
        }
    }
    var
        Visibleflag: Boolean;
    trigger OnOpenPage()
    begin
        if Rec."Dimension Code" = 'DEPARTMENT' then
            Visibleflag := false
        else
            Visibleflag := true;
    end;
}