Back to Top

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
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
30 Sep 2014

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 a parameter input and will display Country level data or P_CITY as parameter value and display city […]

Continue reading..Change the Chart Axis Dynamically – Jaspersoft Studio
17 Sep 2014

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 and rename it as intended. 2) Select the Class as String if your Field is a string, […]

Continue reading..Increment a Variable in Jaspersoft Studio
25 Aug 2014

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 and modified it to achieve the required result. I created 2 Parameters. 1) To accept user input […]

Continue reading..Conditional Query – Using Parameter Value in the Query to Fetch Data