LabVantage and Jaspersoft Studio are Java based applications, so you need to have a Java Runtime Environment set up on computers running a local LabVantage installation or designing reports with Jasper.


Installing OpenJDK (v1.8.0)

  1. Download openjdk 1.8.0.212 from RedHat here: https://access.cdn.redhat.com/content/origin/files/sha256/a5/a55a62c443bbfe3053ac8f7b4d4cb6886a48636f5f69dae8ba11cf2f6493837d/java-1.8.0-openjdk-1.8.0.212-3.b04.redhat.windows.x86_64.msi?_auth_=1658950502_5f8bc267c222d9291ed3fcfbf78302e3
  2. Run the installer





  3. Ensure the jdk was installed and is working as expected by opening a command prompt and typing "java -version" into it and pressing enter.  Your command prompt window should look similar to this
  4. If you see a "java not recognized" type of message, try restarting your computer and test again.  If it's still not recognized, try the install steps again.


Installing Jasper Reports (v6.14)

  1. Download Jasper Reports from here: https://sourceforge.net/projects/jasperstudio/files/JaspersoftStudio-6.14.0/TIB_js-studiocomm_6.14.0_windows_x86_64.exe/download
  2. Run the installer



    Uncheck the box so you don't run it, there is still some configuration needing done.


Set up the SQL Server JDBC driver (v8.4.1)

  1. Download the Microsoft SQL Server JDBC from here: https://go.microsoft.com/fwlink/?linkid=2137600
  2. Create the following directory: C:\Program Files\Microsoft JDBC Driver 8.4 for SQL Server\
  3. Open the downloaded zip file and browse into ..\sqljdbc_8.4\enu and copy mssql-jdbc-8.4.1.jre8.jar into the directory you just created
  4. Open Jaspersoft Studio.  If you are presented with an update, do not update and disable the automatic check in the preferences by clicking the preferences link in the popup.  Some of the newer versions have issues with LabVantage integration.
  5. If you're opening Jaspersoft Studio for the first time, close the welcome screen.
  6. You should see the main application now with Data Adapters in the upper left.  Click on the Create Data Adapter button and select Database JDBC Connection in the Data Adapter window and click Next >.
  7. Enter the information for the new data adapter.  Each database will need its own data adapter.  This example is for the LabVantage test database.  After entering the details, move to the Driver Classpath tab.
  8. Click the Add button and browse to and select the JDBC file from earlier
  9. Click the Test button and you should see the Successful message.
  10. Repeat steps 6-9 to add additional data adapters as needed.
  11. To import the existing reports, go to the Project Explorer tab in Jaspersoft Studio, right click anywhere in the area, New -> Project
  12. In the New Project Wizard, select Jaspersoft Studio -> JasperReports Project and click Next, then enter a name for the project (I used LabVantage), and click Finish
  13. To import existing reports from the server, right click on the new project you created (LabVantage in my case) and go to Import
  14. Select General -> File System and browse to \\uskilims1.ki.com\labvantage\labvantagehome\applications\labvantage\reports and click OK.  Check OOB and PSO on the side to import all the report templates, then click Finish and all reports will be imported into your system.
  15. Your Project Explorer should look similar to this after the import


Setup sapphire library for REPORT_SCRIPTLET

  1. Download sapphire.jar from this solution article and save it into C:\Users\[YourUserAccountHere]\JaspersoftWorkspace\LabVantage\bin
  2. Right click the project you created in Jasper -> Properties
  3. In the Properties window that pops up, go to the Libraries tab and click the Add External JARS... button.
  4. Browse to the sapphire.jar file from step 1 and add it
  5. Click Apply and Close to add the library to your project.
  6. Your project should now look similar to this


Configuring Jasper library

  1. We need to set the library compatibility to 6.3.1.  Go to Window -> Preferences
  2. In the Preferences window, go to Jaspersoft Studio -> Compatibility and set the library version to JasperReports 6.3.1
  3. Click Apply and Close


Your system is ready to design and troubleshoot report files.  There is one last thing to do in order to allow special symbols to be used on reports using the templates designed in Jaspersoft Studio.  There is already a solution article written for that here: https://kemin.freshservice.com/support/solutions/articles/11000087591