查询报表：检验单报表

SELECT T0.[DocEntry] AS 检验单号, T0.[DocNum] AS 编号, T0.[U_CardName], T0.[U_ItemCode], T0.[U_Spec]
	, CASE 
		WHEN T1.[U_QAItem] = 'A' THEN N'尺寸'
		WHEN T1.[U_QAItem] = 'B' THEN N'外观'
		WHEN T1.[U_QAItem] = 'C' THEN N'可靠性能'
	END AS '检验项目'
	, CASE 
		WHEN T1.[U_QALevel] = '1' THEN N'MIL-STD-105E-1级'
		WHEN T1.[U_QALevel] = '2' THEN N'MIL-STD-105E-2级'
		WHEN T1.[U_QALevel] = '3' THEN N'MIL-STD-105E-3级'
		WHEN T1.[U_QALevel] = '0' THEN N'MIL-STD-105E-0缺陷'
	END AS '检验水平', T1.[U_AQL], T1.[U_AC], T1.[U_RE], T1.[U_Qty] AS 批次数量
	, T1.[U_Qty1] AS 抽检数量, T1.[U_Status], T1.[U_Item], T1.[U_Qty2], T1.[U_P1]
	, T1.[U_Memo], T0.[U_UserName1], T0.[U_UserName2]
FROM [dbo].[@OQAD] T0
	INNER JOIN [dbo].[@QAD1] 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_DocType] >= '[%4]'
		OR '[%4]' = '')
	AND (T0.[U_DocType] <= '[%14]'
		OR '[%14]' = '')
	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] = '')
	AND (T0.[U_BaseEntry] >= [%10]
		OR [%10] = '')
	AND (T0.[U_BaseEntry] <= [%29]
		OR [%29] = '')
ORDER BY T0.[DocEntry] DESC

五六零

海报 链接