Tuesday, October 10, 2017

How to display sum value in factbox on base of multiple line selection

How to display sum value in factbox on base of multiple line selection
Typical issue is to show a calculated value in a factbox on base of the currently selected line in a list page or the lines in a subpage. Is it possible to get a calculated value on base of more than one selected line? Let’s check out.
Let’s say we want to display the sum of field “Credit Limit” in the customer list when selecting multiple lines. So first we edit page 9082 “Customer Statistics FactBox”. There we add a global variable SumCredLimit (decimal) to the page, then we add a new line in page with sourceexpr = SumCredLimit.




Now we add a new global function SetSumCredLimit.



Save and close the page. Now we edit page 22 customer list. There we rename page part “Customer Statistics FactBox” to CustStatFbx. That’s needed, so that we can reach the custom functions in page “Customer Statistics FactBox” from page “customer list”.



After that edit the page code (F9). Goto trigger OnAfterGetCurrRecord, there add local variable Cust (record|Customer). Add following code to trigger:



Save and close the page. Now run the Nav windows client and goto customer list.
The result:


Reference: jonthan




Popular Posts