How to get the sum using autodesign report

Finance and Operations/AX Developer Forum
1

HI,

I have 1 table “test”.In that i want sum for “sal” column in the report, In the following way.when ever i am using generated design it will come output as follows but when ever i use Auto design it will show the total is:0,so how to get the sum for sal column using auto design?

5148.Untitled.png
5148.Untitled.png768×614 3.44 KB

2

Ua field:sal-> properties-sumall-yes

3

Hi shon already i put that option but sum not came?

4

Hai Naru,

Well then, have u given, autodeign-properties-grandtotal-yes??— this will print the total always!!

also you if its need to be userdefined- then while opening the report in dialog-

go to printing options and check the print grand totals check box.

Hope this will solve the problem

Regards

Shon

5

Thank you shon now it will work when ever i put Grant total=yes.

6

Hey Naru and Shon, you can got to Data Field under DATA node in the report model, and go to its properties.

Below is the detailed navigation:

Report1 → Designs → AutoDesign1 → Data → Field of your choice

In properties window, expand the Aggregation node. There set

Aggregate Function as Sum

Render Grand Total as True

Grand Total Caption as of your choice…

Hope this helps… [:)]