SSRS report no value

Kinetic ERP
,
1

Hello Epicor community, I edited the PR report and it seems when I generate for on hand qty and demand qty show no value but when I try doing BAQ there is value for these 2 value, not sure where did I go wrong. I joined reqdetail with partbin and partbin with partwhse

image

image

image

‘’‘=“SELECT
T1.ReqNum,
T1.RequestDate,
T1.ShipName,
T1.ShipAddress1,
T1.ShipAddress2,
T1.ShipAddress3,
T1.ShipCity,
T1.ShipState,
T1.ShipZIP,
T1.ShipCountry,
T1.CommentText as ReqHeadCommentText,
T1.ShipToConName,
T1.ShipCountryNum,
T1.StatusType,
T1.Calc_CurrentAction,
T1.Calc_DispatcherName,
T1.Calc_RequestedBy,
T2.TranType,
T2.ReqLine,
T2.LineDesc,
T2.IUM,
T2.DocUnitCost,
T2.Taxable,
T2.CostPerCode,
T2.PartNum,
T2.CommentText as ReqDetailCommentText,
T2.RevisionNum,
T2.DueDate,
T2.JobNum,
T2.CurrencyCode,
T2.XOrderQty,
T2.Calc_PartClass,
T2.Calc_VendorID,
T2.Calc_VendorName,
T2.Calc_AttributeSetShortDescription,
T3.OnhandQty,
T4.DemandQty
FROM ReqHead_” + Parameters!TableGuid.Value + " T1
LEFT OUTER JOIN ReqDetail_" + Parameters!TableGuid.Value + " T2
ON T1.Company = T2.Company AND T1.ReqNum = T2.ReqNum LEFT OUTER JOIN PartBin_" + Parameters!TableGuid.Value + " T3 ON T2.Company = T3.Company AND T2.PartNum = T3.PartNum LEFT OUTER JOIN PartWhse_" + Parameters!TableGuid.Value + " T4 ON T3.Company = T4.Company AND T3.PartNum = T4.PartNum AND T3.WarehouseCode = T4.WarehouseCode "’‘’

image

2

Try changing your Relation Type to “Output”.

1 Like
3

OK got it, thanks @cchang after changed it to output only it shows the value but what’s difference?

4

Field Help:

This value defines how parent and child tables are joined within the report definition. The join you select from this drop-down list determines how data between these two tables displays within the report.

Definition Only - It does not affect the report data. This type of relation is for definition only.

Output - This report displays all requested data from the parent table regardless of the linking data available within the child table.

~~
My best understanding is… if you think about it like a BAQ… you might have to link a table that isn’t really reporting any data, but then allows you to link a third table.

For example, I want data from PO release. I may have to link POHead & POLine to my RDD first in order to finally link PORel. I don’t need “data” from POHead or POLine, so I can set those as “Definition Only”… but I want DATA from PORel, so that relationship would be “Output”. I need output from PORel.

I’m assuming it is a way of speeding up your query. Definition Only will link the table, but not take the time to pull in data from the child table.

Again, this is my understanding… could be wrong.

In general, I always use “Output”. May not be optimal performance, but, I’ve never had unbearably long reporting times.

1 Like