Microsoft Dynamics AX (Archived)

Query as FormDataSource, are aggregate fields not working properly?

(0) Share

Report

Posted on by vv1984

1,085

Hi,

i'm doing a simple form with a query as datasource.

The query joins SalesTable with CustInvoiceJour and CustInvoiceTrans. I'm trying to group by a custom field on custTable and then retrieve the sum of LineAmount of invoices trans.

This works like a charm when i use this query in a view. But when I put it as datasource on a form all the amounts are zero. Is there a specific method to calculate aggregate fields as Sums?

Thank you in advance

*This post is locked for comments

All responses (3)

Answers (0)

Martin Dráb 229,918 Most Valuable Professional on at

Like (1)

Report

RE: Query as FormDataSource, are aggregate fields not working properly?

Aha, OK.
Martin Dráb 229,918 Most Valuable Professional on at

Like (0)

Report

RE: Query as FormDataSource, are aggregate fields not working properly?

I'm not aware of any such problem. Are you able to reproduce it in a minimized scenario (query with two fields, a form without anything else)? If so, can you share it?
Suggested answer

vv1984 1,085 on at

Like (0)

Report

RE: Query as FormDataSource, are aggregate fields not working properly?

Sorry guys, found it.

For your information:

you have to set the Fields node's "Dynamic" property to "No" and then add a new Sum field.

Then you are able to add this Sum field in your Form's grid as if it was an actual field of your datasource.