query.grf

java 最出色的报表工具代码,愿分享....

Object Report
	Version='4.5.0.8'
	Title='你的报表标题'
	Object Font
		Name='宋体'
		Size=105000,0
		Weight=400
		Charset=134
	End
	Object Printer
	End
	Object DetailGrid
		Object Recordset
			ConnectionString='Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=ssxm_001;Data Source=.;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=BAIHE;Use Encryption for Data=False;Tag with column collation when possible=False'
			QuerySQL='select * from vouchers where endtime>=getdate() order by htcode'
			Items Field
				Item
					Name='HtCode'
					Type=Integer
				End
				Item
					Name='CustomerName'
				End
				Item
					Name='EngineName'
				End
				Item
					Name='EngineLocal'
				End
				Item
					Name='GiveLocal'
				End
				Item
					Name='FiteCode'
				End
				Item
					Name='TongStrong'
				End
				Item
					Name='ShuiniCode'
				End
				Item
					Name='Taluodu'
				End
				Item
					Name='SjName'
				End
				Item
					Name='CarCode'
				End
				Item
					Name='dCarFl'
				End
				Item
					Name='TotalFl'
				End
				Item
					Name='StartTime'
					Type=DateTime
				End
				Item
					Name='EndTime'
					Type=DateTime
				End
				Item
					Name='XwTime'
					Type=DateTime
				End
				Item
					Name='OperPerson'
				End
				Item
					Name='DiaoduOper'
				End
				Item
					Name='CustomerSinature'
				End
				Item
					Name='XZMode'
				End
				Item
					Name='PrintTime'
					Type=DateTime
				End
				Item
					Name='Checked'
					Type=Boolean
				End
			End
		End
		Items Column
			Item
				Name='HtCode'
				Width=1.98438
			End
			Item
				Name='CustomerName'
				Width=2.59292
			End
			Item
				Name='EngineName'
				Width=2.48708
			End
			Item
				Name='FiteCode'
				Width=1.905
			End
			Item
				Name='TongStrong'
				Width=1.87854
			End
			Item
				Name='ShuiniCode'
				Width=1.69333
			End
			Item
				Name='Taluodu'
				Width=1.87854
			End
			Item
				Name='SjName'
				Width=2.09021
			End
			Item
				Name='CarCode'
				Width=1.69333
			End
			Item
				Name='dCarFl'
				Width=1.93146
			End
			Item
				Name='TotalFl'
				Width=1.69333
			End
			Item
				Name='StartTime'
				Width=3.09563
			End
			Item
				Name='EndTime'
				Width=2.59292
			End
			Item
				Name='XZMode'
				Width=1.69333
			End
		End
		Object ColumnContent
			Height=0.608542
			Cursor=Magnify
			Items ColumnContentCell
				Item
					Column='HtCode'
					WordWrap=T
					TextAlign=MiddleCenter
					DataField='HtCode'
				End
				Item
					Column='CustomerName'
					WordWrap=T
					TextAlign=MiddleCenter
					DataField='CustomerName'
				End
				Item
					Column='EngineName'
					WordWrap=T
					TextAlign=MiddleCenter
					DataField='EngineName'
				End
				Item
					Column='FiteCode'
					WordWrap=T
					TextAlign=MiddleCenter
					DataField='FiteCode'
				End
				Item
					Column='TongStrong'
					WordWrap=T
					TextAlign=MiddleCenter
					DataField='TongStrong'
				End
				Item
					Column='ShuiniCode'
					WordWrap=T
					TextAlign=MiddleCenter
					DataField='ShuiniCode'
				End
				Item
					Column='Taluodu'
					WordWrap=T
					TextAlign=MiddleCenter
					DataField='Taluodu'
				End
				Item
					Column='SjName'
					WordWrap=T
					TextAlign=MiddleCenter
					DataField='SjName'
				End
				Item
					Column='CarCode'
					WordWrap=T
					TextAlign=MiddleCenter
					DataField='CarCode'
				End
				Item
					Column='dCarFl'
					WordWrap=T
					TextAlign=MiddleCenter
					DataField='dCarFl'
				End
				Item
					Column='TotalFl'
					WordWrap=T
					TextAlign=MiddleCenter
					DataField='TotalFl'
				End
				Item
					Column='StartTime'
					WordWrap=T
					Cursor=Magnify
					DataField='StartTime'
				End
				Item
					Column='EndTime'
					WordWrap=T
					TextAlign=MiddleCenter
					DataField='EndTime'
				End
				Item
					Column='XZMode'
					WordWrap=T
					TextAlign=MiddleCenter
					DataField='XZMode'
				End
			End
		End
		Object ColumnTitle
			Height=0.79375
			Items ColumnTitleCell
				Item
					GroupTitle=F
					Column='HtCode'
					TextAlign=MiddleCenter
					Text='合同编号'
				End
				Item
					GroupTitle=F
					Column='CustomerName'
					TextAlign=MiddleCenter
					Text='客户名称'
				End
				Item
					GroupTitle=F
					Column='EngineName'
					TextAlign=MiddleCenter
					Text='工程名称'
				End
				Item
					GroupTitle=F
					Column='FiteCode'
					TextAlign=MiddleCenter
					Text='匹配编号'
				End
				Item
					GroupTitle=F
					Column='TongStrong'
					TextAlign=MiddleCenter
					Text='砼强度'
				End
				Item
					GroupTitle=F
					Column='ShuiniCode'
					TextAlign=MiddleCenter
					Text='水泥编码'
				End
				Item
					GroupTitle=F
					Column='Taluodu'
					TextAlign=MiddleCenter
					Text='塌落度'
				End
				Item
					GroupTitle=F
					Column='SjName'
					TextAlign=MiddleCenter
					Text='司机姓名'
				End
				Item
					GroupTitle=F
					Column='CarCode'
					TextAlign=MiddleCenter
					Text='卡车编号'
				End
				Item
					GroupTitle=F
					Column='dCarFl'
					TextAlign=MiddleCenter
					Text='当车方量'
				End
				Item
					GroupTitle=F
					Column='TotalFl'
					TextAlign=MiddleCenter
					Text='总方量'
				End
				Item
					GroupTitle=F
					Column='StartTime'
					TextAlign=MiddleCenter
					Text='出场时间'
				End
				Item
					GroupTitle=F
					Column='EndTime'
					TextAlign=MiddleCenter
					Text='到达时间'
				End
				Item
					GroupTitle=F
					Column='XZMode'
					WordWrap=T
					TextAlign=MiddleCenter
					Text='卸载方式'
				End
			End
		End
	End
	Items Section
		Item
			Type=PageHeader
			Height=1.32292
		End
		Item
			Type=PageFooter
			Height=1.40229
			Items Control
				Item
					Type=MemoBox
					Name='MemoBox1'
					Left=4.78896
					Top=0.211667
					Width=5.42396
					Height=0.978958
					Text='[#SystemVar(PageNumber)#]/[#SystemVar(PageCount)#]'
				End
			End
		End
	End
End