I have a dashboard I created a few years back with no problem. I have updated the query to add the warehouse name to the parts query. I already have a few tracker fields; a couple combo boxes for part type and part status and a couple textboxes for part number and description. Everything works great. I am now trying to add a combo box to filter on warehouse name. I have tried an EpiCombo and BAQCombo and both do nothing, just a blank combo box. Not sure what I missed in the setup. Any help would be appreciated.
Dashboard BAQ
select distinct
[Part].[TypeCode] as [Part_TypeCode],
((case when Part.TypeCode = 'M' then 'Manufactured' else (case when Part.TypeCode = 'P' then 'Purchased' else '' end) end)) as [Calculated_PartType],
[Part].[InActive] as [Part_InActive],
((case when Part.InActive = 1 then 'Inactive' else 'Active' end)) as [Calculated_PartStatus],
[Part].[PartNum] as [Part_PartNum],
[Part].[PartDescription] as [Part_PartDescription],
[Part].[SearchWord] as [Part_SearchWord],
[PurAgent].[Name] as [PurAgent_Name],
[Part].[NonStock] as [Part_NonStock],
[Part].[QtyBearing] as [Part_QtyBearing],
[Part].[CostMethod] as [Part_CostMethod],
(case
when Part.CostMethod = 'A' then 'Average'
when Part.CostMethod = 'L' then 'Last'
when Part.CostMethod = 'S' then 'Standard'
when Part.CostMethod = 'T' then 'Avg by Lot'
else ''
end) as [Calculated_CostMethod],
[PartPlant].[BackFlush] as [PartPlant_BackFlush],
[PartPlant].[GenerateSugg] as [PartPlant_GenerateSugg],
[Part].[UOMClassID] as [Part_UOMClassID],
[Part].[IUM] as [Part_IUM],
[Part].[SalesUM] as [Part_SalesUM],
[Part].[PUM] as [Part_PUM],
[Part].[ProdCode] as [Part_ProdCode],
[ProdGrup].[Description] as [ProdGrup_Description],
[Part].[ClassID] as [Part_ClassID],
[PartClass].[Description] as [PartClass_Description],
[Part].[MtlAnalysisCode] as [Part_MtlAnalysisCode],
[Part].[NetWeight] as [Part_NetWeight],
[Part].[NetWeightUOM] as [Part_NetWeightUOM],
((case when Part.NetWeight = 0 then '' else Part.NetWeightUOM end)) as [Calculated_NetWeightUOM],
[Part].[PartLength] as [Part_PartLength],
[Part].[PartWidth] as [Part_PartWidth],
[Part].[PartLengthWidthHeightUM] as [Part_PartLengthWidthHeightUM],
[Part].[Thickness] as [Part_Thickness],
[Part].[ThicknessUM] as [Part_ThicknessUM],
[PartPlant].[ReOrderLevel] as [PartPlant_ReOrderLevel],
[PartPlant].[MinimumQty] as [PartPlant_MinimumQty],
[PartPlant].[MaximumQty] as [PartPlant_MaximumQty],
[PartPlant].[MinOrderQty] as [PartPlant_MinOrderQty],
[PartPlant].[LeadTime] as [PartPlant_LeadTime],
[PartPlant].[MfgLotMultiple] as [PartPlant_MfgLotMultiple],
[PartPlant].[DaysOfSupply] as [PartPlant_DaysOfSupply],
[Part].[MtlBurRate] as [Part_MtlBurRate],
(PartCost.StdLaborCost + PartCost.StdBurdenCost + PartCost.StdMaterialCost + PartCost.StdSubContCost + PartCost.StdMtlBurCost) as [Calculated_StdTotalCost],
(PartCost.AvgLaborCost + PartCost.AvgBurdenCost + PartCost.AvgMaterialCost + PartCost.AvgSubContCost + PartCost.AvgMtlBurCost) as [Calculated_AvgTotalCost],
(PartCost.LastLaborCost + PartCost.LastBurdenCost + PartCost.LastMaterialCost + PartCost.LastSubContCost + PartCost.LastMtlBurCost) as [Calculated_LastTotalCost],
[SubQuery2].[Calculated_LastPurchaseDate] as [Calculated_LastPurchaseDate],
((case when (ProdGrup.Description) is null then '' else ProdGrup.Description end)) as [Calculated_ProdGrup_Description],
[SubQuery3].[PartTran1_PONum] as [PartTran1_PONum],
[PartWhse].[DemandQty] as [PartWhse_DemandQty],
[PartWhse].[OnHandQty] as [PartWhse_OnHandQty],
((case when (SubQuery5.Calculated_OrderQty) is null then 0 else SubQuery5.Calculated_OrderQty end)) as [Calculated_QtyOnOrder],
[Warehse].[Name] as [Warehse_Name]
from Erp.Part as Part
left outer join Erp.PartClass as PartClass on
Part.Company = PartClass.Company
and Part.ClassID = PartClass.ClassID
left outer join Erp.PartPlant as PartPlant on
Part.Company = PartPlant.Company
and Part.PartNum = PartPlant.PartNum
left outer join Erp.PurAgent as PurAgent on
PartPlant.Company = PurAgent.Company
and PartPlant.BuyerID = PurAgent.BuyerID
left outer join Erp.ProdGrup as ProdGrup on
Part.Company = ProdGrup.Company
and Part.ProdCode = ProdGrup.ProdCode
inner join Erp.PartCost as PartCost on
Part.Company = PartCost.Company
and Part.PartNum = PartCost.PartNum
left outer join (select
[Part1].[PartNum] as [Part1_PartNum],
(max( PartTran.TranDate )) as [Calculated_LastPurchaseDate]
from Erp.Part as Part1
inner join Erp.PartTran as PartTran on
Part1.Company = PartTran.Company
and Part1.PartNum = PartTran.PartNum
and ( PartTran.TranClass = 'R' and PartTran.TranType = 'PUR-STK' )
group by Part1.PartNum) as SubQuery2 on
Part.PartNum = SubQuery2.Part1_PartNum
left outer join (select
[PartTran1].[PartNum] as [PartTran1_PartNum],
[PartTran1].[TranClass] as [PartTran1_TranClass],
[PartTran1].[TranType] as [PartTran1_TranType],
[PartTran1].[TranDate] as [PartTran1_TranDate],
[PartTran1].[MtlUnitCost] as [PartTran1_MtlUnitCost],
[PartTran1].[LbrUnitCost] as [PartTran1_LbrUnitCost],
[PartTran1].[BurUnitCost] as [PartTran1_BurUnitCost],
[PartTran1].[SubUnitCost] as [PartTran1_SubUnitCost],
[PartTran1].[MtlBurUnitCost] as [PartTran1_MtlBurUnitCost],
[PartTran1].[ExtCost] as [PartTran1_ExtCost],
[PartTran1].[VendorNum] as [PartTran1_VendorNum],
[PartTran1].[JobNum] as [PartTran1_JobNum],
[PartTran1].[AssemblySeq] as [PartTran1_AssemblySeq],
[PartTran1].[JobSeqType] as [PartTran1_JobSeqType],
[PartTran1].[JobSeq] as [PartTran1_JobSeq],
[PartTran1].[PONum] as [PartTran1_PONum],
[PartTran1].[POLine] as [PartTran1_POLine],
[PartTran1].[PORelNum] as [PartTran1_PORelNum],
[PartTran1].[OrderNum] as [PartTran1_OrderNum],
[PartTran1].[OrderLine] as [PartTran1_OrderLine],
[PartTran1].[OrderRelNum] as [PartTran1_OrderRelNum]
from Erp.PartTran as PartTran1
where (PartTran1.TranClass = 'R' and PartTran1.TranType = 'PUR-STK' and PartTran1.ExtCost >= 0)) as SubQuery3 on
SubQuery2.Part1_PartNum = SubQuery3.PartTran1_PartNum
and SubQuery2.Calculated_LastPurchaseDate = SubQuery3.PartTran1_TranDate
left outer join Erp.PartWhse as PartWhse on
Part.Company = PartWhse.Company
and Part.PartNum = PartWhse.PartNum
inner join Erp.Warehse as Warehse on
PartWhse.Company = Warehse.Company
and PartWhse.WarehouseCode = Warehse.WarehouseCode
left outer join (select
[PODetail].[PartNum] as [PODetail_PartNum],
(sum( PORel.RelQty - PORel.ReceivedQty )) as [Calculated_OrderQty]
from Erp.POHeader as POHeader
left outer join Erp.PODetail as PODetail on
POHeader.Company = PODetail.Company
and POHeader.PONum = PODetail.PONUM
and ( PODetail.OpenLine = 1 and PODetail.VoidLine = 0 )
inner join Erp.PORel as PORel on
PODetail.Company = PORel.Company
and PODetail.PONUM = PORel.PONum
and PODetail.POLine = PORel.POLine
and ( PORel.OpenRelease = 1 and PORel.VoidRelease = 0 )
where (POHeader.OpenOrder = 1 and POHeader.VoidOrder = 0)
group by PODetail.PartNum) as SubQuery5 on
Part.PartNum = SubQuery5.PODetail_PartNum
order by Part.PartNum
Dashboard
