"nav 2013" use default function in layout code

lornisselornisse Member Posts: 10

please i want to know if it is possible to use the defaut system function in a report layout code section (customize code)
for example how in the report layout code section (customize code) how to use the default function CountDistinct
who can be use in a textbox expression

Best Answer


  • Options
    RockWithNAVRockWithNAV Member Posts: 1,139
    Hey Lornisse,

    You just nee to write CountDistinct(Fields!X.Value), it will return the count of Distinct Values.
  • Options
    lornisselornisse Member Posts: 10
    Thank you
    but if i want to use the CountDistinct function in the code section (custom code section = report properties code section ) and not in the body
    it is possible ?

    Right click → properties → code (in the report layout)

  • Options
    krikikriki Member, Moderator Posts: 9,098
    [Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Sign In or Register to comment.