Share
ReportHi Everyone,
I am having below problem for the last one week :
I need to get data from four tables :
1.PSACONTRACTLINEITEMS
2.PROJTABLE
3.SL_ProjDepartAllocation
4.dimattributeomdepartmen
currently upon input of '889' my ssrs query is showing irrelevant data , is the displaying the amount of sub-project 889-01 also may be due to same PSACONTRACTLINEITEMS.ProjInvoiceProjId
i need to show the relevant data of my project '889' via parameter projid (please see the image)
.
query :
<private void insertData()
{
PSAContractLineItems psaContractLineItems ;
SL_ProjDepartAllocation sl_ProjDepartAllocation ;
DimAttributeOMDepartment dimattributeomdepartment ;
PSAContractLineItemsSetup psaContractLineItemsSetup ;
EA_PMDReportContract contract = this.parmDataContract();
// EA_PMDReportT ea_PMDReportT ;
while select * from psaContractLineItems
join projtable where psacontractlineitems.ProjInvoiceProjId==projtable.ProjInvoiceProjId
// && projTable.Type == contract.parmProjType()
join SL_ProjDepartAllocation where SL_ProjDepartAllocation.projid==projtable.projid
join dimattributeomdepartment where dimattributeomdepartment.recid==SL_ProjDepartAllocation.DepartmentId
&& projTable.ProjId==contract.parmProjID()
//&& projTable.Type ==contract.parmProjType()
// && psaContractLineItems.ProjInvoiceProjId == projTable.ProjInvoiceProjId
// && psaContractLineItems.LineType == PSAContractLineType::TAndM
// && PSAContractLineItems.ContractLineNum == PSAContractLineItemsSetup.ContractLineNum
//inner join PSAContractLineItemsSetup on PSAContractLineItems.ContractLineNum = PSAContractLineItemsSetup.ContractLineNum
//&& psacontractlineitems.linetype==@type
//and projtable.projid=@projname
{
ea_PMDReportT.clear();
ea_PMDReportT.ProjId = projTable.ProjId;
ea_PMDReportT.EA_Percentage = sl_ProjDepartAllocation.EA_Percentage ;
ea_PMDReportT.SL_EngineeringEstimates = psaContractLineItems.SL_EngineeringEstimates ;
ea_PMDReportT.Type= projTable.Type ;
ea_PMDReportT.insert();
}
}/>
i can further explain.
thank you
*This post is locked for comments
I have the same question (0)
All responses (
Answers (
39
