How to create group totals in visual studio reporting tools for ax 2009

Finance and Operations/AX Developer Forum
1

I am proficient in SQL Server 2008 Reporting Services. I was told that the VS reporting tools for AX were very much like SSRS. But it seems quite different. I managed to get a report created today. I then added some groups. I have the customer name to display once and then have a list of invoices display. In the list of invoices, I have the invoice amount. I want to total all the invoice amounts for each customer. How can I do this?

Thanks,

Bob

2

In case you are still looking out for a solution, edit your report desgin. At any field, right click and look out for ‘Expressions’. Check ‘common functions’ and ‘Operators’. They offer a whole lot of options for calculations. For invoice amount, at the footer of the table you can use function ‘sum(fieldName)’.