creating a factbox based upon a multiple line selection instead of typical one line selection

(0) Share

Report

Posted on by Community Member

I need to create a FactBox showing results based upon all the lines selected by the user and not the last one. Just simply like Excel when you select multiple cells and you easly see the sum.

Looking the picture, I need the credit limit in the factbox be the sum of the two selected line values and not just the last one.

thank you

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Rabin 2,976 on at

Like (0)

Report
Copy link

Link copied!

Hi Giangua,

Fact boxes are used to give the details of the selected record. Since you want complex level of functionality you can either create Query or a report or can export the record into excel and use the Excel functionality.

--------------------

Was this reply helpful? Yes No
Verified answer

keoma 32,729 on at

Like (3)

Report
Copy link

Link copied!

edit page 9082 "Customer Statistics FactBox".

add global variable SumCredLimit (decimal) to page.

add new line in page with sourceexpr = SumCredLimit.

add new global function SetSumCredLimit.

save and close.

edit page 21 customer list.

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".

edit page code (F9).

goto trigger OnAfterGetCurrRecord, add local variable Cust (record|Customer).

add following code to trigger:

save and close.

run windows client, goto customer list.

result:

cheers

Was this reply helpful? Yes No