How To Use External Microsoft JDBC Driver in Jaspersoft Studio

For connect different type of data sources we need to use external JAR file. Below I show how to use external JAR file for connect MSSQL server.

Download Microsoft JDBC Driver (Version Depend on JAVA Version)
Microsoft JDBC Driver 8.2 version suitable for my Java Version.
Download the file. and Unzip it.
Open Jaspersoft Studio & Create a new Data Adapter.
Go to Driver Classpath Option and select the JAR file you download.
Go to the database Location tab and enter like below image.
Driver Name: com.microsoft.sqlserver.jdbc.SQLServerDriver
URL: jdbc:sqlserver://localhost:1433;databaseName=DBNAME
Press Test

Note: If the Jar file does not support the java version, then the Jaspersoft Studio app is stuck in the loading screen. You can stop it from the task manager.

Comments

How to display data on a Jasper report line chart

There are basically three types of inputs on line chart. Series Category Value Fill chart data like below If you don't have series data then you can input "SERIES 0" or something else. Here attached sample view Here Product A & B is Series . a, b, c is category and 10,20 are value . Hope it will help you.

How to Print Time Specific Format

After selecting text field on the left Properties tab, under Text Properties have Pattern option. There can change time format. The proper format is MM/dd/yy h:mm a the two hh gives you the 24 hr clock. You can follow pattern guide . This link help for format time in many formats

Solving Problems with Jasper Reporter

Search This Blog