Back to Top

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
1 Oct 2014

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 result preview are as below) 2) Note that the data is split across 27 pages. 3) Now […]

Continue reading..Jaspersoft Studio – Ignore Pagination