web

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

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

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Brandon Wiese 17,788 on at

Like (0)

Report

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

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.

Was this reply helpful? Yes No
omesh 141 on at

Like (0)

Report

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

Hi,

You can refer below link for the reference

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

Thanks

Umesh

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

#2

Alexey Lekanov 3

#3

Scott_itD 2 Community Manager

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans