In report layout, I want Column visibility dynamically

PankajNav2017
PankajNav2017 Member Posts: 5
edited 2017-12-20 in NAV Three Tier
I am having problem in Column Visibility in Report.I want a column visible dynamically based on field of same column.In customer trail balance report added a new column currency code.So for a particular date if this column has currency code value then column will be visible, otherwise will be hidden.

I tried -Write code in OnAfterGetRecord-IF "Cust. Ledger Entry"."Currency Code"<>' ' THEN
Visibility:=TRUE;

and in Layout,in column Visibility property-=if(Fields!Visibility.Value=true,true,false)

but not getting results.
plzz help anyone.
Thanks All in advance.

Answers

  • PankajNav2017
    PankajNav2017 Member Posts: 5
    Plz Give any suggestion.
  • Slawek_Guzek
    Slawek_Guzek Member Posts: 1,690
    Have you searched mibuso? This topic has been discussed not so long go
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • PankajNav2017
    PankajNav2017 Member Posts: 5
    thanks sir!!! for your suggestion but I tried to follow discussed topic regarding my problem but could not find solution. if u have any solution plzz provide me

    thanks!!!
  • PankajNav2017
    PankajNav2017 Member Posts: 5
    plzzz anyone help me.
  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories