BBMPT1/PaintingView/StockB2.grf

Object Report
	Version='5.6.0.0'
	Title='你的报表标题'
	Object Font
		Name='宋体'
		Size=105000,0
		Weight=400
		Charset=134
	End
	Object Printer
		LeftMargin=1
		TopMargin=1
		RightMargin=1
		BottomMargin=1
	End
	Object DetailGrid
		Object Recordset
			ConnectionString='Provider=SQLOLEDB.1;Password=a1+;Persist Security Info=True;User ID=sa;Initial Catalog=BBMPT;Data Source=39.97.227.79;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=PC201904081405E;Use Encryption for Data=False;Tag with column collation when possible=False'
			QuerySQL='SELECT RIGHT([productInfo],LEN([productInfo])-14) AS PType,SUBSTRING([productInfo],1,3) AS color, COUNT(*) AS totle\r\n                                FROM [dbo].[View_StockIn]\r\n                                WHERE [productInfo] <> '' AND LEN(productInfo)>14  AND ([createTime] BETWEEN DATEADD(day,-1, CONVERT(DATETIME,SUBSTRING(CONVERT(NVARCHAR(50),GETDATE(),120),1,10)+ ' 20:00:01'))  AND CONVERT(DATETIME,SUBSTRING(CONVERT(NVARCHAR(50),GETDATE(),120),1,10)+ ' 08:00:00')) \r\n                                GROUP BY RIGHT([productInfo],LEN([productInfo])-14),SUBSTRING([productInfo],1,3)'
			Items Field
				Item
					Name='PType'
				End
				Item
					Name='color'
				End
				Item
					Name='totle'
					Type=Integer
				End
			End
		End
		Items Column
			Item
				Name='PType'
				Width=10.5833
			End
			Item
				Name='color'
				Width=4.78896
			End
			Item
				Name='totle'
				Width=3.41313
			End
		End
		Object ColumnContent
			Items ColumnContentCell
				Item
					Column='PType'
					DataField='PType'
				End
				Item
					Column='color'
					DataField='color'
				End
				Item
					Column='totle'
					DataField='totle'
				End
			End
		End
		Object ColumnTitle
			Items ColumnTitleCell
				Item
					GroupTitle=F
					Column='PType'
					Text='配置'
				End
				Item
					GroupTitle=F
					Column='color'
					Text='颜色'
				End
				Item
					GroupTitle=F
					Column='totle'
					Text='数量'
				End
			End
		End
	End
	Items Section
		Item
			Type=PageHeader
			Height=0
		End
		Item
			Type=PageFooter
			Height=1.2
			Items Control
				Item
					Type=StaticBox
					Name='StaticBox1'
					Left=2.19604
					Top=-0.15875
					Width=2.19604
					Height=0.79375
					TextAlign=MiddleCenter
					Text='入库人'
				End
				Item
					Type=StaticBox
					Name='StaticBox2'
					Left=12.409
					Top=-0.15875
					Width=2.19604
					Height=0.79375
					TextAlign=MiddleCenter
					Text='接收人'
				End
			End
		End
		Item
			Type=ReportHeader
			Name='ReportHeader1'
			Height=1.5875
			Items Control
				Item
					Type=StaticBox
					Name='MainTitleBox'
					Object Font
						Name='宋体'
						Size=217500,0
						Bold=T
						Charset=134
					End
					Center=Horizontal
					Left=6.48229
					Top=0.3
					Width=6
					Height=0.9
					TextAlign=MiddleCenter
					Text='喷涂入库记录'
				End
			End
		End
	End
End