Query as FormDataSource, are aggregate fields not working properly?

(0) Share

Report

Posted on by vv1984

1,087

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

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

vv1984 1,087 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.

Was this reply helpful? Yes No
Martin Dráb 236,857 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?

Was this reply helpful? Yes No
Martin Dráb 236,857 Most Valuable Professional on at

Like (1)

Report

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

Aha, OK.

Was this reply helpful? Yes No