on 09-18-2014 9:02 PM
Hello Experts;
I created a Crystal Report that uses a Command as follows:
SELECT | T0.DocNum | AS 'Sales Order Number' |
-- , T0.DocEntry
-- , T1.DocEntry
-- , T2.BaseEntry
-- , T2.DocEntry
-- , T3.DocEntry
-- | , T0.CardCode |
-- | , T0.CardName |
, T1.ItemCode | AS 'Item Code' |
-- , T2.ItemCode
, T1.Dscription | AS 'Description' | |
, T1.Quantity | AS 'Order Quantity' |
, T3.ShipToCode | AS 'Customer' | |
, T3.Address2 | AS 'Shipment Address' |
, T2.ShipDate | |||
, T3.DocNum | AS 'Delivery Number' | ||
, T3.TrackNo | AS 'Tracking Number' | ||
, T3.U_NPH_ShipmentETA | AS 'Shipment ETA' | ||
, T2.Quantity | AS 'Shipment Quantity' | ||
FROM | ORDR T0 | ||
LEFT | JOIN | RDR1 T1 ON T1.DocEntry = T0.DocEntry | |
LEFT | JOIN | DLN1 T2 ON T2.BaseEntry | = T1.DocEntry AND T2.ItemCode = T1.ItemCode |
LEFT | JOIN | ODLN T3 ON T3.DocEntry | = T2.DocEntry |
WHERE T0.DocNum = {?DocKey@}
ORDER BY T0.CardCode, T3.Address2
The Crystal Reports version is 2008 and this particular report is imported into SAP Business One v8.82 as a layout with a document type of RDR2 -Order (Items).
When executed in Sales A/R ==> Sales Order ==> Preview Layouts, the report shows but has no data on it. Kindly advice what is wrong with this.
Thank you very much in Advance.
Warm Regards,
Noel
You have T0.DocNum = {?DocKey@}, but the DocKey@ token reflects the current document's DocEntry. Change it to T0.DocEntry = {?DocKey@} and it should then work as you're expecting.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
If you got answer, please close this thread.
Thanks & Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
If you run above query in SAP B1 query generator, you can also find the problem before import crystal report.
Please close this thread by marking correct answer to Mr.Thomas.
Thanks & Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
8 | |
6 | |
6 | |
5 | |
4 | |
3 | |
2 | |
2 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.