Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

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

(0) ShareShare
ReportReport
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,675 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,431 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,503 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans