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
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.
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
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.
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.
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
#1
André Arnaud de Cal...
292,494
Super User 2025 Season 1
#2
Martin Dráb
231,309
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
