Hello
Here is working sample of JasperReport, very powerful reporting engine.
You can use them for your database, or any other application, because data source can be a simple CSV file.
First download and setup
iReport from
JasperForge
After installation, create and define your report from iReport
After completing report, in Jabaco CLASSPATH add folowing jar files
C:\Program Files\Jaspersoft\iReport-nb-3.6.0\ireport\modules\ext\
jasperreports-3.6.0.jar
C:\Program Files\Jaspersoft\iReport-nb-3.6.0\ireport\modules\ext\
commons-beanutils-1.8.0.jar
C:\Program Files\Jaspersoft\iReport-nb-3.6.0\ireport\modules\ext\
commons-collections-3.2.1.jar
C:\Program Files\Jaspersoft\iReport-nb-3.6.0\ireport\modules\ext\
commons-digester-1.7.jar
C:\Program Files\Jaspersoft\iReport-nb-3.6.0\ireport\modules\ext\
commons-logging-1.1.jar
C:\Program Files\Jaspersoft\iReport-nb-3.6.0\ireport\modules\ext\
groovy-all-1.5.5.jar
(PS: Change path to your needs)
After that you can add reference for folowing class
JasperDesign, JRXmlLoader, JasperReport, JasperCompileManager,
JasperPrint, JasperFillManager, JasperViewer
and add Jabaco code
|
Jabaco Source
|
1
2
3
4
5
6
|
Dim jd As JasperDesign=JRXmlLoader.load("c:\Report1.jrxml") '''REPORT FILE
Dim jr As JasperReport=JasperCompileManager.compileReport(jd)
Dim db As New Database
db.ConnectDSN ("Test") '''DB CONNECTION
Dim jp As JasperPrint=JasperFillManager.fillReport(jr,Null,db.Connection)
JasperViewer.viewReport(jp,False)
|
That is all (for now)
Milan