Install iReport 5.6 and OJBDC Driver

To create reports for use in AppBase, you need to first to install the iReport client and reference the OJDBC connector so that iReport can 'talk' to your Oracle or SQL Server database instance.  

The following steps articulate how to set up iReport in readiness to create your reports.

Install i-Report

1. Download the iReport Design installation file from Jaspersoft Community or ask your administrator for a ready-to-go installer (Jasper_Installation Folder_Nov2020.zip)
2. Unzip the Jasper_Installation Folder_Nov2020.zip file on C:\ (the root folder).
3. This will create the following folders:
   1. Jasper
      1. Basic Reports
      2. iReport-5.6.0
      3. JavaSE1780
      4. jre7
4. Run the executable ireport.exe file (it is under the C:\Jasper\iReport-5.6.0\bin\ folder).
   

   

Install the JBDC Database Driver

The first time you run the iReport Designer, you will need to install a .jar file (Java Archive file) that will support connecting iReport to an Oracle database.  The steps below will explain how to do this.

1. Open the iReport Designer. If opening for the first time, click Cancel to exit any wizard screens.
2. Click on Tools > Options
3. Click on the ClassPath tab and validate that the library ojdbc6.jar is installed.
   

   

4. If not, click on Add JAR and select the library from the folder C:\Jasper
5. Click OK to close the window. You will now be able to connect to your database with the appropriate credentials.

Related Articles

• Connect to a Solution Database
• Report Layout and Formatting