Microsoft Dynamics AX (Archived)

Display Method for Sum of data of the fields in report

(0) Share

Report

Posted on by Community Member

I had just added one field in the report. Now i got the values but it is not display the sum of data in the field.

The Field is from Taxtrans and field name is SourceBaseAmountCur

Can you suggest only display method

*This post is locked for comments

I have the same question (0)

All responses (14)

Answers (0)

Sort by

Rohin 4,624 on at

Like (0)

Report
Copy link

Link copied!

Please look at this thread

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

It is not working

Was this reply helpful? Yes No
Rohin 4,624 on at

Like (0)

Report
Copy link

Link copied!

share your code please..

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

public display Real TotalTax()

{

TaxTrans T;

;

While Select sum(SourceBaseAmountCur) from T where simply add && T.SourceBaseAmountCur> 0

return T.SourceBaseAmountCur;

}

Was this reply helpful? Yes No
Suggested answer

Sukrut Parab 71,735 Moderator on at

Like (0)

Report
Copy link

Link copied!

If it's not working first check if your simple query is returning any value .

Your display method should be like this

Select sum(fieldname) from table

Where conditions

Return table.fieldname

Was this reply helpful? Yes No
Suggested answer

Rohin 4,624 on at

Like (0)

Report
Copy link

Link copied!

Mr. Reddy, I have shared you above thread that is merely an example. You have to write your code according to your condition. I don't see any condition in your where clause except T.SourceBaseAmountCur> 0

In shared thread Martin means "simply add && custInvoiceTrans.Qty > 0 to your where condition." that you have to add "&&" with your condition to where clause.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello Sukrut,

What is the Where condition i have to write it is only my main question.

I am getting many Errors at here.

Was this reply helpful? Yes No
Sukrut Parab 71,735 Moderator on at

Like (0)

Report
Copy link

Link copied!

we don't know business requirement . You know business requirement better than us. Based on you requirement include condition on table to select data.

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Instead of a display method, can't you use a expression on the new field like

=Fields!Taxtrans.Value + Fields! SourceBaseAmountCur.Value (substitute column values from report design in Visual studio) (or) do you have any specific business logic.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

It is just to display the amount of CGST, SGST and IGST in report

Was this reply helpful? Yes No