Question Status

Verified
Edward L asked a question on 2 Apr 2015 1:39 PM

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.

Reply
Verified Answer
Suresh Kulla responded on 2 Apr 2015 2:05 PM

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

Suresh Kulla
Navision Consultant

ArcherPoint, Inc    http://www.archerpoint.com

https://twitter.com/skkulla
Please verify the answer, if it helps to resolve your issue.

Blog: http://msnavision.blogspot.com/

Reply
Verified Answer
Edward L responded on 2 Apr 2015 2:12 PM

 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. 

Reply
Verified Answer
Suresh Kulla responded on 2 Apr 2015 2:31 PM

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.

Suresh Kulla
Navision Consultant

ArcherPoint, Inc    http://www.archerpoint.com

https://twitter.com/skkulla
Please verify the answer, if it helps to resolve your issue.

Blog: http://msnavision.blogspot.com/

Reply
Verified Answer
Suresh Kulla responded on 2 Apr 2015 2:05 PM

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

Suresh Kulla
Navision Consultant

ArcherPoint, Inc    http://www.archerpoint.com

https://twitter.com/skkulla
Please verify the answer, if it helps to resolve your issue.

Blog: http://msnavision.blogspot.com/

Reply
Verified Answer
Edward L responded on 2 Apr 2015 2:12 PM

 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. 

Reply
Verified Answer
Suresh Kulla responded on 2 Apr 2015 2:31 PM

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.

Suresh Kulla
Navision Consultant

ArcherPoint, Inc    http://www.archerpoint.com

https://twitter.com/skkulla
Please verify the answer, if it helps to resolve your issue.

Blog: http://msnavision.blogspot.com/

Reply