查询报表：不良品处理单报表

SELECT T0.[U_DocType], T0.[U_TaxDate] AS 不良品单日期, T0.[U_BaseEntry], T0.[U_BaseEntry2], T0.[DocEntry] AS 不良品单号
	, T0.[U_CardName], T0.[U_ItemCode], T0.[U_ItemName], T0.[U_Spec], T0.[U_Qty]
	, T1.[U_Qty1], T1.[U_Qty2], T1.[U_QAItem], T1.[U_QALevel], T1.[U_AQL]
	, T1.[U_AC], T1.[U_RE], T1.[U_P1], T1.[U_Memo], T1.[U_IsPass]
	, T1.[U_Item], T0.[U_UserName1], T0.[U_UserName2]
FROM [dbo].[@OQAE] T0
	INNER JOIN [dbo].[@QAE1] T1 ON T1.docentry = t0.docentry
WHERE (T0.[U_ItemCode] >= '[%0]'
		OR '[%0]' = '')
	AND (T0.[U_ItemCode] <= '[%1]'
		OR '[%1]' = '')
	AND (T0.[U_ItemName] >= '[%2]'
		OR '[%2]' = '')
	AND (T0.[U_ItemName] <= '[%12]'
		OR '[%12]' = '')
	AND (T0.[U_TaxDate] >= '[%3]'
		OR '[%3]' = '')
	AND (T0.[U_TaxDate] <= '[%13]'
		OR '[%13]' = '')
	AND (T0.[U_CardName] >= '[%5]'
		OR '[%5]' = '')
	AND (T0.[U_CardName] <= '[%15]'
		OR '[%15]' = '')
	AND (T0.[U_DocType] >= '[%4]'
		OR '[%4]' = '')
	AND (T0.[U_DocType] <= '[%14]'
		OR '[%14]' = '')
	AND (T0.[DocEntry] >= [%9]
		OR [%9] = '')
	AND (T0.[DocEntry] <= [%19]
		OR [%19] = '')
ORDER BY T0.[DocEntry] DESC

五六零

海报 链接