Adding JobHead Table To (SSRS)Packslip Form

Kinetic ERP
1

Hello Everyone,

I added the JobHead to the Packslip (Data Definition)
image

I added the information below on the expression:
FROM ShipHead_" + Parameters!TableGuid.Value + " T1
LEFT OUTER JOIN ShipDtl_" + Parameters!TableGuid.Value + " T2
ON T1.Company = T2.Company AND T1.PackNum = T2.PackNum
LEFT OUTER JOIN RptLabels_" + Parameters!TableGuid.Value + " T3
ON T1.RptLanguageID = T3.RptLanguageID
LEFT OUTER JOIN Part_" + Parameters!TableGuid.Value + " T4
ON T1.Company = T4.Company and T2.PartNum = T4.PartNum
LEFT OUTER JOIN JobHead_" + Parameters!TableGuid.Value + " T5
ON T2.Company = T5.Company and T2.JobNum = T5.JobNum"

Added
T5.JobNum,
T5.Character08,

And no field appears on the form:
I have the fields appear but nothing from the Job Table and I made sure the fields are not excluded.

Thanks in Advance.

Miguel

2

Once you add the table and fields to the expression you also have to add the fields. I use Report Builder for SSRS reports. I right click my dataset and in the data set propertiesAfter I add the table and fields to the expression (I’m using Job Traveler as my example) I click Fields, click Add, scroll to the bottom of the list and add my fields.

image
image656×679 19.1 KB

The fields should then show up for the report and have data for them. HTH.