Display method for Ssrs report ax 2012

Finance and Operations/AX Developer Forum
1

I have one requirement one of client

I want get the total quantity in the report

I have 3 (customization fields )in my table (i.e prodtable)

3 field names >> 1) No of up’s

2).No of sheets

3).TotalQuantity

I want code for display method to display total quantity on ssrs report

Total quantity = no of up’s * no of sheets

Public display TotalQuantity total()

{

TotalQuantity = prodtable.no of up’s * prodtable .no of sheets;

Return TotalQuantity;

}

2

Where you are trying to write that method? Is that a query based or DP based report?

3

Hi kranthi,

Thanks for the reply . I wrote code at table level (prodtable)

This query based report not rdp …

4

What issue do you have?

5

Hi kranthi ,
I am unble to get the value on the Ssrs report with above code at display method @prodtable level
Can you please suggest me above code is correct ?if not please give code please for above scenario

6

Does your method compiles? See the below example code.

display TotalQuantity total()

{
TotalQuantity totalQuantity; // considering the TotalQuantity is an EDT

totalQuantity = this.noofups * this.noofsheets;

Return TotalQuantity;

}