Hey,
I know it's been covered, but I'm flailing.
I want the JobClosed field on the WIP Report. So I:
1. Duplicate WIPReport to WIPReport2.
2. Add Table JobHead
3. Add New Table Exclusion for JobClosed, uncheck excluded box.
4. Add New Relationship for TWip and JobHead on Company and JobNum
5. Add new style, reference custom report and WIPReport2.
6. Add field to query in custom report. (="SELECT T1.BurdenCOS,T1.BurdenCTI,T1.Company,T1.CompletedQty,T1.IUM,T1.JobNum,T1.LaborCOS,T1.LaborCTI,T1.MaterialCOS,T1.MaterialCTI,T1.MtlBurCOS,T1.MtlBurCTI,T1.PartDescription,T1.PartNum,T1.Plant,T1.PlantDesc,T1.ProdCode,T1.ProdDesc,T1.ProdQty,T1.QtyShipped,T1.QtyToInventory,T1.RevisionNum,T1.SubContractCOS,T1.SubcontractCTI,T1.TDBurdenCost,T1.TDLaborCost,T1.TDMaterialCost,T1.TDMtlBurCost,T1.TDSubcontractCost,T1.RptLanguageID,T1.JobClosed
FROM TWip_" + Parameters!TableGuid.Value + " T1")
7. Run report. I get:
Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask: System.Web.Services.Protocols.SoapException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'TWip'. ---> System.Data.SqlClient.SqlException: Invalid column name 'JobClosed'.
I've tried not adding exclusions, adding exclusions before and after adding the relationships. Deleted the style and RDD and re-added the details in different orders.
Bumping my head.
Thanks,
Joe
--
Joe D. Trent
Bigham Ag Equipment