datawarehouse and more
Jaspersoft Studio
This section of blogs contain all the workarounds and do hows on Jaspersoft Studio Community version.
Talend Open Studio
Talend is most sort after open source ETL tool in the market. This section is for my dive into this ocean
Music
How can I not have a section for Music in my site. I will post all the work I have been part of in this section.
Arduino & IoT
My new found passion. Have a long way to go. Read more for few work I have done in this category.

Author Archives

Archive of the posts written by author: rajeshsirsikar.

Talend Open Studio – How to implement Error Recovery Mechanism using tCheckpoint Component

Hi All, A new problem and a new solution. I wanted to solve the question of Error recovery implementation from Talend Open Studio (Jaspersoft ETL). Found a Component tCheckpoint created by “Talend By Example” and then spent some time to figure out how…

Jaspersoft Studio – Connecting to Redshift Cluster from Community Edition

Even though the recent version of Jaspersoft Studio Community Edition has a JDBC Driver selection for Redshift, the connection doesnot work as the Driver is a Tibco driver and is available only in full version. So there should be a way to connect…

Creating Report Using JSON file with Parameter – Jaspersoft Studio

Hey guys!! Sorry for the silence for sometime…But I am back with a new post about creating a Report using JSON File and a parameter in Jaspersoft Studio. 1) In my earlier post I had briefed the step by step procedure to create…

Jaspersoft Studio – Creating Cross-Tab Report for 2-Dim Data Display

Hello All!!! Was bit busy with my work and could not find much time to do this. But this made me write this blog. This is a simple step by step explanation to create a cross tab report. 1) For this tutorial, I…

Subtract Current Value from Previous Value in Jaspersoft Studio

To Create a Variable which Subtracts the Current Row Value from Previous Row Value of teh same column, please follow the below steps. 1) Create a Variable “Previous_Value” and add $V{Current_Value} as the expression. This will Give a Invalid error as the Current_Value…

Report Bursting In Jasperserver

1) In Jasperserver 6.0.1 Pro edition, the Report bursting is provided inbox. (As earlier this was an out of the box functionality using Jaspersoft ETL). 2) The step by step approach to achieve this is as follows. a. Stop Jasperserver b. Navigate to…

Creating a Simple Report using JSON File in Jaspersoft Studio

Hi all, Its been a month since I worked on a feature in Jaspersoft Studio. Now that I have got some time to spend, I thought its best to provide a step by step approach to create a report using JSON File. here…

Selecting Top N Values from a CSV Datasource – Jaspersoft Studio

I have tried to come up with a workaround for this question from StackOverflow. Link for the Question Here the user has created a Report with CSV Datasource and wants to create a Pie Chart with only Top 10 Values from the same…

Using SubSelect in SQL Query in Jaspersoft Studio

I bumped into a question in Stackedoverflow. It looks as a simple issue, but confuses Jaspersoft Studio user. The issue is getting an error while using subselect statement in SQL. So I created a sample report with subselect statement. 1) I used the…

Creating a DataSource using Excel FILE (CSV Format) in Jaspersoft Studio

This is the step by step approach of how to create a Datasource using Excel file (CSV Format). 1) For example sake, I have taken a dataset from a question asked in stackoverflow. Question 2) Save the excel file as CSV, as shown…