You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
140 lines
3.0 KiB
140 lines
3.0 KiB
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
|
|
|