Skip to main content

Posts

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.
Post a Comment
Read more
Recent posts

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
Post a Comment
Read more

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