Skip to main content

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
Line Chart wizard

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.



Comments

Popular posts from this blog

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.

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