web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Where do Source Expres...
Microsoft Dynamics NAV (Archived)

Where do Source Expressions come from?

(0) ShareShare
ReportReport
Posted on by edwardl 2

I am wondering where these Source Expressions for each page pull their data from and if they do anything to those values. Also if anyone is familiar with JetReports, I know how to pull data from the Table Fields with NL statements but I don't know how to access Source Expressions. This is just a quick screenshot of some Source Expressions, normally there are many values here.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,243 Super User 2025 Season 2 on at

    Edward,

    Those source expressions are assigned to one/more of the controls on the page, if you have any variables defined on the page which has property IncludeInDataSet to yes the those will display there and also for decimal fields it will display the format for that control.

    May i know why would you need those source expression values?

    Regarding JetReports refer below link and also there are several other posts and videos on youtube.

    community.dynamics.com/.../working-with-jet-express-reports-for-dynamics-nav.aspx

  • Verified answer
    edwardl Profile Picture
    edwardl 2 on at

    If you look in this particular source expression, you will see Total Payment. This should normally reflect what is found in the Table Fields however I often see different values. I also want to pull certain values from Source Expressions into JetReports but I cannot find a table name or other identifying features to isolate it. 

  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,243 Super User 2025 Season 2 on at

    Do you have access to the code if so please check if you have field name Total Payment in the globals, it looks this is a custom page, if not let us know the page no. i can check it.

  • Community Member Profile Picture
    Community Member on at

    Hi Suresh, I'm also trying to analyse data shown in Source Expression through Jet reports. Were you able to resolve this query? I'm trying to sum Adjusted Cost (LCY) in the Sales Invoice Header however it doesn't appear as a numerical filter when using the NL function.

    Kind regards

    Alison

  • Community Member Profile Picture
    Community Member on at

    Finally any one could figure it out how to get these source expression fields in the navision table in to jet reports? Is it possible ? If so please guide.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans