How to sum data according to page filter in Dynamics NAV 2009 R2?

Dynamics 365 Business Central/NAV Developers Forum
1

I think on every list page has their own default data filter.

Then how would I know what is user currently filter on page if I want to sum data according to that filter ?

It’s not CurrPage.SetSelectionFilter right ? [:(]

2

Hi Vorasage,

Welcome to the user group! [:)]

I’m not quite sure what you’re trying to do. But SETSELECTIONFILTER is used to MARK the records the user selected, but if none where selected (marked), then it will not get anything.

Filters are “same same but different”! [;)] Filters are either set by the developer directly on the page, or by the user, by using the Advanced or simple filters on the page. You get these filters with the record bound filter functions like COPYFILTER/S or GETFILTER/S.

3

Thank you for your attention.

I want to show summary data according to the filter on page at the bottom similar to the Journal pages.

Now I know how to calculate it, but I stuck in a new problem. Summary data doesn’t change after filter until I double click it to edit mode. I tried CurrPage.Update but nothing change. Can you give me any solution ?