ssxm.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 between '2009-1-1' and '2009-12-31' order by CustomerName'
			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
			End
		End
		Items Column
			Item
				Name='CustomerName'
			End
			Item
				Name='EngineName'
			End
			Item
				Name='TongStrong'
				Width=2
			End
			Item
				Name='ShuiniCode'
				Width=2
			End
			Item
				Name='Taluodu'
				Width=2
			End
			Item
				Name='SjName'
				Width=2
			End
			Item
				Name='CarCode'
				Width=1.69333
			End
			Item
				Name='dCarFl'
				Width=2
			End
			Item
				Name='TotalFl'
				Width=1.69333
			End
		End
		Object ColumnContent
			Height=0.608542
			Cursor=Magnify
			Items ColumnContentCell
				Item
					Column='CustomerName'
					CanGrow=T
					WordWrap=T
					Cursor=Negative
					DataField='CustomerName'
				End
				Item
					Column='EngineName'
					CanGrow=T
					CanShrink=T
					WordWrap=T
					DataField='EngineName'
				End
				Item
					Column='TongStrong'
					DataField='TongStrong'
				End
				Item
					Column='ShuiniCode'
					DataField='ShuiniCode'
				End
				Item
					Column='Taluodu'
					DataField='Taluodu'
				End
				Item
					Column='SjName'
					DataField='SjName'
				End
				Item
					Column='CarCode'
					DataField='CarCode'
				End
				Item
					Column='dCarFl'
					DataField='dCarFl'
				End
				Item
					Column='TotalFl'
					WordWrap=T
					DataField='TotalFl'
				End
			End
		End
		Object ColumnTitle
			Height=1.19063
			Items ColumnTitleCell
				Item
					GroupTitle=F
					Column='CustomerName'
					TextAlign=MiddleCenter
					Text='客户名称'
				End
				Item
					GroupTitle=F
					Column='EngineName'
					TextAlign=MiddleCenter
					Text='工程名称'
				End
				Item
					GroupTitle=F
					Column='TongStrong'
					TextAlign=MiddleCenter
					Text='砼强度'
				End
				Item
					GroupTitle=F
					Column='ShuiniCode'
					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'
					Text='当车方量'
				End
				Item
					GroupTitle=F
					Column='TotalFl'
					TextAlign=MiddleCenter
					Text='总方量'
				End
			End
		End
		Items Group
			Item
				Name='Group1'
				ByFields='CustomerName'
				Object GroupHeader
					Height=0.79375
					Items Control
						Item
							Type=StaticBox
							Name='StaticBox1'
							AlignColumn='CustomerName'
							Width=3.01625
							Height=0.608542
							Text='公司名称：'
						End
						Item
							Type=FieldBox
							Name='FieldBox1'
							Left=1.79917
							Width=3.51896
							Height=0.79375
							CanGrow=T
							DataField='CustomerName'
						End
						Item
							Type=SummaryBox
							Name='SummaryBox1'
							Left=8.59896
							Width=3.20146
							Height=1.00542
							DataField='TotalFl'
						End
						Item
							Type=StaticBox
							Name='StaticBox3'
							Left=7.19667
							Top=0.211667
							Width=1.40229
							Height=0.396875
							Text='总方量：'
						End
					End
				End
				Object GroupFooter
					Height=0
				End
			End
		End
	End
	Items Section
		Item
			Type=PageHeader
			Height=1.32292
		End
		Item
			Type=PageFooter
			Height=1.19063
			Items Control
				Item
					Type=MemoBox
					Name='MemoBox1'
					Left=6.00604
					Top=0.211667
					Width=4.20688
					Height=0.79375
					Text='[#SystemVar(PageNumber)#]/[#SystemVar(PageCount)#]'
				End
			End
		End
		Item
			Type=ReportHeader
			Name='ReportHeader1'
			Height=1.32292
			Items Control
				Item
					Type=StaticBox
					Name='StaticBox2'
					Object Font
						Name='宋体'
						Size=142500,0
						Bold=T
						Charset=134
					End
					Center=Horizontal
					Left=3.70417
					Top=0.211667
					Width=8.59896
					Height=0.79375
					Text='省三混凝土搅拌站混凝土发货统计表'
				End
			End
		End
	End
End