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.

Creating Running Total in Jaspersoft Studio

Came across this Question :¬†http://community.jaspersoft.com/questions/844022/variable-initial-value-and-re-use-same-variable in Jaspersoft Community and worked on it for one day to get the result. The requirement here is to add or subtract the values from 2 different columns based on whether they are from input column or output…

Jaspersoft Studio – Ignore Pagination

In this tutorial, I will show you how to use “Ignore Pagination” for your use. 1) Consider you have a report with column data running into multiple pages (For demo purpose I created a simple Report with 3 fields. The design and the…

Change the Chart Axis Dynamically – Jaspersoft Studio

I created this report to answer the Question¬†from Jaspersoft Community . 1) Create a report with parameters. (I have used P_CITY and P_COUNTRY as parameters and the SQL Code I have used is as below) 2) This Query will take either P_COUNTRY as…

Increment a Variable in Jaspersoft Studio

To Create a Increment Variable on a DataSource Field for its each occurrence, we can use the following process. 1) Assuming you have created a report with DataSource and have a Field in mind for the increment number to happen, create a Variable…

Conditional Query – Using Parameter Value in the Query to Fetch Data

I checked this question from Jasper Community Question how to use ” select top x records from table” in jaspersoft studio and thought this can be achieved by using Conditional Query. So I took the same report which I had used in my…

Jaspersoft Studio Sub-Report Development Steps

1.0 CREATING MAIN REPORT 1) Create a Main Report and save it in your workgroup (In my case : C:\Users\MYName\JaspersoftWorkspace\MyReports\Main Report.jrxml) Click Next 2) In Data Adapter : Select Sample DB Click Finish 3) This will create a basic Report Template. Right Click…

Display List of Records in the Title Bar – Jaspersoft Studio

Sometimes we may bump into a requirement of displaying a list value in the Title Bar and it is very tricky situation in Jaspersoft Studio. Title and Summary Bar will not display a List Value field and if we try to drag and…

Conditional Query Using Parameters in Jaspersoft Studio

I would like to Thank “Maithili” from Jaspersoft Community to push me to do this. in this blog I will be explaining how to Dynamically Change the SQL Query of a Report using Parameters. If you are searching for a solution related to…

Creating A Multi-Select Parameter in Jaspersoft Studio

In this post, I will take you through the step by step procedure to create a Multi Select Parameter in Jaspersoft Studio. This Method would just create a parameter Value where you have to Manually add multiple values which will then be passed…

Display % Value of Each Slice Inside Pie Chart Slices – Jaspersoft Studio

1) Create a Report using the same Query we used in my blog “Display Total On Each Column Of Stacked Bar In jaspersoft (Direct Approach)” 2) Delete all Bands except Title and Summary. 3) Drag and Drop Chart from the Palette and select…