Thursday 12 August 2021

Video Tutorial #044 | BI - Jaspersoft Reports | Composite Element in Jasper Reports

 In this video, you will learn about how to re-use the design using composite element in Jasper Reports. 


You can download the example from : 

https://drive.google.com/file/d/1_WpC77gsX1sTjAoCmq34CW5TEmEBAAk6/view?usp=sharing
https://drive.google.com/file/d/16-0H5K83s4Ckdl2Et8OHHAEh9_oxQ_2F/view?usp=sharing

Thank you for watching this video, I hope this helped you a little on how to re-use the design using composite element in JasperReports. 

If you enjoyed watching it, please do subscribe and click on bell icon for more interesting topics on Jaspersoft Reports.


Let's help save the time for community folks.!

Video Tutorial #043 | BI - Jaspersoft Reports | PDF Export Advanced Properties - Missing font in PDF export in Jasper Reports

 In this video, you will learn about how to fix missing font for PDF export in Jasper Reports. 


You can download the example from : 

https://drive.google.com/file/d/1jUC6AIsOV1OIjqKQnbdT7dJnLfHq2gEE/view?usp=sharing

Thank you for watching this video, I hope this helped you a little on how to fix PDF export missing font issues in JasperReports. 

If you enjoyed watching it, please do subscribe and click on bell icon for more interesting topics on Jaspersoft Reports.

Let's help save the time for community folks.!

Video Tutorial #042 | BI - Jaspersoft Reports | Excel Export Advanced Properties - Split output into multiple sheets in Jasper Reports

 In this video, you will learn about how to export report output into multiple sheets in Excel export in Jasper Reports. 


You can download the example from : 

https://drive.google.com/file/d/1RL8KPghZDcA3ufm3rBuQ9ktCK3n7fuA8/view?usp=sharing

Thank you for watching this video, I hope this helped you a little on how to apply Excel export advanced properties in JasperReports. 

If you enjoyed watching it, please do subscribe and click on bell icon for more interesting topics on Jaspersoft Reports.

Let's help save the time for community folks.!


Video Tutorial #041 | BI - Jaspersoft Reports | Resource Bundle or Localization of reports in Jasper Reports

 In this video, you will learn about Resource Bundle concept (localization of JasperReports) in Jasper Reports. 


You can download the example from : 

https://drive.google.com/file/d/1o11i_cIcs3A0PbNnA2CZA0o9eDr8ZDOm/view?usp=sharing

Thank you for watching this video, I hope this helped you a little on how to localize the JasperReports. 

If you enjoyed watching it, please do subscribe and click on bell icon for more interesting topics on Jaspersoft Reports.

Let's help save the time for community folks.!

Video tutorial #040 | BI - Jaspersoft Reports | Angular Gauge in Jasper Reports

 In this video, you will learn about Angular Gauge in  Jasper Reports. 


You can download the example from : 

https://drive.google.com/file/d/1_LU-NCZv1faGY7wFVGI_zz9ve91MLOEq/view?usp=sharing

Thank you for watching this video, I hope this helped you a little on how to use Angular Gauge in JasperReports. 

If you enjoyed watching it, please do subscribe and click on bell icon for more interesting topics on Jaspersoft Reports.

Let's help save the time for community folks.!


Wednesday 14 July 2021

Video tutorial #039 | BI - Jaspersoft Reports | Drill down reporting using HTML5 Pie chart in Jasper Reports

 In this video, you will learn about Drill down reporting in HTMl5 charts in Jasper Reports. 


You can download the examples from : 

https://drive.google.com/file/d/1iLnB7GGvU5p9Iynu8jeQktP6gjxwJ5Bx/view?usp=sharing
https://drive.google.com/file/d/1CNqpnLqusT_EInCiH7_fhVaMouFgOY2A/view?usp=sharing

Thank you for watching this video, I hope this helped you a little on how to configure drill down properties in HTML5 pie chart. 

If you enjoyed watching it, please do subscribe and click on bell icon for more interesting topics on Jaspersoft Reports.

Let's help save the time for community folks.!

Saturday 10 July 2021

Video Tutorial #038 | BI - Jaspersoft Reports | HTML5 Column and Series Column Charts in Jaspersoft Design Studio

In this video, you will learn about the basics of HTML5 Column and Series Column charts in Jasper Reports. 


You can download the examples from :

https://drive.google.com/file/d/1Nlzt4uGkt_n-E0T9QjsmF4UQs-U2jU_V/view?usp=sharing
https://drive.google.com/file/d/1fB8AwKYKqQuCl6OySSjFYPHdQh38snTg/view?usp=sharing

Thank you for watching this video, I hope this helped you a little on HTML5 Charts(Highcharts) and creating pie, donut, dual level pie charts in Jaspersoft Design Studio Professional. 

If you enjoyed watching it, please do subscribe and click on bell icon for more interesting topics on Jaspersoft Reports.

Let's help save the time for community folks.!

Thursday 8 July 2021

Video Tutorial #037 | BI - Jaspersoft Reports | HTML5 Charts - Pie, Donut, Dual in Jaspersoft Design Studio

 In this video, you will learn about the basics of HTML5 Charts(Highcharts), creating pie, donut, dual level pie charts in Jasper Reports. 


You can download the examples from :
https://drive.google.com/file/d/1uIWvnOCBgjYkOvrK4obZA5MJGWDUtrFd/view?usp=sharing
https://drive.google.com/file/d/1BEAZ8THQE1A7xuX9I_ahNA-7q6mISH6w/view?usp=sharing

Thank you for watching this video, I hope this helped you a little on HTML5 Charts(Highcharts) and creating pie, donut, dual level pie charts in Jaspersoft Design Studio Professional. 

If you enjoyed watching it, please do subscribe and click on bell icon for more interesting topics on Jaspersoft Reports.

Let's help save the time for community folks.!

Saturday 3 July 2021

Video Tutorial #036 | BI - Jaspersoft Reports | Frame Component in Jaspersoft Design Studio

 In this video, you will learn about the usage Frame Component in Jasper Reports. 


You can download the examples from : https://drive.google.com/file/d/1ei2RReZzWzmyAUEhAIi9jvDFuyUFNwlH/view?usp=sharing

Thank you for watching this video, I hope this helped you a little on understanding the usage Frame Component in Jaspersoft Design Studio Professional. 

If you enjoyed watching it, please do subscribe and click on bell icon for more interesting topics on Jaspersoft Reports.

Let's help save the time for community folks.!

Friday 2 July 2021

Video Tutorial #035 | BI - Jaspersoft Reports | List Component in Jaspersoft Design Studio

 In this video, you will learn about the usage List Component Jasper Reports. 


You can download the examples from :
https://drive.google.com/file/d/10-ExEBmosbXvBgS6Qgqsmnyx3HO6W2nI/view?usp=sharing

Thank you for watching this video, I hope this helped you a little on understanding the usage List Component in Jaspersoft Design Studio Professional. 

If you enjoyed watching it, please do subscribe and click on bell icon for more interesting topics on Jaspersoft Reports.

Let's help save the time for community folks.!


Video Tutorial #034 BI - Jaspersoft Reports | Image Component in Jaspersoft Design Studio

 In this video, you will learn about the usage Image Component Jasper Reports. 


You can download the examples from : https://drive.google.com/file/d/1lIXwcC2cDPtH-dnwpWvC9kBxXPi6rAIV/view?usp=sharing Thank you for watching this video, I hope this helped you a little on understanding the usage of Image Component in Jaspersoft Design Studio Professional. If you enjoyed watching it, please do subscribe and click on bell icon for more interesting topics on Jaspersoft Reports. Let's help save the time for community folks.!




Thursday 24 June 2021

Video Tutorial #033 | BI - Jaspersoft Reports | Usage of No Data and Background bands in Jaspersoft Design Studio

In this video, you will learn about the usage of No Data and Background bands  Jasper Reports. 


You can download the examples from : https://drive.google.com/file/d/1WOFWgPdWm7I39gTGsJg0NqeBOKeavGB0/view?usp=sharing

Thank you for watching this video, I hope this helped you a little on understanding the usage of No Data and Background bands  in Jaspersoft Design Studio Professional. 

If you enjoyed watching it, please do subscribe and click on bell icon for more interesting topics on Jaspersoft Reports.

Let's help save the time for community folks.!

Video Tutorial #032 | BI - Jaspersoft Reports | Basic Charts - JFree Pie and Bar Charts in Jaspersoft Design Studio

 In this video, you will learn about Basic charts(JFree Pie and JFree Bar) in Jasper Reports. 


You can download the examples from : 

https://drive.google.com/file/d/1ojXMcc2a14fCZUO6tbY8oHYVcpZv9ORN/view?usp=sharing
https://drive.google.com/file/d/15xkKYFG8sJZsjZp2Es0JSkwSQtS6Z7Vy/view?usp=sharing

Thank you for watching this video, I hope this helped you a little on understanding the Basic Charts(JFree Bar and Pie) in Jaspersoft Design Studio Professional. 

If you enjoyed watching it, please do subscribe and click on bell icon for more interesting topics on Jaspersoft Reports.

Let's help save the time for community folks.!

Tuesday 22 June 2021

Video Tutorial #031 | BI - Jaspersoft Reports | Bands, Database Connection,Report Properties

 In this video, you will learn about bands, Database connections and Report properties 


Thank you for watching this video, I hope this helped you a little on understanding the basic of bands, JDBC data source connectiona and 

properties of a report in Jaspersoft Design Studio Professional. 

If you enjoyed watching it, please do subscrib and click on bell icon for more interesting topics on Jaspersoft Reports.

Let's help save the time for community folks.!

Monday 21 June 2021

Video Tutorial #030 | BI - Jaspersoft Reports | Overview of Jaspersoft Reports


 In this video, you will learn about the Overview of JasperReports 

Thank you for watching this video, I hope this helped you a little on understanding the overview of JasperReports. 

If you enjoyed watching it, please do subscrib and click on bell icon for more interesting topics on Jaspersoft Reports.

Let's help save the time for community folks.!




Thursday 17 June 2021

Video Tutorial #029 | BI - Jaspersoft Reports | Hyperlinking and Drilldown reports in Jaspersoft Reports

 In this video, you will learn about Hyperlinking and Drilldown reports in Jaspersoft Report

https://drive.google.com/drive/folders/11y7ilkQ-6L82Bioc5KnIGs7hsPUYR-hy?usp=sharing

Thank you for watching this video, I hope this helped you a little on understanding the basic of Hyperlinking and drill down reports in Jaspersoft Design Studio Professional. 

If you enjoyed watching it, please do subscrib and click on bell icon for more interesting topics on Jaspersoft Reports.

Let's help save the time for community folks.!

Saturday 12 June 2021

Video Tutorial #028 | BI - Jaspersoft Reports | Anchors and Bookmarks in Jaspersoft Design Studio

 In this video, you will learn about the basics of Anchors and Bookmarks  in Jaspersoft Design Studio 

Download the example from: 
https://drive.google.com/file/d/1glTwV5Mz2ZtslO4f_QqaX7cpVZc9HKX9/view?usp=sharing


Thank you for watching this video, I hope this helped you a little on understanding the basic of Anchors and Bookmarks in Jaspersoft Design Studio Professional. 

If you enjoyed watching it, please do subscribe and click on bell icon for more interesting topics on Jaspersoft Reports.

Let's help save the time for community folks.!



Friday 11 June 2021

Video Tutorial #027 | BI - Jaspersoft Reports | Subreports in Jaspersoft Design Studio

 In this video, you will learn about Subreports and how to call a Subreport from Master report by passing a parameter in Jaspersoft Design Studio 

https://youtu.be/8pPDklPJ6B4


Thank you for watching this video, I hope this helped you a little on understanding the basic of Subreports in Jaspersoft Design Studio Professional. 

If you enjoyed watching it, please do subscribe, click on bell icon for more interesting topics on Jaspersoft Reports.

Let's help save the time for community folks.!


Wednesday 9 June 2021

Video Tutorial #026 | BI - Jaspersoft Reports | Styles and alternative colors for rows in Jaspersoft Design Studio

In this video, you will learn about Styles and how to get alternative colors (say row banding) for rows in a Product detail report using Jaspersoft Design Studio You can download the example file using the link below: https://drive.google.com/file/d/1RuEuPCWge9fBdwzHKuDYcXUPl9duY_vr/view?usp=sharing


Thank you for watching this video, I hope this helped you a little on understanding about Styles and how to create conditional styles for Product detail report using Jaspersoft Design Studio too. 

If you enjoyed watching it, please do subscribe and click on bell icon for more interesting topics on Jaspersoft Reports.

Let's help save time for community folks. 

Tuesday 8 June 2021

Video Tutorial #025 | BI - Jaspersoft Reports | Connecting to JasperReportsServer in Studio and Publish a Report

In this video, you will learn how to connect to JasperReports Server from studio and how to publish a report to the server. 

 Download the example file from https://drive.google.com/file/d/16M7IMJDBKKZX1DzwkvcDt8CVuNAGsAPz/view?usp=sharing



Thank you for watching this video, I hope this helped you a little on understanding on how to make connection to JasperReports server in the studio and publishing a report. 

If you enjoyed watching it, please do subscribe, click on bell icon for more interesting topics on Jaspersoft Reports.

Let's help save time for community folks. 

Monday 7 June 2021

Video Tutorial #024 | BI - Jaspersoft Reports | Crosstab component in Jaspersoft Design Studio

Hi, In this video, you will learn the ins and outs of a Crosstab component in Jaspersoft Design Studio Professional. 

Download the example file from https://drive.google.com/file/d/1kVXSnaAsoxOHY73sv2tjuLVa3jWUCvhm/view?usp=sharing


Thank you for watching this video, I hope this helped you a little on understanding the basic of Table component  in Jaspersoft Design Studio Professional. 

If you enjoyed watching it, please do subscribe, click on bell icon for more interesting topics on Jaspersoft Reports.

Let's help save time for community folks.  

Video Tutorial #023 | BI - Jaspersoft Reports | Table component in Jaspersoft Design Studio


In this video, you will learn the basic usage of Table component in Jaspersoft Design Studio Professional. 

Download the example file from 

https://drive.google.com/file/d/1gtJihNHgSrDYVNeZCqqvClNpCPXHXzXH/view?usp=sharing




Thank you for watching this video, I hope this helped you a little on understanding the basic of Table component  in Jaspersoft Design Studio Professional. 

If you enjoyed watching it, please do subscribe, click on bell icon for more interesting topics on Jaspersoft Reports.

Let's help save time for community folks. 



Wednesday 2 June 2021

Video Tutorial #22 | BI - Jaspersoft Reports | Understanding Datasets and Sub datasets in Jaspersoft Design Studio

In this video, you will learn the basics of Datasets and Sub datasets in Jaspersoft Design Studio Professional. 

Download the example file from  https://drive.google.com/file/d/1TPpbjYE0-FiBijlPZXFxf9Tjbt2d2vlt/view?usp=sharing



Thank you for watching this video, I hope this helped you a little on understanding the basic of Datasets and Subdatasets in Jaspersoft Design Studio Professional. 

If you enjoyed watching it, please do subscribe, click on bell icon for more interesting topics on Jaspersoft Reports.

Let's help save time for community folks. 

Tuesday 1 June 2021

Video Tutorial #21 | BI - Jaspersoft Reports | Groups & finding sub-totals by grouping data in Jasper Design Studio

 Hi, 

In this video, you will learn the basics of Groups and how to calculate sub-totals for each group in a Product Detail Report using Jaspersoft Design Studio Professional.

Download the example file from https://drive.google.com/file/d/1B_SPsPDnalSMMCFCar1z1slkQtIjqXpu/view?usp=sharing



Thank you for watching this video, I hope this helped you a little on understanding the basic of Groups in Jaspersoft Design Studio Professional. 

If you enjoyed watching it, please do subscribe, click on bell icon for more interesting topics on Jaspersoft Reports.

Let's help save time for community folks. 

Monday 31 May 2021

Video Tutorial #020 | BI - Jaspersoft Reports | Variables Introduction and How to sum-up a column in Jaspersoft Design Studio Professional

Hi, Welcome to the series of Jaspersoft Reports.

In this video, you will learn the basics of variables and how to create and use a variable in Product Detail Report using Jaspersoft Design Studio Professional.

Download the example file from https://drive.google.com/file/d/1B_SPsPDnalSMMCFCar1z1slkQtIjqXpu/view?usp=sharing



Thank you for watching this video, I hope this helped you a little on understanding the basic of variables in Jaspersoft Design Studio Professional. 

If you enjoyed watching it, please do subscribe, click on bell icon for more interesting topics on Jaspersoft Reports.
Let's help save time for community folks. 


Sunday 30 May 2021

Video Tutorial #019 | BI - Jaspersoft Reports | Parameters & Single Select Parameter in Jaspersoft Design Studio

Hi, Welcome to the series of Jaspersoft Reports.

In this video, you will learn the basics of parameter(s) and how to create and use a single select parameter in a Product Detail Report using Jaspersoft Design Studio Professional.

Download the example file from https://drive.google.com/file/d/1B_SPsPDnalSMMCFCar1z1slkQtIjqXpu/view?usp=sharing


Thank you for watching this video, I hope this helped you a little on understanding the basic of parameter and single select parameter usage in Jaspersoft Design Studio Professional. 

If you enjoyed watching it, please do subscribe and click on bell icon for more interesting topics on Jaspersoft Reports. 

Tuesday 2 March 2021

Revisit Tip : Multi Select Parameter Example in Jaspersoft Design Studio Reports | How to give default values for multi select paraemter in Jasper Reports

Revisit : Multi Select Parameter Example in Jasper Reports 

Default value expression: 
java.util.Arrays.asList(new String[]{"99993","99962","99949"})  

References: 
https://community.jaspersoft.com/questions/520702/default-select-values-multi-select-prompt

Parameter Properties : 
Server output: 


JRXML 
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.4.21.final using JasperReports Library version 6.4.1  -->
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="MultiSelectParameterDefaultValue" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="0a843e05-bf78-488a-bb0d-44f948a799f6">
	<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="foodmart"/>
	<property name="ireport.jasperserver.url" value="http://localhost:8080/jasperserver-pro/"/>
	<property name="ireport.jasperserver.user" value="superuser"/>
	<property name="ireport.jasperserver.report.resource" value="/EarthlySystems/Multi_Select_Parameter_Demo/Multi_Select_Parameter_Default_Value_files/main_jrxml"/>
	<property name="ireport.jasperserver.reportUnit" value="/EarthlySystems/Multi_Select_Parameter_Demo/Multi_Select_Parameter_Default_Value"/>
	<parameter name="paramPostalCode" class="java.util.Collection" nestedType="java.lang.String">
		<defaultValueExpression><![CDATA[java.util.Arrays.asList(new String[]{"99993","99962","99949"})  

]]></defaultValueExpression>
	</parameter>
	<queryString language="SQL">
		<![CDATA[select * from customer where $X{IN, postal_code, paramPostalCode}]]>
	</queryString>
	<field name="customer_id" class="java.lang.Integer"/>
	<field name="account_num" class="java.lang.Long"/>
	<field name="lname" class="java.lang.String"/>
	<field name="fname" class="java.lang.String"/>
	<field name="mi" class="java.lang.String"/>
	<field name="address1" class="java.lang.String"/>
	<field name="address2" class="java.lang.String"/>
	<field name="address3" class="java.lang.String"/>
	<field name="address4" class="java.lang.String"/>
	<field name="city" class="java.lang.String"/>
	<field name="state_province" class="java.lang.String"/>
	<field name="postal_code" class="java.lang.String"/>
	<field name="country" class="java.lang.String"/>
	<field name="customer_region_id" class="java.lang.Integer"/>
	<field name="phone1" class="java.lang.String"/>
	<field name="phone2" class="java.lang.String"/>
	<field name="birthdate" class="java.sql.Date"/>
	<field name="marital_status" class="java.lang.String"/>
	<field name="yearly_income" class="java.lang.String"/>
	<field name="gender" class="java.lang.String"/>
	<field name="total_children" class="java.lang.Integer"/>
	<field name="num_children_at_home" class="java.lang.Integer"/>
	<field name="education" class="java.lang.String"/>
	<field name="date_accnt_opened" class="java.sql.Date"/>
	<field name="member_card" class="java.lang.String"/>
	<field name="occupation" class="java.lang.String"/>
	<field name="houseowner" class="java.lang.String"/>
	<field name="num_cars_owned" class="java.lang.Integer"/>
	<field name="fullname" class="java.lang.String"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="36" splitType="Stretch">
			<textField>
				<reportElement mode="Opaque" x="0" y="0" width="555" height="36" backcolor="#ECE0FF" uuid="f4bc67c0-499c-48cd-af15-6703eb08f358">
					<property name="com.jaspersoft.studio.unit.y" value="pixel"/>
				</reportElement>
				<box>
					<pen lineColor="#D6D0D0"/>
					<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="12" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA["Customer Detail Report By Postal Code"]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<columnHeader>
		<band height="30" splitType="Stretch">
			<staticText>
				<reportElement x="0" y="0" width="81" height="30" uuid="950cfd64-6561-445f-aa06-df9d92402d33"/>
				<box>
					<pen lineColor="#D6D0D0"/>
					<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[customer_id]]></text>
			</staticText>
			<staticText>
				<reportElement x="81" y="0" width="79" height="30" uuid="60014d13-d4e3-49e1-85f7-cec9b3860db2"/>
				<box>
					<pen lineColor="#D6D0D0"/>
					<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[account_num]]></text>
			</staticText>
			<staticText>
				<reportElement x="160" y="0" width="79" height="30" uuid="8298d207-c566-4c62-96af-7c5ec3438111"/>
				<box>
					<pen lineColor="#D6D0D0"/>
					<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[lname]]></text>
			</staticText>
			<staticText>
				<reportElement x="239" y="0" width="79" height="30" uuid="1f425d7f-2817-4cda-b688-42c48dc72ee5"/>
				<box>
					<pen lineColor="#D6D0D0"/>
					<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[city]]></text>
			</staticText>
			<staticText>
				<reportElement x="318" y="0" width="79" height="30" uuid="cc44460f-c5ea-4c7f-b24c-9f1313ffaa13"/>
				<box>
					<pen lineColor="#D6D0D0"/>
					<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[state_province]]></text>
			</staticText>
			<staticText>
				<reportElement x="397" y="0" width="79" height="30" uuid="2f6d5fe4-8130-40c5-8f65-e3845b818625"/>
				<box>
					<pen lineColor="#D6D0D0"/>
					<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[postal_code]]></text>
			</staticText>
			<staticText>
				<reportElement x="476" y="0" width="79" height="30" uuid="3381d500-9086-431c-9678-cef469425d11"/>
				<box>
					<pen lineColor="#D6D0D0"/>
					<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[country]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="30" splitType="Stretch">
			<textField>
				<reportElement x="0" y="0" width="81" height="30" uuid="d9d71552-8c5d-4f5f-adc5-f688e7d1b26e">
					<property name="com.jaspersoft.studio.unit.y" value="pixel"/>
				</reportElement>
				<box>
					<pen lineColor="#D6D0D0"/>
					<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{customer_id}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="81" y="0" width="79" height="30" uuid="5bc3525d-9b53-479e-bc3f-b6f78898c4a0"/>
				<box>
					<pen lineColor="#D6D0D0"/>
					<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{account_num}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="160" y="0" width="79" height="30" uuid="8f4c3632-b891-470f-8c6b-e7ad7d7b45d5"/>
				<box>
					<pen lineColor="#D6D0D0"/>
					<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{lname}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="239" y="0" width="79" height="30" uuid="e288ef3a-54ad-4832-99c6-d5cdcea3c8cb"/>
				<box>
					<pen lineColor="#D6D0D0"/>
					<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{city}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="318" y="0" width="79" height="30" uuid="ec922197-b510-4504-ac83-39bb76c4c252"/>
				<box>
					<pen lineColor="#D6D0D0"/>
					<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{state_province}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="397" y="0" width="79" height="30" uuid="6ed97799-b8d8-4398-9714-475844cc536f"/>
				<box>
					<pen lineColor="#D6D0D0"/>
					<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{postal_code}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="476" y="0" width="79" height="30" uuid="4f6b9312-5caf-4b7a-8596-5a6891ce97f1"/>
				<box>
					<pen lineColor="#D6D0D0"/>
					<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
					<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#D6D0D0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{country}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
</jasperReport>

Thursday 4 February 2021

Tip : Fusion bar chart title and legend advanced properties in jasper reports

 Fusion Chart 

Chart title properties

{ "chart": { "captionFont": "Arial", "captionFontSize": "18", "captionFontColor": "#993300", "captionFontBold": "1" } }

https://www.fusioncharts.com/dev/chart-guide/chart-configurations/caption-and-sub-caption

Legend properties

{ "chart": { "legendItemFontBold": "0", "legendItemFont": "Arial", "legendItemFontSize": "11", "legendItemFontColor": "#666666" } }


https://www.fusioncharts.com/dev/chart-guide/chart-configurations/legend