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 CONVERT(DATETIME,SUBSTRING(CONVERT(NVARCHAR(50),GETDATE(),120),1,10)+ ' 20:00:01') AND CONVERT(DATETIME,SUBSTRING(CONVERT(NVARCHAR(50),GETDATE(),120),1,10)+ ' 23:59:59'))\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