Error on the ssrs report

Kinetic ERP
, ,
1

HI Epicor Community,

I’m trying to develop and test an SSRS Report, but it seems after I upload it and try generate, I got an error, cant find the exact error as shown below.

image
image1792×438 24.1 KB

below is my query dataset expression

=“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,
T4.WarehouseCode
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 "

need your expertise on this

2

just guessing, could it be that your quotes are different here?
=“SELECT T1.ReqNum,
and
FROM ReqHead_”

is should be
"

3

Please verify that there is a space AFTER the T4.WarehouseCode.

I have been bitten by the invisible space monster too many many times to admit to.

DaveO

1 Like
4

Hi Ziqqie…

Just copy this code and paste in SSRS query dataset expression…

=“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,
T4.WarehouseCode
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"

5

If you would use 3 backticks ` around any code, you will get code area and it should display properly with correct formatting

=“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,
T4.WarehouseCode
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 "

Most likely is the quotes should be

"

Like @Justas explained
For detailed information on formatting, please see : Code Syntax Highlighting in Posts

6

Ok got it @DaveOlender and yes it was the space, it was just a simple error urgh anyway thank you very much for the help