JasperReport的使用过程Word下载.docx
- 文档编号:19898917
- 上传时间:2023-01-12
- 格式:DOCX
- 页数:9
- 大小:326.18KB
JasperReport的使用过程Word下载.docx
《JasperReport的使用过程Word下载.docx》由会员分享,可在线阅读,更多相关《JasperReport的使用过程Word下载.docx(9页珍藏版)》请在冰豆网上搜索。
●poi-2.0-final-20040126.jar(excelprinting)
●jfreechart-1.0.12.jar(chatprinting)
●barbecue-1.1.jar(barcodeprinting)
iReportGettingStarted
Step1:
Download,Install,andRuniReportDownloadinhttp:
//jasperforge.org/
ToinstalliReportonaWindowsplatform:
runiReport-<
ver>
-windows-installer.exe.
StartiReportusingthemenuitem
Programsmenu>
Jaspersoft>
iReport<
IfyouareusingaMacoraLinuxbox,considertodownloadiReport-<
.tar.gz,extractthearchiveinyourfavoritedirectoryandrun:
iReport.sh.fromashell.
Step2:
Connecttoadatabase
iReportcanuseseveraldatasourcestocreatereports,suchasJDBCconnection,XMLfile,CSVfile,JavaBeanresultset,Hibernateconnection,etc...ThisdocumentwillshowhowtocreateJDBCconnectionDataSourceandXMLfileDataSource.
AddOracleJDBCDrivertoiReport
iReportrequiredtoaddthejavajarfileoftheJDBCDriver.IfyouareconnectingtheOracledatabaseasthedatasourceofthereport,youhavetoaddthejarfileoforaclejdbcdrivertoiReport.
AddingOracleclassfileforconnectiontoOracledatabase:
Tools->
Options->
Classpath->
AddJAR
AddDataSource
ClickReportDatasourceicon
->
New
OracleJDBCconnection
1.ClickDatabaseJDBCconnection.
2.fillintheconnectioninformation
XMLfileDataSource
1.ClickXMLfiledatasource
2.fillintheconnectioninformation
Step3:
Createyourfirstreport
Nowyouhavesetupadatabaseconnection,startthereportwizard(File->
ReportWizard)toquicklycreateyourfirstreport.
1.Createanemptyreport“QuickQuote”
Thelayoutofreportcanbesplitinto:
TitleBand,PageHeaderBand,ColumnHeaderBand,DetailBand,ColumnFooterBand,PageFooterBand,SummaryBand
Inthisreport,wewilluseTitleBand,ColumnHeaderBandandDetailBandonly.
WecansettheBandHeightto0forunusedband
Definethequeryforthedata:
RightclickthemouseinblankareaofiReport.
Typethesqlstatementforthedata:
e.g.
SELECTID,QUICK_QUOTE_NOFROMmer_quick_quote
whereID='
284e33e20a2bb9cb9ce510d0fe100897'
Addthefollowingobject,andpreviewthereport.
AddSubReport:
Hideunusedlayoutband:
Deletethe$F{PICTURE},andaddanImageobjectintothelayout.
Setthevalueoftheimageas:
"
C:
\\filesystem\\uploadFiles\\QuickQuote\\thumbnail\\20090408\\"
+$F{PICTURE}+"
.png"
PreviewtheSubReport:
Previewthewholereport:
UsingParametersinaQueryandSubReportQuery
ParametersmaybeusedtofilteraSQLquery.Supposeyouwanttoprintinformationabouta
particularcustomeridentifiedbycustomerID(notknownatdesigntime).Yourquerywillbeas
follows:
select*fromcustomers
whereCUSTOMERID=$P{MyCustomerId}
MyCustomerIdisaparameterdeclaredasaninteger.JasperReportswilltransformthisqueryto
select*fromcustomerswhereCUSTOMERID=?
ItwillrunthisSQLusingapreparedstatementbypassingtheMyCustomerIdvalueasa
queryparameter.Ifyouwouldliketopasstheparametervaluedirectly,youcanusethisspecial
syntax:
$P!
{parameter_name}
Thisallowsyoutoreplacetheparameternameinthequerywithitsvalue.Forexample,ifyouhave
aparameternamedMyWherewiththevalueofwhereCUSTOMERID=5,thequery
select*fromcustomers$P!
{MyWhere}
willbetransformedinto
select*fromcustomerswhereCUSTOMERID=5
byusingthissyntax.
Example:
whereID=$P{docId}
PrintingbarcodeiniReport
1.Addanimagetothereport
2.SettheImageExpressionas:
mon.image.BarcodeImage.getBarcodeImage(13,"
0815"
true,false,null,0,0)
3.SettheImageExpressionClass:
java.awt.Image
SubReportwithXMLdatasource:
ConnectionType
Useadatasourceexpression
DataSourceExpression
((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("
/DOC/LIN"
)
JasperPrintinginMerchant
Configuredinstruts-printing.xml
XMLsourcetoPDF->
xml_print_pdf.action
XMLsourcetoExcel->
xml_print_excel.action
XMLsourcetoHTML->
xml_print_html.action
Exampletoruntheprintfeatureinoursystem:
http:
//localhost:
8083/merchantWeb/xml_print_pdf.action?
reportName=PacSunPO&
docId=0000201569.xml
:
Parameter
Value
reportName
JasperclassfileName
docId
Xmlfilename
DBtoPDF->
jasper_print_pdf.action
DBtoExcel->
jasper_print_excel.action
DBtoHTML->
jasper_print_html.action
8083/merchantWeb/jasper_print_pdf.action?
reportName=QuickQuote&
docId=284e33e20a2bb9cb9ce510d0fe100897
8083/merchantWeb/jasper_print_html.action?
reportName=CHART
UsefullinkforjasperreportandiReport.
iReportTutorials
//ireport-
CreatingandDesigningReportUsingiReport(usingoldversionasexample)
JasperReport报表设计总结
JasperReport经验谈
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- JasperReport 使用 过程