1. 1.1. ireports ireports JasperReports GUI JasperReports Java PDF,HTML,Excel ireportsjasperreports URL ireportshttp://ireport.sourceforge.net/ JasperReportshttp://jasperreports.sourceforge.net/ JasperReports (.xml) Jasper Compiler JasperReports (.jasper) (JRDataSource) 1.2. ireportsjasperreports 2Web Web 0.1 1
1.3. OSWindows2000 Professional JavaVM:Sun JDK 1.4.1 ant1.4 ireportsireports 0.2.1 JasperReportsJasperReports 0.5.0 OSRed Hat Linux 8.0 DBPostgreSQL 7.2.1 (1) ireportsireport-0.2.1.zip JasperReportsjasperreports-0.5.0-project.zip ireportshttp://prdownloads.sourceforge.net/ireport/ireport-0.2.1.zip?download JasperReportshttp://prdownloads.sourceforge.net/jasperreports/jasperreports-0.5.0-project.zip?download (2) ireportsjasperreports C C: ireport-0.2.1c: jasperreports-0.5.0 ireports C: ireport-0.2.1 ireport.bat @echo off set JAVA_HOME=C: j2sdk1.4.0_03 set ANT_HOME=C: ant set IREPORT_HOME=C: Documenti progetti ireport ireport2 rem %ANT_HOME% bin ant javadocs %ANT_HOME% bin ant ireport 0.1 2
ireports C: ireport-0.2.1 ireport.bat ireports scrn 1 1.4. ireports (1) [Tools]-[Options][External programs] pdf [PDF Viewer] scrn 2 0.1 3
(2) (A) [DataSource]-[Connections / Datasources] [New] JDBC ireport libc: ireport-0.2.1 libireport [Test][SAVE] scrn 3 (B) [Build]-[Set Active connection] [OK] scrn 4 0.1 4
1.5. [File]-[New document] [Report name][ok] scrn 5 0.1 5
(1) [Datasource]-[Report query] scrn 6 0.1 6
[Report SQL Query] SQL SQL [Read fields] [Register fields to report] [Save query to report] scrn 7 0.1 7
(2) scrn 8 (3) scrn 9 0.1 8
[Band] scrn 10 [title][itemclsheader] 0.1 9
(4) $F{itemcls} $F [Fields] $V [Variables] $P [Parameter] [detail]$f{itemcls},$f{type}pagefooter String.valueOf($V{PAGE_NUMBER} scrn 11 0.1 10
(5) [] pagefooter scrn 12 (6) xml ireports xml image ireports 2(4)(D) 0.1 11
1.6. scrn 13 0.1 12
1.7. pdf [Build]-[*** View]1.4(1) scrn 14 0.1 13
2. Web Web TOMCAT CATALINA_HOME JasperReports JASPER_HOME OSRed Hat Linux 8.0 JavaVM:Sun JDK 1.4.1 DB:PostgreSQL 7.2.1 ant1.4 tomcat4.1.24 JasperReportsJasperReports 0.5.0 (1) $ CATARINA _HOME/webapps $JASPER_HOME/demo/samples/webapps JasperReport TOMCAT (2) TOMCAT URL http://(ip ):/JasperReport compile() scrn 15 0.1 14
execute scrn 16 scrn 17 0.1 15
(3) home [PDF output()]execute PDF scrn 18 (4) (A) (sample.xml,sample.jasper) $ CATARINA _HOME/webapps/JasperReport/reports 0.1 16
(B) JSP $CATARINA_HOME/webapps/JasperReport/JSP compile.jsp () JasperCompileManager.compileReportToFile(application.getRealPath("/reports/sample.xml")); $CATARINA_HOME/webapps/JasperReport/JSP pdf.jsp () File reportfile = new File(application.getRealPath("/reports/sample.jasper")); // JasperRunManager connection Class.forName("org.postgresql.Driver"); Connection con = DriverManager.getConnection("jdbc:postgresql://localhost:5432/DEV","user", "pass"); byte[] bytes = JasperRunManager.runReportToPdf( reportfile.getpath(), parameters, con ); (C) sample.xml MSGothic <font fontname="msgothic" pdffontname="/usr/local/fonts/msgothic.ttc,1" size="12" isbold="false" isitalic="false" isunderline="false" ispdfembedded ="false" pdfencoding ="Identity-H" isstrikethrough="false" /> (D) ireports sample.xml <image> <imageexpression class="java.lang.string"> <![CDATA["/usr/local/tomcat/jakarta-tomcat-4.1.24/webapps/JasperReports/reports/logo.jpg"]]> </imageexpression> </image> 0.1 17
3. Tips 3.1. (1) ireports xml querystring $P{} <querystring><![cdata[select * from dpmn where menuact=$p{ac_code};]]></querystring> (2) // File sourcefile = new File( "paramtest.xml"); JasperDesign jasperdesign = JRXmlLoader.load( absolutepath); File destfile = new File( absolutepath.substring(0, absolutepath.length() - 3) + "jasper"); String destfilename = destfile.tostring(); // JRDesignParameter designparameter = new JRDesignParameter(); designparameter.setname( "AC_CODE"); designparameter.setvalueclass( new String().getClass()); jasperdesign.addparameter( designparameter); JasperCompileManager.compileReportToFile(jasperDesign, destfilename); (3) // Map parameters = new HashMap(); parammap.put("basedir", "D: work "); parammap.put("ac_code", "NEW"); byte[] bytes; try { bytes = JasperRunManager.runReportToPdf( reportfile.getpath(), parammap, con); } 0.1 18
3.2. A 1000 2 2000 B 10000 1 10000 12000 $F{item_qty} $F{item_amount} ()()() scrn 19 0.1 19
Reset typepage Valiable expression${subtotal} Calculation type Sum$V{total} $V{subtotal}$V{total} scrn 20 Textfield expression $V{subtotal}$V{total} scrn 21 scrn 22 0.1 20
3.3. ireports ireports (1) ireports scrn 23 (2) java scrn 24 0.1 21
4. WEB+DB PRESS VOL15 / ireports (http://ireport.sourceforge.net/) JasperReports (http://jasperreports.sourceforge.net/) 0.1 22
5. JasperReports ireports yokoi@bbreak.co.jp 0.1 23