Back to Top

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

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,                                           ORDERS.SHIPCITY,         […]

Continue reading..Display Total On Each Column Of Stacked Bar In jaspersoft (Direct Approach)
8 Jul 2014

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 Jaspersoft Studio with a Query including the required total Value in the query. I have used a […]

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