"nav 2013" use default function in layout code

Answers

• Options

  RockWithNAV Member Posts: 1,139

  2016-03-26

  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/

  0
• Options

  lornisse Member Posts: 10

  2016-03-26

  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)
  
  
  
  

  Capture.JPG 99.1K

  0
• Options

  RockWithNAV Member Posts: 1,139

  2016-03-26 Answer ✓

  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.
  
  

  Thanks
  
  Blog - rockwithnav.wordpress.com/
  Twitter - https://twitter.com/RockwithNav
  Facebook - https://facebook.com/rockwithnav/

  5
• Options

  kriki Member, Moderator Posts: 9,089

  2016-04-01

  [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!
  
  

  0