查询报表：送检单报表

SELECT T0.[DocEntry] AS 送检单号, T0.[DocNum] AS 编号, T0.[U_TaxDate], T1.[U_ItemCode], T1.[U_ItemName]
	, T1.[U_Spec], T1.[U_MacSer], T1.[U_Qty2], T1.[U_Qty] AS 批次数量, T0.[CreateTime] AS 创建时间
	, CASE 
		WHEN T0.[U_DocType] = 'A' THEN N'来料'
		WHEN T0.[U_DocType] = 'B' THEN N'出货'
		WHEN T0.[U_DocType] = 'C' THEN N'库存'
	END AS 报检类型
	, CASE 
		WHEN T1.[U_OQADEntry] = '-1' THEN N'已报检'
		WHEN T1.[U_OQADEntry] <> '-1' THEN N'已检验'
	END AS 单据状态, T1.[U_BaseNum], T1.[U_BaseLine], T1.[U_OQADEntry]
FROM [dbo].[@OQAS] T0
	INNER JOIN [dbo].[@QAS1] T1 ON T1.docentry = t0.docentry
WHERE (T1.[U_ItemCode] >= '[%0]'
		OR '[%0]' = '')
	AND (T1.[U_ItemCode] <= '[%1]'
		OR '[%1]' = '')
	AND (T1.[U_ItemName] >= '[%2]'
		OR '[%2]' = '')
	AND (T1.[U_ItemName] <= '[%12]'
		OR '[%12]' = '')
	AND (T0.[U_TaxDate] >= '[%3]'
		OR '[%3]' = '')
	AND (T0.[U_TaxDate] <= '[%13]'
		OR '[%13]' = '')
	AND (T0.[U_DocType] >= '[%4]'
		OR '[%4]' = '')
	AND (T0.[U_DocType] <= '[%14]'
		OR '[%14]' = '')
	AND (T0.[U_DeptName] >= '[%5]'
		OR '[%5]' = '')
	AND (T0.[U_DeptName] <= '[%15]'
		OR '[%15]' = '')
	AND (T0.[U_UserName1] >= '[%6]'
		OR '[%6]' = '')
	AND (T0.[U_UserName1] <= '[%16]'
		OR '[%16]' = '')
	AND (T0.[U_CardCode] >= '[%7]'
		OR '[%7]' = '')
	AND (T0.[U_CardCode] <= '[%17]'
		OR '[%17]' = '')
	AND (T0.[U_CardName] >= '[%8]'
		OR '[%8]' = '')
	AND (T0.[U_CardName] <= '[%18]'
		OR '[%18]' = '')
	AND (T0.[DocEntry] >= [%9]
		OR [%9] = '')
	AND (T0.[DocEntry] <= [%19]
		OR [%19] = '')
ORDER BY T0.[DocEntry] DESC

五六零

海报 链接