Back to Top

4 Apr 2016

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 to Redshift Cluster using Jaspersoft studio’s community version, and I started to look into the possibilities. I […]

Continue reading..Jaspersoft Studio – Connecting to Redshift Cluster from Community Edition
6 Oct 2015

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 a Report using JSON file. Please refer to the same to understand How to create the JSON […]

Continue reading..Creating Report Using JSON file with Parameter – Jaspersoft Studio
23 Jun 2015

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 have created a simple .csv file with the test data provided by the person who has asked […]

Continue reading..Jaspersoft Studio – Creating Cross-Tab Report for 2-Dim Data Display
20 Jan 2015

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 field is not created yet. 2) Create Current_Value Field and ass your column as expression. 3) Now […]

Continue reading..Subtract Current Value from Previous Value in Jaspersoft Studio
16 Jan 2015

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 the following link C:\Jaspersoft\jasperreports-server-your-version\apache-tomcat\webapps\jasperserver-pro\WEB-INF\js.quartz.properties Update the file with information colored in yellow c. The Information updated by […]

Continue reading..Report Bursting In Jasperserver
3 Dec 2014

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 we go….. 1) Create a simple JSON file with some JSON Data. For this purpose I have […]

Continue reading..Creating a Simple Report using JSON File in Jaspersoft Studio
29 Oct 2014

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 dataset and finding the problem. I have used a sample report with CSV file created for this […]

Continue reading..Selecting Top N Values from a CSV Datasource – Jaspersoft Studio
17 Oct 2014

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 Sample Database to create the report. 2) My Query is as follows. 3) Notice that there is […]

Continue reading..Using SubSelect in SQL Query in Jaspersoft Studio
16 Oct 2014

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 in the image. 3) Now Open the Jaspersoft Studio and On the Repository panel Right Click on […]

Continue reading..Creating a DataSource using Excel FILE (CSV Format) in Jaspersoft Studio
15 Oct 2014

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 column and then the total has to be a running total. This is surely a challenge and […]

Continue reading..Creating Running Total in Jaspersoft Studio