Jaspersoft BI Tools

iReport,Jaspersoft Design Studio,Jaspersoft Server, Schema Workbench,Analysis,Dashboards, Self Service BI, Domains,Topics,Ad-Hoc Reports, Jaspersoft ETL, Embedding BI,HTML-5 charts, Fusion Charts,JFree Charts,Drill down reports , Drill down Dashboards,Visualize.js, Performance Tuning, D3 Charts, Jaspersoft Customization

Friday, February 28, 2014

Installation of Jasper server 5.5 pro in Cent OS

Install jasper server professional edition of 5.5 version.

Installation steps
1. Open the terminal with sudo permission
[Sadakar@localhost softwares]$ su

2. Apply chmod 777 command for jasperreports-server-5.5-linux-x86-installer.run file
[Sadakar@localhost softwares]$ chmod 777 jasperreports-server-5.5-linux-x86-installer.run

3. Click on series of Forward buttons to finish the installation.

a. Installation location of jasper server in Cent OS:

b. Installation location of postgres in Cent OS:

c. How to connect to postgresql from command prompt
Password: password
databases : \list
connect to database: \c foodmart
show tables : \dt

4. Starting Jasperserver:
You can start the jasperserver in any one of the way sh ctlscript.sh start (or)  ./ ctlscript.sh start
[root@localhost jasperreports-server-5.5]# sh ctlscript.sh start

5.Check the Status of the Service
sh ctlscript.sh status

1) You must run the postgresql before you start the jasperserver.
2) By default jasper server run on 8080 port number(tomcat server port number).
3) Default database for jasper server is postgres which runs on 5432 port number.
4) You must check whether the port numbers is opened or not in your machine(hint : Check iptables)

Installation of Mozilla firefox 27 in Cent OS 6.5 (works for all linux OS)

Hi Guys,

Mozilla firefox 27 installation steps in Cent OS 6.5

1) Download software using below link

From the terminal download it using below command
wget https://download-installer.cdn.mozilla.net/pub/firefox/releases/27.0.1/linux-i686/en-US/firefox-27.0.1.tar.bz2

2) Unzip the tar file using below command
   $ tar -xjvf firefox-27.0.tar.bz2
3) Remove the already existing old version-ed fire fox using below command.
sudo rm -r /opt/firefox*

4) Create a folder "firefox27" in the opt folder
opt$ mkdir firefox27

5) Move Or Copy the "firefox" to firefox27 folder
$ sudo mv firefox /opt/firefox27 

6) Give the symbolic link of fire fox in bin folder
sudo ln -s /opt/firefox27/firefox /usr/bin/firefox

7) Start the fire fox  from command prompt 
Go to the usr/bin/firefox
If you find firefox inside the firefox navigate up to here and then type ./firefox

NOTE : In Cent OS give simply su for super user permission.
and the password is password.

Reference :


Wednesday, February 19, 2014

New features in Jaspersoft 5.5 Community & Commercial

Hi Guys,
Find the new features of jaspersoft 5.5 (CE & EE) by clicking below link.



Sring Type fields as Measures in Cross Tab using Japser iReport and Importent tricks on cross tab

This post is having theory but will give you the exact information,reasons and solutions on cross tab that you are looking for.... 

1) Can you fill String type of filed values on cross tab Measures ? Does it allow when you design the cross tab ?
  • Cross tab by default allow you to fill with only one measure at the time of creation. But later on you can add as many measures you need. 
  • Generally what one can think that cross tab measure only allows Integer or Long type of fields but it also allows String or Other type of fields and you can also to calculations on the values which are in the form of strings. 
  • Example : 
  • You have created a cross tab having 1 row group, 1 column group and 1 measure(Or, 2 row groups , 2 column groups,1 measure).
  • Let us assume that you want to add one more measure to your cross tab: Let us say your field name is time from SQL query which is the form of string having shape hh:mm:ss(i.e., you field is : $F{time}).
  • Now you are going to add this field as 2nd measure to the cross tab. How ?
  1. Right click on measure-->Click add measure.
  2. Name : time
    Measure class: java.lang.String ( Note that this is a measure but you are giving it as String)
    Value Expression : $F{time}
    Calculation : First (This selection will make the cross tab to bring the value of the field irrespective of type)
    Incrementer Factory :  ---------
  3. Increase the width of already existing Measure and then drag and drop the newly created measure.
  4. Adjust the height and width for both of the measures and save the report.
  5. View the preview. 

Important points 
1) Summations of measures for each level of row group
Assume that you need to add totals of a measure for every row group.
for example you have 4 row groups in your cross tab and want to calculate the sum of every measure for each level of row group ...

When you explicitly adding  custom row groups , you have to select Total Position Property = End
By default it is Never... You can observe the Extra space for the summation values where you can drag and drop your calculations of your measures or simply drag and drop the measure which you have summation.. Cross tab by default gives you the summation of each row level group and Grand total value for the single calculated measure.

You need to repeat the same above procedure for the remaining row groups.

2) Stretch Type =  Relative to band Height
This is useful when you work with row groups and column groups....
1) 2nd field is grouped by 1st field
2) 3rd field is grouped by 2nd field
   4th field have 3 data values
In that case you will get output data correctly but the formatting will be missing ( i.e., the borders of the cells will miss).. To over come this thing you need to set Stretch Type =  Relative to band Height

There are no limitations on adding cross tab row groups and/or column groups. But often we get 3rd variable of row group is not acceptable when adding 4th row group.. You need to use "" double quotes with + for that variable or else take a fresh report and keep on adding row groups.. This must work.

Tuesday, February 18, 2014

Cross Tab Calculations in iReport - Converting seconds to Time using Expression in Measure variables.

Hi Guys...!!!
A work around in Japser iReport Cross Tab component. 
Scenario :
Assume you have time filed(format: hh:mm:ss, it could be java.sql.Time or String type) and want to add the times...
Directly you can not add the time as you generally do with Integer or Long types.
1) Convert the time to seconds and make the type as Integer or Long using SQL query.
2)  Lets say the filed name is $F{time} which is in seconds and type is Integer.
3) Fill the cross tab with this measure. You can find that the values will fill on cross tab with $V{time} variable.
4) Click on the variable (i.e., On $V{time}) go to the properties and then write the below expression  at Text field properties.
Type: java.lang.String for the Measure.
5) At last convert the expression to string using .toString() function.

 Convert seconds to Time on cross tab measure
                                                    $V{time} -
                                                                        java.util.concurrent.TimeUnit.HOURS.toSeconds( java.util.concurrent.TimeUnit.SECONDS.toHours($V{time}))

        $V{time} - java.util.concurrent.TimeUnit.HOURS.toSeconds(java.util.concurrent.TimeUnit.SECONDS.toHours($V{time}))
                                                                                                            $V{time} - java.util.concurrent.TimeUnit.HOURS.toSeconds(java.util.concurrent.TimeUnit.SECONDS.toHours($V{time}))


The source java code for the expression is :
JAVA Code:
import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.concurrent.TimeUnit;

public class TestDate {

  * @param args
  * @throws ParseException
 public static void main(String[] args) throws ParseException {
  // TODO Auto-generated method stub
  String timee="31:58:55";
  DateFormat format=new SimpleDateFormat("hh:mm:ss");
// format.parse(timee).getSeconds();
int seconds = format.parse(timee).getHours()*3600+format.parse(timee).getMinutes()*60+format.parse(timee).getSeconds();

    String[] parts = timee.split(":");
  long millis = TimeUnit.HOURS.toSeconds(Long.parseLong(parts[0]))
            + TimeUnit.MINUTES.toSeconds(Long.parseLong(parts[1])) + Long.parseLong(parts[2]);
  System.out.println(millis+" in Seconds");
  //System.out.println(seconds + " Converted to Seconds");
  long s_hour = TimeUnit.SECONDS.toHours(millis);
  long tempSec = millis - (TimeUnit.HOURS.toSeconds(s_hour));
  long s_minute = TimeUnit.SECONDS.toMinutes(tempSec) ;
  long tempSec1 = tempSec - (TimeUnit.MINUTES.toSeconds(s_minute));
  long s_seconds = TimeUnit.SECONDS.toSeconds(tempSec);
  System.out.println(s_hour  + " in Hours");
  System.out.println(tempSec+" Which is a reminder");
  System.out.println(s_minute + " in Minutes");
  System.out.println(tempSec1+" in Seconds");

Monday, February 17, 2014

Differences between Reporting and Analysis –Theory - Points from Brent Dykes blog

Hello guys,
Below post explains you the differences b/w Reporting and Analysis.

You just need to apply the concepts in design and development of Reports and Sachems

Click below link for the description.. It will take you to my other blog-site on pentaho.


for this post
Reporting Tools : iReport/jasper studio
Analysis Tool : Schema Work bench - OLAP

Thursday, February 06, 2014

Install jasper Studio as a plug in in Eclipse

Eclipse Details:
Version: Juno Service Release 2
Build id: 20130225-0426

1. Go to Help ->Click on -> Eclipse Market Place
2. In the Find box type jaspersoft studio.
3.Click on install.
4. Wait for the 100% download and installation.
5. Eclipse will ask you to restart the IDE. restart it.
6. Click File -> New-> Jasper Report.
7. Save the reports in your favorite project folder.

Happy reporting in Eclipse IDE.