Skip to main content

Notifications

Microsoft Dynamics NAV forum

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

Posted on by Microsoft Employee

Hi

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.

domanda.png

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

  • Verified answer
    keoma Profile Picture
    keoma 32,671 on at
    RE: creating a factbox based upon a multiple line selection instead of typical one line selection

    edit page 9082 "Customer Statistics FactBox".

    add global variable SumCredLimit (decimal) to page.

    add new line in page with sourceexpr = SumCredLimit.

    ccl4.png

    add new global function SetSumCredLimit.

    ccl2.PNG

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

    ccl3.png

    edit page code (F9).

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

    add following code to trigger:

    ccl4.png

    save and close.

    run windows client, goto customer list.

    result:

    ccl5.png

    cheers

  • Rabin Profile Picture
    Rabin 2,976 on at
    RE: creating a factbox based upon a multiple line selection instead of typical one line selection

    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.

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

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

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,802 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,129 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,154

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans