Object Report
	Version='5.0.0.9'
	Title='按单统计销售明细报表'
	AlignToGrid=F
	PrintAsDesignPaper=T
	Object Font
		Name='宋体'
		Size=105000,0
		Weight=400
		Charset=134
	End
	BackImage=26298
[encoded data, 52596 characters]
	BackImagePreview=T
	Object Printer
		Size=256
		Width=11
		Height=18.2
		Oriention=Landscape
		LeftMargin=0
		TopMargin=0
		RightMargin=0
		BottomMargin=0
	End
	Object DetailGrid
		BorderStyles=[]
		BorderWidth=0
		CenterView=F
		ShowColLine=F
		ShowRowLine=F
		ColLineColor=3DDkShadow
		RowLineColor=3DDkShadow
		AppendBlankRow=T
		Object Recordset
			ConnectionString='Provider=SQLOLEDB.1;\r\nPersist Security Info=True;\r\nData Source=;\r\nInitial Catalog=gridreport;\r\nUser ID=sa;\r\nPassword=;'
			QuerySQL='select m.OrderID,m.CustomerId,c.CompanyName,m.OrderDate,M.Freight,\r\nd.ProductID,p.ProductName,d.UnitPrice,d.Quantity,d.UnitPrice*d.Quantity as Amount\r\nfrom (Orders m inner join \r\n(OrderDetails as d inner join Products p on P.ProductID=D.ProductID) on m.OrderId=d.OrderId)\r\nleft join Customers c on c.CustomerID=m.CustomerID\r\nwhere m.OrderID=10255'
			Items Field
				Item
					Name='ProductID'
					Type=Integer
				End
				Item
					Name='ProductName'
				End
				Item
					Name='UnitPrice'
					Type=Float
					Format='#,##0.##'
				End
				Item
					Name='Quantity'
					Type=Integer
					Format='#,##0.##'
				End
				Item
					Name='Amount'
					Type=Float
					Format='$#,##0.00'
				End
			End
		End
		Items Column
			Item
				Name='UnitPriceaaa'
				Width=0.75
			End
			Item
				Name='UnitPrice'
				Width=6.6675
			End
			Item
				Name='Quantity'
				Width=1.24354
			End
			Item
				Name='Discount'
				Width=1.08479
			End
			Item
				Name='Amount'
				Width=1.16417
			End
			Item
				Name='DisCountAmt'
				Width=2.27542
			End
			Item
				Name='NetAmount'
				Width=0.714375
			End
			Item
				Name='Column1'
				Width=3.28083
			End
		End
		Object ColumnContent
			Height=0.79375
			RowsPerPage=4
			Items ColumnContentCell
				Item
					Column='UnitPriceaaa'
				End
				Item
					Column='UnitPrice'
					DataField='ProductName'
				End
				Item
					Column='Quantity'
					TextAlign=MiddleRight
				End
				Item
					Column='Discount'
				End
				Item
					Column='Amount'
					TextAlign=MiddleRight
					DataField='Quantity'
				End
				Item
					Column='DisCountAmt'
					TextAlign=MiddleRight
					DataField='UnitPrice'
				End
				Item
					Column='NetAmount'
					TextAlign=MiddleRight
				End
				Item
					Column='Column1'
					FreeCell=T
					Items Control
						Item
							Type=MemoBox
							Name='MemoBox1'
							Dock=Fill
							TextAlign=MiddleRight
							Text='[#Amount*100:0#]'
							CharSpacing=900
						End
					End
				End
			End
		End
		Object ColumnTitle
			BackColor=White
			Height=1.00542
			RepeatStyle=OnPage
			Items ColumnTitleCell
				Item
					GroupTitle=F
					Column='UnitPriceaaa'
				End
				Item
					GroupTitle=F
					Column='UnitPrice'
				End
				Item
					GroupTitle=F
					Column='Quantity'
				End
				Item
					GroupTitle=F
					Column='Discount'
				End
				Item
					GroupTitle=F
					Column='Amount'
				End
				Item
					GroupTitle=F
					Column='DisCountAmt'
				End
				Item
					GroupTitle=F
					Column='NetAmount'
				End
				Item
					GroupTitle=F
					Column='Column1'
				End
			End
		End
	End
	Items Parameter
		Item
			Name='Comment'
			Value='演示发票套打。\r\n\r\n1、将整个发票分解为三个区域：头、明细、尾，分别对应报表的报表头、明细网格、报表尾。\r\n2、将空白发票的扫描图作为报表设计背景图，在页面视图中插入部件框，根据背景图定位位置与确定大小。\r\n3、设定合适的综合文字框的“字间距”属性值让文字输出到正确金额位栏中。\r\n4、设置综合文字框前加“*”文字实现圆圈中画叉图形的输出。'
		End
		Item
			Name='OrderDate'
			DataType=DateTime
		End
	End
	Items Section
		Item
			Type=ReportHeader
			BackColor=White
			Height=3.20146
			Items Control
				Item
					Type=StaticBox
					Name='Address'
					Left=2.56646
					Top=2.61938
					Width=4.84188
					Height=0.582083
					Text='改用字段框显示'
				End
				Item
					Type=MemoBox
					Name='MemoBox4'
					Left=12.4883
					Top=2.67229
					Width=1.37583
					Height=0.555625
					TextAlign=MiddleRight
					Text='[#OrderDate:yyyy#]'
				End
				Item
					Type=MemoBox
					Name='MemoBox5'
					Left=14.314
					Top=2.67229
					Width=0.846667
					Height=0.555625
					TextAlign=MiddleRight
					Text='[#OrderDate:M#]'
				End
				Item
					Type=MemoBox
					Name='MemoBox6'
					Left=15.5575
					Top=2.67229
					Width=0.846667
					Height=0.555625
					TextAlign=MiddleRight
					Text='[#OrderDate:d#]'
				End
				Item
					Type=StaticBox
					Name='CompanyName'
					Left=2.56646
					Top=2.01083
					Width=4.84188
					Height=0.582083
					Text='CompanyName'
				End
			End
			RepeatOnPage=T
		End
		Item
			Type=ReportFooter
			Name='ReportFooter1'
			BackColor=White
			Height=3.51896
			Items Control
				Item
					Type=MemoBox
					Name='MemoBox2'
					BackColor=Window
					ForeColor=Black
					Object Font
						Name='宋体'
						Size=105000,0
						Bold=T
						Charset=134
					End
					Left=4.02167
					Top=0.0264583
					Width=8.62542
					Height=0.873125
					TextAlign=MiddleRight
					Text='*[#Sum(Amount):$$$$#.00#]'
					CharSpacing=2800
				End
				Item
					Type=StaticBox
					Name='Remark'
					BackColor=Window
					Left=2.56646
					Top=1.27
					Width=14.5256
					Height=0.529167
					Text='实际中用字段框显示备注字段信息'
				End
				Item
					Type=MemoBox
					Name='MemoBox3'
					Left=13.9435
					Top=0.15875
					Width=3.22792
					Height=0.635
					TextAlign=MiddleRight
					Text='[#Sum(Amount)*100:0#]'
					CharSpacing=900
				End
			End
			RepeatOnPage=T
		End
	End
End
