0

Source Expressions

Joshua Pocock

April 04, 2019 13:46

None

Follow

I want to pull Source Expressions in Jet Express.  Is this possible?  If so, please elaborate. Thank you.

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Harry Lewis April 04, 2019 15:34

  Hello.

  For those who are unfamiliar with Source Expressions...

  - C/AL is a database programming language used with Dynamics NAV.

  - An NAV "Source Expression" is a C/AL expression that defines where to find the value of a control. The source expression is evaluated when updates are performed.

  - A source expression can be as simple as the name of a table field:

  

  - or it can also be a complex C/AL expression.

  - For FlowFields, using F1 to display the Help for the field can help to find out how to compute the value:

  

   

  
  In Jet Reports, it is possible to find the CalcFormula used by a FlowField by using the Jet Browser:
  

   

  Jet Basics has access to the data within the NAV database (but not the internal C/AL code used to compute certain fields).  If you can use NAV to determine how data is computed, you can then use Jet Basics to retrieve that underlying data.

  Edited by Harry Lewis April 04, 2019 15:35