# Transfer Pack **URL:** \ **Category:** Epicor ERP 10\ **Tags:** sql, e10, reports, ssrs\ **Created:** [August 19, 2022, 12:47pm UTC](https://www.epiusers.help/t/transfer-pack/93549 "2022-08-19T12:47:53Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![kristajenn21](https://www.epiusers.help/letter_avatar_proxy/v4/letter/k/a3d4f5/32.png) [@kristajenn21](https://www.epiusers.help/u/kristajenn21)\ **Post date:** [August 19, 2022, 12:47pm UTC](https://www.epiusers.help/t/transfer-pack/93549/1 "2022-08-19T12:47:53Z")
Hello! I’m trying to include the Shipping and/or Picking Comments from the Transfer Order Entry to the Transfer Pack Report. I’m a super novice at reports so bear with me 🙂 I added the TFOrdHed Table to the Data definition. I included the ShipComment and PickListComment fields from the TFOrdHed table. I added the new fields in the Dataset Properties query field. I tried to add the field where the label for part description was so that there wouldn’t be any visibility issues with the field or the row…the blue section is where I’m trying to add the Pick List Comment… But when I add the field in the report, it comes through blank. No errors, just blank…not sure what I am doing wrong? =“SELECT T3.PickListComment,T1.LegalNumber,CAST( T1.PackNum as decimal ) as PackNum,T1.ShipComment,T1.ShipDate,T1.Calc\_FromAddr,CAST( T1.Calc\_NumRecordPerPage as decimal ) as Calc\_NumRecordPerPage,T1.Calc\_ShipVia,T1.Calc\_ToAddr,T1.Calc\_CarrierDesc, T2.ExtPrice,T2.LineDesc,CAST( T2.PackLine as decimal ) as PackLine,T2.PartNum,T2.RevisionNum,T2.ShipComment as TFShipDtl\_ShipComment,T2.TFOrdNum,T2.UnitPrice,T2.Calc\_GetNextLegalNum,T2.Calc\_LineShipQty,T2.Calc\_NextLegalNumber,T2.Calc\_PlannedQty,T2.Calc\_SerialNumber,T2.Calc\_SerialNumLabl,T2.Calc\_UOM,CAST( T2.Calc\_PackLine as nvarchar ) as Calc\_PackLine FROM TFShipHead\_” + Parameters!TableGuid.Value + " T1 LEFT OUTER JOIN TFShipDtl\_" + Parameters!TableGuid.Value + " T2 ON T1.Company = T2.Company AND T1.PackNum = T2.PackNum LEFT OUTER JOIN TFOrdHed\_" + Parameters!TableGuid.Value + " T3 ON T2.Company = T3.Company AND T2.TFOrdNum = T3.TFOrdNum" ![Screenshot 2022-08-19 075034](https://www.epiusers.help/uploads/default/original/3X/b/3/b3f77ab7ead52d7fe0c00605f15e774f6740ace7.jpeg) ![Screenshot 2022-08-19 075518](https://www.epiusers.help/uploads/default/original/3X/e/8/e846be68c470661ffe143753cba06b45c392c98d.jpeg) ---
**Author:** ![estm8ben](https://www.epiusers.help/letter_avatar_proxy/v4/letter/e/b9e5f3/32.png) [@estm8ben](https://www.epiusers.help/u/estm8ben)\ **Post date:** [August 19, 2022, 3:31pm UTC](https://www.epiusers.help/t/transfer-pack/93549/2 "2022-08-19T15:31:55Z")
The simple starting point is are you sure the PickListComment has content? Because it looks like you have a thorough attack on the report alteration. ---
**Author:** ![kristajenn21](https://www.epiusers.help/letter_avatar_proxy/v4/letter/k/a3d4f5/32.png) [@kristajenn21](https://www.epiusers.help/u/kristajenn21)\ **Post date:** [August 19, 2022, 3:34pm UTC](https://www.epiusers.help/t/transfer-pack/93549/3 "2022-08-19T15:34:26Z")
Yes, we chose examples with content in both the PickListComment field as well as the ShipComment field…I wonder if it could be a bug…I ran across this in the history of the forum? ![Screenshot 2022-08-19 103406](https://www.epiusers.help/uploads/default/original/3X/2/7/279229272e094ba628419d11800c9fe83840570b.jpeg) ---
**Author:** ![estm8ben](https://www.epiusers.help/letter_avatar_proxy/v4/letter/e/b9e5f3/32.png) [@estm8ben](https://www.epiusers.help/u/estm8ben)\ **Post date:** [August 19, 2022, 3:42pm UTC](https://www.epiusers.help/t/transfer-pack/93549/4 "2022-08-19T15:42:30Z")
Have you verified that the TFOrdNum populates on the TFShipDtl? Maybe checked that in a BAQ. That could be missing and therefore your T3 table would get ignored. ---
**Author:** ![kristajenn21](https://www.epiusers.help/letter_avatar_proxy/v4/letter/k/a3d4f5/32.png) [@kristajenn21](https://www.epiusers.help/u/kristajenn21)\ **Post date:** [August 19, 2022, 3:45pm UTC](https://www.epiusers.help/t/transfer-pack/93549/5 "2022-08-19T15:45:00Z")
I do get it to come through on a baq with the following query (the person who entered the comments duplicated in both fields so I could test them both but they are correct)… (thank you so much for your time, btw!!) ![Screenshot 2022-08-19 104414](https://www.epiusers.help/uploads/default/original/3X/5/4/548c709bdf77e2e2b75448d2f0bd2200261b9696.jpeg) select [TFShipHead].[PackNum] as [TFShipHead\_PackNum], [TFShipHead].[ShipDate] as [TFShipHead\_ShipDate], [TFShipDtl].[PackLine] as [TFShipDtl\_PackLine], [TFShipDtl].[PartNum] as [TFShipDtl\_PartNum], [TFShipDtl].[LineDesc] as [TFShipDtl\_LineDesc], [TFOrdHed].[ShipComment] as [TFOrdHed\_ShipComment], [TFOrdHed].[PickListComment] as [TFOrdHed\_PickListComment] from Erp.TFShipHead as TFShipHead inner join Erp.TFShipDtl as TFShipDtl on TFShipHead.Company = TFShipDtl.Company and TFShipHead.PackNum = TFShipDtl.PackNum and ( TFShipDtl.TFOrdNum = ‘XFER002020’ ) inner join Erp.TFOrdHed as TFOrdHed on TFShipDtl.Company = TFOrdHed.Company and TFShipDtl.TFOrdNum = TFOrdHed.TFOrdNum ---
**Author:** ![tsmith](https://www.epiusers.help/user_avatar/www.epiusers.help/tsmith/32/64774_2.png) [@tsmith](https://www.epiusers.help/u/tsmith)\ **Post date:** [August 19, 2022, 6:29pm UTC](https://www.epiusers.help/t/transfer-pack/93549/6 "2022-08-19T18:29:55Z")
Try changing the relation type in your RDD from “Definition only” to “Output”. This is the only way I’ve consistently been able to get results when adding tables to RDDs. ---
**Author:** ![kristajenn21](https://www.epiusers.help/letter_avatar_proxy/v4/letter/k/a3d4f5/32.png) [@kristajenn21](https://www.epiusers.help/u/kristajenn21)\ **Post date:** [August 19, 2022, 7:10pm UTC](https://www.epiusers.help/t/transfer-pack/93549/7 "2022-08-19T19:10:10Z")
OMG, that worked!!! You are my hero! Thank you so so much!!