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
TamilSelvan it Works - Thanks a lot dear :)
okay let me try - thank you
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();
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
Hi Maqbool Niazi,
You can write the select statement with required condition, just above the insert by selecting particular projId (temporary table - ProjId).
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,134 Super User 2024 Season 2
Martin Dráb 229,928 Most Valuable Professional
nmaenpaa 101,156