web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Add a display field to...

Microsoft Dynamics AX (Archived)

Add a display field to a form. Sum of all amounts of filtered records.

(0) Share

Report

Report

Posted on by vv1984

1,087

Hi,

i have a form in ax 2012.

I want to add a display field outside the grid with the sum of the amounts of the records i get with my filters.

I dont know where to put the code for this. I can do it for marked records, but not for all the record i see in the grid. Any help?

thank you in advance

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

Brandon Wiese 17,790 on at

Like (0)

Report
Copy link

Link copied!

I think you would want to hook into the executeQuery() method of your grid's datasource, after the super() method. From there, copy the datasource's query into a new Query object, change the mode to Group, add the selection fields you want to display, and then run that query with a QueryRun object, after which you can retrieve the answer from those fields.
omesh 141 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can refer below link for the reference

http://dev.goshoom.net/en/2015/11/summarized-values-in-ax-form/

Thanks

Umesh

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans