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.
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
Comments
Post a Comment