Use of DocKey@ in Crystal Reports

[Former Member]

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

[Former Member · Accepted solution]

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.

[Former Member · Accepted solution]

You are right Thomas.

I found it few minutes ago.  DocKey@ must be equated with the Primary key.  DocEntry is the primary key of ORDR table.

Thank you very much.

Noel

[kothandaraman_nagarajan]

Hi,

If you got answer, please close this thread.

Thanks & Regards,

Nagarajan

[kothandaraman_nagarajan]

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

[Former Member]

Thanks Nagarajan.

Warm Regards,

Noel