"nav 2013" use default function in layout code

lornisse

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

RockWithNAV

Hey Lornisse,

Custom Code of the Report Property is used to built your own logic and get it used in the Report, you cant used the Standard Keywords there which you find when you are writing any expressions. If you want to build some custom logic you are free to write there and get it used with Code.YourFunctionName but you cant use the standard keywords while building your own Custom Code in the Report Property Code area.

RockWithNAV

Hey Lornisse,

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

lornisse

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)

RockWithNAV

Hey Lornisse,

Custom Code of the Report Property is used to built your own logic and get it used in the Report, you cant used the Standard Keywords there which you find when you are writing any expressions. If you want to build some custom logic you are free to write there and get it used with Code.YourFunctionName but you cant use the standard keywords while building your own Custom Code in the Report Property Code area.

kriki

[Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]