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 a Report in Jaspersoft Studio using MDX query and a Parameter

1) Create a XMLA datasource to connect to SSAS Cubes. 2) Newly created datasource is now available under datasource window. 3) Now create a new report with MDX XMLA as datasource. 4) Change the Query Language to mdx and create a MDX Query…

Display Total On Each Column Of Stacked Bar In jaspersoft (Direct Approach)

1) Create a simple report using the Sample DB and the below Query. To understand how to create a simple report, please check my previous blog “Creating Your First Report !!!” SELECT DISTINCT ORDERS.SHIPCOUNTRY,                  …

Display Total On Each Column Of Stacked Bar In jaspersoft (With Customizer Class Approach)

Create a Stacked Bar with “Total” Value displaying on top of each Bar Important Requirements : 1)      A Query with the required Total Values available as a Column. 2)      A Java Code to customize a Line Chart. Procedure : 1) Create a Report in…

Customizer Class – Jaspersoft Studio

Customizer Classes are the Java Classes which can be used to implement or change the appearance and properties of Charts. Jaspersoft Studio uses Jfree chart APIs to build charts and by using Customizer code, we can extend the functionality and appearance of these…

Display % Value in Pie Chart – Jaspersoft Studio

In this topic I am going to show you how to achieve the following custom formatting of data labels in a pie chart using Jaspersoft Studio. 1) How to Show Data Labels. 2) How to Show % Values using Jaspersoft Studio. 3) How…

Create a SQL Server Database Connection – Local

In this post I will be sharing the Step by step Procedure to Create a SQL Server database Connection with Common Error messages and steps to troubleshoot them. I will be explaining the steps assuming you are working on your local system and…

My Experiment with Jaspersoft Studio

I bumped into this BI tool after working on SAP Business Objects XI R3 to 3.2. Unavailability of some of the basic functionality of BI Reporting tool in Jaspersoft Studio fascinated me and I started to create workarounds. This continuous struggle to create…

Creating Your First Report !!!

In this blog, i will briefly touch upon the steps to create a report in Jaspersoft Studio. I will be using this Report to explain all the workarounds I will be posting in future. Lets Get Started. Prelude : Jaspersoft Studio can create…