Back to Top

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
23 Jul 2014

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 on the Bands Report Header, Detail…etc except Title and Summary Band and delete them. Summary and Title […]

Continue reading..Jaspersoft Studio Sub-Report Development Steps
21 Jul 2014

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 drop a column with No Calculation Function, It will display the first indexed value. Please see the […]

Continue reading..Display List of Records in the Title Bar – Jaspersoft Studio
16 Jul 2014

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 Conditional Query, I just assume that you have basic knowledge of report building using Jasper Studio without […]

Continue reading..Conditional Query Using Parameters in Jaspersoft Studio
15 Jul 2014

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 on the SQL to fetch data. There will not be a value list appearing for this parameter. […]

Continue reading..Creating A Multi-Select Parameter in Jaspersoft Studio
10 Jul 2014

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 Pie Chart. 4) Use the Value and Key parameter as follows. 5) Preview teh Report and the […]

Continue reading..Display % Value of Each Slice Inside Pie Chart Slices – Jaspersoft Studio
10 Jul 2014

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 as shown below. 5) Click Read Filelds – This will populate the Fields selected in the query […]

Continue reading..Creating a Report in Jaspersoft Studio using MDX query and a Parameter