Microsoft Dynamics AX (Archived)

How to get sum of field(totalcostamountcur) from ProjEmplTable in Existing Report

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi Everyone,

i am having problem in adding other table data (ProjEmplTable) in Existing report.

I have an existing report name "Project Throughput report Summary" and i want to add sum of field

named TotalCostAmountCur from ProjEmplTable.

Required :

1. I want to display sum of TotalCostAmountCur filtered/based on Proj id and LineProperty=Billable on my existing report.

Can someone guide me where i put the select code to get the Proj ID and LineProperty=Billable based data from ProjEmplTable in existing report.

thank you in advance

please see the image for further details.

note : i have modify existing x++ query to prepare my "Project Throughput report Summary

*This post is locked for comments

All responses (5)

Answers (1)

Community Member Microsoft Employee on at

Like (1)

Report

RE: How to get sum of field(totalcostamountcur) from ProjEmplTable in Existing Report

TamilSelvan it Works - Thanks a lot dear :)
Community Member Microsoft Employee on at

Like (0)

Report

RE: How to get sum of field(totalcostamountcur) from ProjEmplTable in Existing Report

okay let me try - thank you
Verified answer

Community Member Microsoft Employee on at

Like (1)

Report

RE: How to get sum of field(totalcostamountcur) from ProjEmplTable in Existing Report

Before the insert you can write the condition like

select sum(TotalCostAmountCur) from projEmplTrans where projEmplTrans.ProjId == YourTemptable.ProjId && projEmplTrans.LinePropertyId == "Billable";

YourTemptable.TotalCostAmountCur = projEmplTrans.TotalCostAmountCur;

//This below insert will the existing insert in your dp class..

YourTemptable.insert();
Community Member Microsoft Employee on at

Like (0)

Report

RE: How to get sum of field(totalcostamountcur) from ProjEmplTable in Existing Report

thanks for your reply

Actually in my existing report there are multiple Projects(Proj id). How it can be filtered ? can you please elaborate more ?

thanks
Community Member Microsoft Employee on at

Like (0)

Report

RE: How to get sum of field(totalcostamountcur) from ProjEmplTable in Existing Report

Hi Maqbool Niazi,

You can write the select statement with required condition, just above the insert by selecting particular projId (temporary table - ProjId).