"nav 2013" use default function in layout code

lornisse
lornisse Member Posts: 10
in NAV Three Tier
Hello

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
Thanks

Best Answer

Answers

  • RockWithNAV
    RockWithNAV Member Posts: 1,202
    Hey Lornisse,

    You just nee to write CountDistinct(Fields!X.Value), it will return the count of Distinct Values.
    Thanks

    Blog - rockwithnav.wordpress.com/
    Twitter - https://twitter.com/RockwithNav
    Facebook - https://facebook.com/rockwithnav/
  • lornisse
    lornisse 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)


    hhkixo2f0a0e.jpg
  • kriki
    kriki Member, Moderator Posts: 9,135
    [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!

Categories