Filter by tags:
July 17, 2018
Composite element example in Jaspersoft Reports
( JasperSoft BI Suite Tutorials - Sadakar Pochampalli )
Hi,
Composite element allow to create a new element in the palette starting from one or more basic elements, and reuse them whenever you want in any report.
As shown in below image you can take basic elements like Text Field and Ellipse from palette. Right click on the selection of these two to create composite element and give required details(name, description and an icon with position to keep it on the palette).
(NOTE : Click on image to get the best view of content placed)
(NOTE : Click on image to get the best view of content placed)
Composite element allows below actions(Edit, Export and Import) in studio.
This way you can create a custom element in palette and use in a project if you have to re-use the code/design. i.e., this will give the flexibility of re-usability of design across reports. kinda a components based templates.
References: https://community.jaspersoft.com/wiki/composite-element
- Sadakar Pochampalli
JRXML:(Supports in 6.4.2 professional or later).
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.4.2.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="CompositeElementExample" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="ab08f6fe-e37c-42b7-8721-c46a41536ae3">
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/>
<queryString>
<![CDATA[]]>
</queryString>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="133" splitType="Stretch">
<textField>
<reportElement x="138" y="40" width="100" height="30" uuid="0035655a-100c-4dac-a8b8-a91e6a916b0d"/>
<textFieldExpression><![CDATA["Text Field"]]></textFieldExpression>
</textField>
<ellipse>
<reportElement x="240" y="10" width="100" height="79" uuid="3207973b-e49e-43cc-9611-6ed03ce5b3cd"/>
</ellipse>
</band>
</title>
<pageHeader>
<band height="35" splitType="Stretch"/>
</pageHeader>
<columnHeader>
<band height="61" splitType="Stretch"/>
</columnHeader>
<detail>
<band height="125" splitType="Stretch"/>
</detail>
<columnFooter>
<band height="45" splitType="Stretch"/>
</columnFooter>
<pageFooter>
<band height="54" splitType="Stretch"/>
</pageFooter>
<summary>
<band height="42" splitType="Stretch"/>
</summary>
</jasperReport>
Composite element allow to create a new element in the palette starting from one or more basic elements, and reuse them whenever you want in any report.
As shown in below image you can take basic elements like Text Field and Ellipse from palette. Right click on the selection of these two to create composite element and give required details(name, description and an icon with position to keep it on the palette).
(NOTE : Click on image to get the best view of content placed)
(NOTE : Click on image to get the best view of content placed)
Composite element allows below actions(Edit, Export and Import) in studio.
This way you can create a custom element in palette and use in a project if you have to re-use the code/design. i.e., this will give the flexibility of re-usability of design across reports. kinda a components based templates.
References: https://community.jaspersoft.com/wiki/composite-element
- Sadakar Pochampalli
JRXML:(Supports in 6.4.2 professional or later).
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.4.2.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="CompositeElementExample" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="ab08f6fe-e37c-42b7-8721-c46a41536ae3">
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/>
<queryString>
<![CDATA[]]>
</queryString>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="133" splitType="Stretch">
<textField>
<reportElement x="138" y="40" width="100" height="30" uuid="0035655a-100c-4dac-a8b8-a91e6a916b0d"/>
<textFieldExpression><![CDATA["Text Field"]]></textFieldExpression>
</textField>
<ellipse>
<reportElement x="240" y="10" width="100" height="79" uuid="3207973b-e49e-43cc-9611-6ed03ce5b3cd"/>
</ellipse>
</band>
</title>
<pageHeader>
<band height="35" splitType="Stretch"/>
</pageHeader>
<columnHeader>
<band height="61" splitType="Stretch"/>
</columnHeader>
<detail>
<band height="125" splitType="Stretch"/>
</detail>
<columnFooter>
<band height="45" splitType="Stretch"/>
</columnFooter>
<pageFooter>
<band height="54" splitType="Stretch"/>
</pageFooter>
<summary>
<band height="42" splitType="Stretch"/>
</summary>
</jasperReport>
July 17, 2018
July 16, 2018
How is your palette looking in Jaspersoft Studio ?
( JasperSoft BI Suite Tutorials - Sadakar Pochampalli )
Are you tired of easily finding the components of palette to design reports in jaspersoft studio?
You can use the combination of "large icons" with "Layout" as "Columns" instead of routine look and feel. As shown in below image, right click on any empty space in the window, let's say in "Basic Elements" section, right click anywhere and select "Use Large Icons" with the combination of "Layout" as "Columns" and have an easy access to the components when you write some complex reports. !
Cheers! Small things sometimes saves a bit time.
- Sadakar Pochampalli
July 16, 2018
Tip : Relatively increase the height of the less text contained field with the maximum text contain…
( JasperSoft BI Suite Tutorials - Sadakar Pochampalli )
Hi,
Expected output should be as shown in below image.
Solution: (Read the image properties - outlined red in color)
Related article can be found here :
http://jasper-bi-suite.blogspot.com/2016/03/tip-detail-overflow-vs-streach-with.html
JRXML(Supports in 6.4.2 professional version)
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.4.2.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="Frames" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="5ac4213c-a87a-46d0-bfd2-bfff11545590">
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/>
<property name="ireport.callouts" value="callouts.1.fg=0,0,0\ncallouts.1.text=sadakar 7/17/18 1\:20 AM\r\n\r\nAppearance section\r\n------------------------------\r\nPosition Type \= Float\r\nStretch Type \= Relative to Tallest Object\r\n\r\nText field section\r\n--------------------------\r\nCheck Streatch with Overflow\r\n\r\nOther references\r\nhttps\://community.jaspersoft.com/blog/tip-detail-overflow-vs-stretch-overflow-jasper-reports-when-use-how-avoid-repetaitonimages-or\ncallouts.1.bounds=50,60,360,250\ncallouts.1.bg=255,255,0\n"/>
<queryString>
<![CDATA[]]>
</queryString>
<background>
<band splitType="Stretch"/>
</background>
<summary>
<band height="30" splitType="Stretch">
<textField isStretchWithOverflow="true">
<reportElement positionType="Float" stretchType="RelativeToTallestObject" x="0" y="0" width="100" height="30" uuid="eb1d8f3e-313a-469f-a4a9-6585d7c3388a"/>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textFieldExpression><![CDATA["Hi"]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true">
<reportElement positionType="Float" stretchType="RelativeToTallestObject" x="100" y="0" width="100" height="30" uuid="8bc5b479-d3d7-4f30-b77a-8d69f2da10e0"/>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textFieldExpression><![CDATA["Yakuza Solo hopes his bamboo bicycle will make the world aware of his home state of Nagaland."]]></textFieldExpression>
</textField>
</band>
</summary>
</jasperReport>
July 16, 2018
July 5, 2018
Inspired by the visual treat of Blue Planet II series by BBC. We have created this re-score.
July 5, 2018
May 28, 2018
Tip : Usage of COLUMN_NUMBER variable in Jaspersoft Studio reports
( JasperSoft BI Suite Tutorials - Sadakar Pochampalli )
Hi folks,
Recently, I wrote about the usage of horizontal display (looks like vertical display) of sql output in jaspersoft studio at read it here.
At report level to display the row number with detail band we use "REPORT_COUNT" variable, what if you want to display the column numbers when displaying the records in horizontal view(looks like vertical) ?
Use "COLUMN_NUMBER" variable in a text expression. i.e., ${COLUMN_NUMBER}.
Watch video tutorial for the same example below(with voice)
Sample screenshot is shown in below: (An example of fixed number of customers to display)
(Click on image to get the best view)
Sample screenshot of the report design:
(Click on image to get the best view)
Variable usage :
(Click on image to get the best view)
JRXML: ( Supports in 6.4.2 Pro or later) - The example uses "foodmart" db of postgresql.
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.4.2.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="ColumnNumber" columnCount="10" printOrder="Horizontal" pageWidth="1000" pageHeight="240" columnWidth="100" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="4b5118e2-f385-4f14-a743-8c42ce6f64f8">
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="foodmart"/>
<property name="com.jaspersoft.studio.unit." value="pixel"/>
<property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/>
<property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/>
<property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/>
<property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/>
<queryString language="SQL">
<![CDATA[SELECT * FROM customer limit 10]]>
</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"/>
<title>
<band height="30">
<textField>
<reportElement mode="Opaque" x="0" y="0" width="1000" height="30" backcolor="#C4BFBE" uuid="f5f8aa2e-b32c-4e01-9cd4-eced9709e8e5">
<property name="com.jaspersoft.studio.unit.height" value="pixel"/>
</reportElement>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="20" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA["COLUMN_NUMBER variable usage"]]></textFieldExpression>
</textField>
</band>
</title>
<detail>
<band height="210" splitType="Stretch">
<property name="com.jaspersoft.studio.unit.height" value="pixel"/>
<textField>
<reportElement x="0" y="30" width="100" height="30" uuid="c06c9319-9184-44f7-93ea-727751f38877"/>
<box leftPadding="5">
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{customer_id}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="0" y="60" width="100" height="30" uuid="64bcc1b5-899e-4433-a3a7-b73e8d4a5dfc"/>
<box leftPadding="5">
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{fullname}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="0" y="90" width="100" height="30" uuid="6628fe84-1bc9-42c2-9d5f-d08e0f9b891a"/>
<box leftPadding="5">
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{country}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="0" y="120" width="100" height="30" uuid="0b1a3b1f-3878-4e64-a5fc-ca33cda52c66"/>
<box leftPadding="5">
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{yearly_income}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="0" y="150" width="100" height="30" uuid="33c68e73-de62-4287-9154-9a1f76730d3a"/>
<box leftPadding="5">
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{gender}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="0" y="180" width="100" height="30" uuid="a8e7cf7d-26de-4078-ae16-c9e6322bdd0c"/>
<box leftPadding="5">
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{occupation}]]></textFieldExpression>
</textField>
<textField>
<reportElement mode="Opaque" x="0" y="0" width="100" height="30" backcolor="#E3E1E1" uuid="dc7a89ed-2fe5-4b5a-a7c2-ec32148e009a"/>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<textFieldExpression><![CDATA["Customer"+" "+$V{COLUMN_NUMBER}]]></textFieldExpression>
</textField>
</band>
</detail>
</jasperReport>
Recently, I wrote about the usage of horizontal display (looks like vertical display) of sql output in jaspersoft studio at read it here.
At report level to display the row number with detail band we use "REPORT_COUNT" variable, what if you want to display the column numbers when displaying the records in horizontal view(looks like vertical) ?
Use "COLUMN_NUMBER" variable in a text expression. i.e., ${COLUMN_NUMBER}.
Watch video tutorial for the same example below(with voice)
Sample screenshot is shown in below: (An example of fixed number of customers to display)
(Click on image to get the best view)
Sample screenshot of the report design:
(Click on image to get the best view)
Variable usage :
(Click on image to get the best view)
JRXML: ( Supports in 6.4.2 Pro or later) - The example uses "foodmart" db of postgresql.
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.4.2.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="ColumnNumber" columnCount="10" printOrder="Horizontal" pageWidth="1000" pageHeight="240" columnWidth="100" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="4b5118e2-f385-4f14-a743-8c42ce6f64f8">
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="foodmart"/>
<property name="com.jaspersoft.studio.unit." value="pixel"/>
<property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/>
<property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/>
<property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/>
<property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/>
<queryString language="SQL">
<![CDATA[SELECT * FROM customer limit 10]]>
</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"/>
<title>
<band height="30">
<textField>
<reportElement mode="Opaque" x="0" y="0" width="1000" height="30" backcolor="#C4BFBE" uuid="f5f8aa2e-b32c-4e01-9cd4-eced9709e8e5">
<property name="com.jaspersoft.studio.unit.height" value="pixel"/>
</reportElement>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="20" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA["COLUMN_NUMBER variable usage"]]></textFieldExpression>
</textField>
</band>
</title>
<detail>
<band height="210" splitType="Stretch">
<property name="com.jaspersoft.studio.unit.height" value="pixel"/>
<textField>
<reportElement x="0" y="30" width="100" height="30" uuid="c06c9319-9184-44f7-93ea-727751f38877"/>
<box leftPadding="5">
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{customer_id}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="0" y="60" width="100" height="30" uuid="64bcc1b5-899e-4433-a3a7-b73e8d4a5dfc"/>
<box leftPadding="5">
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{fullname}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="0" y="90" width="100" height="30" uuid="6628fe84-1bc9-42c2-9d5f-d08e0f9b891a"/>
<box leftPadding="5">
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{country}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="0" y="120" width="100" height="30" uuid="0b1a3b1f-3878-4e64-a5fc-ca33cda52c66"/>
<box leftPadding="5">
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{yearly_income}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="0" y="150" width="100" height="30" uuid="33c68e73-de62-4287-9154-9a1f76730d3a"/>
<box leftPadding="5">
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{gender}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="0" y="180" width="100" height="30" uuid="a8e7cf7d-26de-4078-ae16-c9e6322bdd0c"/>
<box leftPadding="5">
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{occupation}]]></textFieldExpression>
</textField>
<textField>
<reportElement mode="Opaque" x="0" y="0" width="100" height="30" backcolor="#E3E1E1" uuid="dc7a89ed-2fe5-4b5a-a7c2-ec32148e009a"/>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<textFieldExpression><![CDATA["Customer"+" "+$V{COLUMN_NUMBER}]]></textFieldExpression>
</textField>
</band>
</detail>
</jasperReport>
May 28, 2018
May 14, 2018
May 14, 2018
May 7, 2018
Tip : Horizontal(looks like vertical) display of detailed records in jasper reports - convert rows …
( JasperSoft BI Suite Tutorials - Sadakar Pochampalli )
Hi folks,
In this tip, you would see how to convert sql rows into report columns.
By default when you put text fields in detail band, you could see the report prints the query output in vertical order(row by row). There are some situations when your query results definite number of rows in output and need them to be displayed as horizontal view.
In this case, usually one might think of cross tab implementation. This is fine upto some extent but working with cross tab is not always developer friendly hence instead of using it one can split the report into N number columns in reports properties and provide desired width for columns and then pull your fields one below to other. In the report advanced properties change Print Order property from Vertical to Horizontal and this would result converting rows output into columns that would look like a cross tab implementation.
Design:
Query format/Sample query output
Sample output:
JRXML: (Developed using 6.4.2 professional - it should also works in community[not tested])
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.4.2.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="columns" columnCount="5" printOrder="Horizontal" pageWidth="650" pageHeight="842" columnWidth="120" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" whenResourceMissingType="Error" uuid="adca597a-f8d3-4f9f-ae19-21b3272acdb9">
<property name="com.jaspersoft.studio.unit." value="pixel"/>
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="foodmart"/>
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<queryString>
<![CDATA[(SELECT 100 customerID, 'Sadakar' CustomerName, 'Hyd' CustomerCity FROM customer limit 1)
UNION ALL
(SELECT 101 customerID, 'Hasini' CustomerName, 'MNCL' CustomerCity FROM customer limit 1)
UNION ALL
(SELECT 102 customerID, 'Venkat' CustomerName, 'Banglore' CustomerCity FROM customer limit 1)
UNION ALL
(SELECT 103 customerID, 'Robert' CustomerName, 'Chenni' CustomerCity FROM customer limit 1)
UNION ALL
(SELECT 104 customerID, 'Soujanya' CustomerName, 'MMR' CustomerCity FROM customer limit 1)]]>
</queryString>
<field name="customerid" class="java.lang.Integer"/>
<field name="customername" class="java.lang.String"/>
<field name="customercity" class="java.lang.String"/>
<pageHeader>
<band height="46" splitType="Stretch">
<textField>
<reportElement x="0" y="0" width="610" height="46" uuid="217244d6-5976-4298-bf74-d5e93099b5c7"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="16"/>
</textElement>
<textFieldExpression><![CDATA["Horizontal display of definite number of rows output like a cross tab view"]]></textFieldExpression>
</textField>
</band>
</pageHeader>
<detail>
<band height="93" splitType="Stretch">
<textField>
<reportElement x="0" y="3" width="100" height="30" uuid="160c2caa-87e8-4757-8b6d-7ff9daad46e8"/>
<textFieldExpression><![CDATA[$F{customerid}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="0" y="33" width="100" height="30" uuid="91ef78c5-4eae-43a4-9f64-8a6848961018"/>
<textFieldExpression><![CDATA[$F{customername}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="0" y="63" width="100" height="30" uuid="f3c5ce61-e141-409e-8b21-86d4cdbfd7e5"/>
<textFieldExpression><![CDATA[$F{customercity}]]></textFieldExpression>
</textField>
</band>
</detail>
</jasperReport>
May 7, 2018
April 21, 2018
Tip : Return variable(s) from Table component Dataset to display on Title band of report in Japsers…
( JasperSoft BI Suite Tutorials - Sadakar Pochampalli )
Hi folks,
A table component in Jaspersoft requires a data set to be created and it can be done as usual but what if you want to display the calculations from table component outside of it's area on the same report or may be in some other report.
We use "Return variables" concept on data sets that are being used by the components. For instance, below image is an example to display the avg shelf height and total shelf depth columns of table component outside of its(table) area. i.e, display the avg and total, say in "Title" band or say at some specific portion in Summary band.
(Click on image to get best view of the content written over it)
To accomplish it, create variables in Dataset of the table component.
For instance, Calculating Avg Shelf
1) Create a variable in table data set, say "tableVarShelfHeight" of type Double in my case and the Calculation is Average and the Expression is $F{shelf_height} and IncrementType as None and Reset Type as Report.
2) Create a another variable in report variables, say "reportVarShelfHeight", of type Double and with Calculation as "No Calculation Function" and IncrementType as None and Reset Type as Report
3) Now, click on the Table component, and in its properties be on "Dataset" section and then click on the button called "Return Variables". In the pop-up window opened click on "Add" button to add then give the values for "From Variable" as "tableVarShelfHeight" and "To Variable" as "reportVarShelfHeight".
4) Now, from the report outline, and from the variables drag on drop the "reportVarShelfHeight" to the "Title" band and change its "Evaluation Time" as "Report" (by default it would be "None")
5) Follow, the same steps to create tableVarShelfDepth variable for total.
This way, a calculation created in data sets of table component can be utilized on Title band of the same report.
Want to look at the explained example instantly, copy and paste below JRXML in your test JRXML and observe the implementation.!
Hope it would be some help to you.!
Until Next Tip/Post,
Sadakar Pochampalli
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.4.2.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="TableComponentReturnVariable" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="076eb3bf-3e45-4383-aab2-41f7a7ab9677">
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="foodmart"/>
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<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/TableComponentReturnVariable_files/main_jrxml"/>
<property name="ireport.jasperserver.reportUnit" value="/EarthlySystems/TableComponentReturnVariable"/>
<style name="Table_TH" mode="Opaque" backcolor="#F0F8FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
<topPen lineWidth="0.5" lineColor="#000000"/>
<leftPen lineWidth="0.5" lineColor="#000000"/>
<bottomPen lineWidth="0.5" lineColor="#000000"/>
<rightPen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="Table_CH" mode="Opaque" backcolor="#BFE1FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
<topPen lineWidth="0.5" lineColor="#000000"/>
<leftPen lineWidth="0.5" lineColor="#000000"/>
<bottomPen lineWidth="0.5" lineColor="#000000"/>
<rightPen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="Table_TD" mode="Opaque" backcolor="#FFFFFF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
<topPen lineWidth="0.5" lineColor="#000000"/>
<leftPen lineWidth="0.5" lineColor="#000000"/>
<bottomPen lineWidth="0.5" lineColor="#000000"/>
<rightPen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<subDataset name="Dataset1" uuid="13c73a68-84f9-4afb-8d85-c363df55edd5">
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="foodmart"/>
<queryString language="SQL">
<![CDATA[SELECT * FROM product limit 10]]>
</queryString>
<field name="product_class_id" class="java.lang.Integer"/>
<field name="product_id" class="java.lang.Integer"/>
<field name="brand_name" class="java.lang.String"/>
<field name="product_name" class="java.lang.String"/>
<field name="sku" class="java.lang.Long"/>
<field name="srp" class="java.math.BigDecimal"/>
<field name="gross_weight" class="java.lang.Float"/>
<field name="net_weight" class="java.lang.Float"/>
<field name="recyclable_package" class="java.lang.Boolean"/>
<field name="low_fat" class="java.lang.Boolean"/>
<field name="units_per_case" class="java.lang.Integer"/>
<field name="cases_per_pallet" class="java.lang.Integer"/>
<field name="shelf_width" class="java.lang.Double"/>
<field name="shelf_height" class="java.lang.Double"/>
<field name="shelf_depth" class="java.lang.Double"/>
<variable name="tableVarShelfHeight" class="java.lang.Double" calculation="Average">
<variableExpression><![CDATA[$F{shelf_height}]]></variableExpression>
</variable>
<variable name="tableVarShelfDepth" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$F{shelf_depth}]]></variableExpression>
</variable>
</subDataset>
<queryString>
<![CDATA[select 1 as one]]>
</queryString>
<field name="one" class="java.lang.Integer"/>
<variable name="reportVarShelfHeight" class="java.lang.Double"/>
<variable name="reportVarShelfDepth" class="java.lang.Double"/>
<background>
<band splitType="Stretch"/>
</background>
<summary>
<band height="155" splitType="Stretch">
<componentElement>
<reportElement x="0" y="95" width="555" height="60" uuid="fb230941-894f-49b6-a5db-33fd14e143ca">
<property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/>
<property name="com.jaspersoft.studio.table.style.table_header" value="Table_TH"/>
<property name="com.jaspersoft.studio.table.style.column_header" value="Table_CH"/>
<property name="com.jaspersoft.studio.table.style.detail" value="Table_TD"/>
</reportElement>
<jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd">
<datasetRun subDataset="Dataset1" uuid="e267dc57-7f5a-496a-afbe-4c501f7641c0">
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<returnValue fromVariable="tableVarShelfHeight" toVariable="reportVarShelfHeight"/>
<returnValue fromVariable="tableVarShelfDepth" toVariable="reportVarShelfDepth"/>
</datasetRun>
<jr:column width="150" uuid="72c24377-f2d4-475b-a4e5-67e44a84e77e">
<property name="com.jaspersoft.studio.components.table.model.column.name" value="Column1"/>
<property name="com.jaspersoft.studio.unit.width" value="pixel"/>
<jr:columnHeader style="Table_CH" height="30">
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<staticText>
<reportElement x="0" y="0" width="150" height="30" uuid="8fc092e9-c4c6-4852-b9f9-f0ba87058672"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="12" isBold="true"/>
</textElement>
<text><![CDATA[Brand Name]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="Table_TD" height="30">
<textField>
<reportElement x="0" y="0" width="150" height="30" uuid="7b7ca06b-b091-49e4-88b3-2933d406b307"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{brand_name}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="160" uuid="c0ff827a-b508-4cb3-a56e-907dd5c6541b">
<property name="com.jaspersoft.studio.components.table.model.column.name" value="Column2"/>
<jr:columnHeader style="Table_CH" height="30">
<staticText>
<reportElement x="0" y="0" width="160" height="30" uuid="cfe5cfa6-a8c0-4e21-be9b-905f5a4c3b5f"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="12" isBold="true"/>
</textElement>
<text><![CDATA[Product Name]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="Table_TD" height="30">
<textField>
<reportElement x="0" y="0" width="160" height="30" uuid="79e67174-3f79-4bd2-9431-382caef06859"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{product_name}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="100" uuid="d181aa89-109e-4611-a88d-b02987b5f843">
<property name="com.jaspersoft.studio.components.table.model.column.name" value="Column3"/>
<jr:columnHeader style="Table_CH" height="30">
<staticText>
<reportElement x="0" y="0" width="100" height="30" uuid="eccf9427-0a77-42d2-843c-45240add3380"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="12" isBold="true"/>
</textElement>
<text><![CDATA[Shelf Height]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="Table_TD" height="30">
<textField>
<reportElement x="0" y="0" width="100" height="30" uuid="2bcee921-da1c-446b-b0d6-f7eabc9d1e09"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{shelf_height}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="145" uuid="bdaa807a-f7ad-4012-b785-2043e2f8b5ed">
<property name="com.jaspersoft.studio.components.table.model.column.name" value="Column4"/>
<jr:columnHeader style="Table_CH" height="30">
<staticText>
<reportElement x="0" y="0" width="145" height="30" uuid="b49b7a55-8b66-4008-9fa5-b8c7eef487c4"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="12" isBold="true"/>
</textElement>
<text><![CDATA[Shelf Depth]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="Table_TD" height="30">
<textField>
<reportElement x="0" y="0" width="145" height="30" uuid="eaf798a6-92db-4d2a-bae4-cbb0a3fc3df1"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{shelf_depth}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
</jr:table>
</componentElement>
<textField evaluationTime="Report">
<reportElement x="310" y="0" width="110" height="30" uuid="ae60e175-5e2b-41a9-97e4-e56d03e04879"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[$V{reportVarShelfHeight}]]></textFieldExpression>
</textField>
<textField evaluationTime="Report">
<reportElement x="420" y="0" width="135" height="30" uuid="1ddf8337-b8ed-4d7f-a8b6-b3254ef08f1e"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[$V{reportVarShelfDepth}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="310" y="30" width="110" height="30" uuid="3400a3c6-b92f-4191-9a0f-c9e4277f6789"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="12" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA["Avg Shelf Height"]]></textFieldExpression>
</textField>
<textField>
<reportElement x="420" y="30" width="135" height="30" uuid="effa8104-837d-4dc8-b08a-76645fed513c"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="12" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA["Total. Shelf Depth"]]></textFieldExpression>
</textField>
</band>
</summary>
</jasperReport>
April 21, 2018
April 17, 2018
Tip: Merge column header cells in Table component of Jasper reports
( JasperSoft BI Suite Tutorials - Sadakar Pochampalli )
Hi folks,
To merge the column headers in jasper reports table component, select the columns from "Column Header" section of "Table Outline" and right click on them and then click on "Group columns".
It would add empty space on top of existing column labels and now you can keep an additional text field on top of the grouped columns which would look like a merged cell.
The outline of grouped column will be as follows.
- Thank you for stopping by, hope it helps someone in community.
Until Next Post
- Sadakar Pochampalli
To merge the column headers in jasper reports table component, select the columns from "Column Header" section of "Table Outline" and right click on them and then click on "Group columns".
It would add empty space on top of existing column labels and now you can keep an additional text field on top of the grouped columns which would look like a merged cell.
The outline of grouped column will be as follows.
Sample
- Thank you for stopping by, hope it helps someone in community.
Until Next Post
- Sadakar Pochampalli
April 17, 2018
Horizontal bullet widget visualization example in Jasper reports 6.4.2 or later
( JasperSoft BI Suite Tutorials - Sadakar Pochampalli )
Hi folks,
In this page, you would see how to work with Horizontal bullet widget that should look like as shown in below sample output.
1) Bullet Value
2) Target Value
Using this visualization one can plot a value against a target having different ranges.
Sample query for this visualization is :
SELECT 47 AS value, 78 AS target FROM customer limit 1
In the widget properties provide these values as shown in below image.
For color range, provide min and max values as follows
yellow --> min=31 max=45
green --> min =46 max=85
blue --> min=86 max=100
To get the exact look and feel as shown in top of the post, play with Widget properties
For instance, below image would give an idea
Save your report and preview the visualization. This way, the desired output can be visualized in jasper reports using Horizontal bullet widget.
- Sadakar Pochampalli
JRXML (Supports from 6.4.2 professional jasper studio, database : "foodmart" db of postgres)
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.4.2.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="BulletChart" pageWidth="700" pageHeight="842" columnWidth="660" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="ce0d4c3e-a968-4446-bbf4-b5ee95e7a1d2">
<property name="com.jaspersoft.studio.unit." value="pixel"/>
<property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/>
<property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/>
<property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/>
<property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/>
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="foodmartlatha"/>
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<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/Horizontal_Bullet_Widget_Chart_files/main_jrxml"/>
<property name="ireport.jasperserver.reportUnit" value="/EarthlySystems/Horizontal_Bullet_Widget_Chart"/>
<queryString>
<![CDATA[SELECT 47 AS value, 78 AS target FROM customer limit 1]]>
</queryString>
<field name="value" class="java.lang.Integer"/>
<field name="target" class="java.lang.Integer"/>
<background>
<band splitType="Stretch"/>
</background>
<summary>
<band height="116" splitType="Stretch">
<componentElement>
<reportElement x="0" y="71" width="640" height="45" uuid="10f1d42b-9236-40d3-aee0-cd4ab0954674">
<property name="com.jaspersoft.studio.unit.height" value="pixel"/>
</reportElement>
<fw:horizontalBullet xmlns:fw="http://jaspersoft.com/fusion" xsi:schemaLocation="http://jaspersoft.com/fusion http://jaspersoft.com/schema/fusion.xsd">
<fw:widgetProperty name="showLimits">
<fw:propertyExpression><![CDATA[Boolean.FALSE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="showTickValues">
<fw:propertyExpression><![CDATA[Boolean.FALSE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="setAdaptiveMin">
<fw:propertyExpression><![CDATA[Boolean.FALSE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="showTickMarks">
<fw:propertyExpression><![CDATA[Boolean.FALSE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="showValue">
<fw:propertyExpression><![CDATA[Boolean.FALSE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="showShadow">
<fw:propertyExpression><![CDATA[Boolean.FALSE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="ticksOnRight">
<fw:propertyExpression><![CDATA[Boolean.FALSE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="animation">
<fw:propertyExpression><![CDATA[Boolean.FALSE]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="caption">
<fw:propertyExpression><![CDATA["rate of interest%"]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="subCaption">
<fw:propertyExpression><![CDATA["(avg interest)"]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="borderColor">
<fw:propertyExpression><![CDATA[new java.awt.Color(-1)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="paletteThemeColor">
<fw:propertyExpression><![CDATA[new java.awt.Color(-16777216)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="plotBorderColor">
<fw:propertyExpression><![CDATA[new java.awt.Color(-1)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="bgColor">
<fw:propertyExpression><![CDATA[new java.awt.Color(-1)]]></fw:propertyExpression>
</fw:widgetProperty>
<fw:widgetProperty name="baseFontColor">
<fw:propertyExpression><![CDATA[new java.awt.Color(-16777216)]]></fw:propertyExpression>
</fw:widgetProperty>
<dataset/>
<fw:valueExpression><![CDATA[new Double($F{value})]]></fw:valueExpression>
<fw:targetExpression><![CDATA[new Double($F{target})]]></fw:targetExpression>
<fw:colorRange color="#FF0000">
<fw:minValueExpression><![CDATA[0]]></fw:minValueExpression>
<fw:maxValueExpression><![CDATA[30]]></fw:maxValueExpression>
<fw:labelExpression><![CDATA["color1"]]></fw:labelExpression>
</fw:colorRange>
<fw:colorRange color="#FFFF00">
<fw:minValueExpression><![CDATA[31]]></fw:minValueExpression>
<fw:maxValueExpression><![CDATA[45]]></fw:maxValueExpression>
<fw:labelExpression><![CDATA["color2"]]></fw:labelExpression>
</fw:colorRange>
<fw:colorRange color="#008000">
<fw:minValueExpression><![CDATA[45]]></fw:minValueExpression>
<fw:maxValueExpression><![CDATA[85]]></fw:maxValueExpression>
<fw:labelExpression><![CDATA["color3"]]></fw:labelExpression>
</fw:colorRange>
<fw:colorRange color="#0000FF">
<fw:minValueExpression><![CDATA[86]]></fw:minValueExpression>
<fw:maxValueExpression><![CDATA[100]]></fw:maxValueExpression>
<fw:labelExpression><![CDATA["color4"]]></fw:labelExpression>
</fw:colorRange>
</fw:horizontalBullet>
</componentElement>
<textField>
<reportElement x="0" y="19" width="660" height="30" uuid="ec78046b-4fd5-4139-8ffe-1682459a7895"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="18" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA["Horizontal Bullet Widget Visualization Demo"]]></textFieldExpression>
</textField>
</band>
</summary>
</jasperReport>
April 17, 2018
Pages
About
Planet Jaspersoft aggregates blog posts from our community. If you would like your blog to be included in the Planet, please follow this help guide. Or just click this link to go straight to your Planet Feeds.
Feed Sources
- JasperSoft BI Suite Tutorials - Sadakar Pochampalli (156) Apply JasperSoft BI Suite Tutorials - Sadakar Pochampalli filter
- Jaspersoft Tutorials (50) Apply Jaspersoft Tutorials filter
- Technology Blog (50) Apply Technology Blog filter
- Jaspersoft Tech Talks (47) Apply Jaspersoft Tech Talks filter
- The Open Book on BI (26) Apply The Open Book on BI filter
- Bekwam Data as a Service (21) Apply Bekwam Data as a Service filter
- AgileTech - Ankur Gupta (19) Apply AgileTech - Ankur Gupta filter
- Ankur Gupta - Youtube (17) Apply Ankur Gupta - Youtube filter
- Digital Gene (15) Apply Digital Gene filter
- Rajesh Sirsikar (15) Apply Rajesh Sirsikar filter
- Tech Poet (13) Apply Tech Poet filter
- iTransparent - Jaspersoft Blog (9) Apply iTransparent - Jaspersoft Blog filter
- Paco Saucedo's blog » JasperReports (6) Apply Paco Saucedo's blog » JasperReports filter
- David Hoppmann's JasperServer Posts (2) Apply David Hoppmann's JasperServer Posts filter
- Jasper Related Posts from Wedjaa (1) Apply Jasper Related Posts from Wedjaa filter
- Kamal's YouTube videos (1) Apply Kamal's YouTube videos filter
