Friday 23 January 2015

Easy way of Substracting,Adding Months or Days from parameter date in Jasper studio or iReport : Ex : Substracting 2 months from current date

This is re-blogging of Right outer join post in simple understanding.


This post avoid the complexity usage & guide you the simplest way.

Aim : 
1) Subtract 1 month or 2 months or 3 months and etc from current date or selected date.
2) Subtract1 day or 2 day or 3 day or etc from current date or selected date
3) First Day of last month, Last day of last month & 15 th day of last month
4) Number of days from the current date or selected date.
5) Other Date formats

Sample output:


Way of getting solution :

1) Very first thing is to import org.apache.commons.lang.time package by opening XML source.  You have to add this code after properties selection ( The first high lighted code )

2) Take a parameter called MyDate and it's type should of java.util.Date

3) Now do experiment with various methods that available from org.apache.commons.lang.time

4) For eg :  Subtracting 2 months from MyDate parameter 
  Lets say MyDate parameter default value new Date() [1/2/15/ 1:04 P.M]
Below expression in a text field gives you the the exact subtraction of 2 months

<textFieldExpression><![CDATA[DateUtils.addMonths($P{MyDate},-2)]]></textFieldExpression>


5) Copy the below code and paste in your jrxml and see the magic.

6) Now how to get the patterns of dates
Lets create another parameter  say PatternDate and in its default expression write below code...
The type of this parameter should be of java.lang.String
$P{PatternDate} = new SimpleDateFormat("MMM-yyyy").format($P{MyDate})

Place this parameter in Title section and check the pattern....

Or you can directly set pattern by going properties if you are printing dates in a Text field.

JRXML Code from Right outer join post :

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.0.0.final using JasperReports Library version 6.0.0  -->
<!-- 2015-01-23T18:37:08 -->
<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="Commons-Lang-Examples" pageWidth="595" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="9715a38f-ab05-4d3a-b5bd-8f55a035a9be">
    <property name="ireport.zoom" value="1.0"/>
    <property name="ireport.x" value="0"/>
    <property name="ireport.y" value="0"/>
    <property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/>
    <import value="org.apache.commons.lang.time.*"/>
    <parameter name="MyDate" class="java.util.Date">

        <defaultValueExpression><![CDATA[new Date()]]></defaultValueExpression>
    </parameter>
    <background>
        <band splitType="Stretch"/>
    </background>
    <title>
        <band height="439" splitType="Stretch">
            <textField>
                <reportElement x="0" y="40" width="255" height="20" uuid="165305e3-bb69-4c57-b028-ac0d9d765fff"/>
                <box rightPadding="20"/>
                <textElement textAlignment="Right"/>
                <textFieldExpression><![CDATA[$P{MyDate}]]></textFieldExpression>
            </textField>

            <textField>
                <reportElement x="255" y="40" width="300" height="20" uuid="ea63bc38-963e-4207-ac7a-8eacdd040cf3"/>
                <textFieldExpression><![CDATA["$" + "P{MyDate} (unmodified)"]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="255" y="60" width="300" height="20" uuid="7d856c36-27a3-4b10-a0ef-853ebfb19087"/>
                <textFieldExpression><![CDATA["$" + "P{MyDate} + 1 day"]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="0" y="60" width="255" height="20" uuid="15dd62fe-d3fd-45e2-8135-53884236ed7e"/>
                <box rightPadding="20"/>
                <textElement textAlignment="Right"/>
                <textFieldExpression><![CDATA[DateUtils.addDays($P{MyDate},1)]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="255" y="80" width="300" height="20" uuid="b508649e-09f4-428f-94e8-23f5a6afbff7"/>
                <textFieldExpression><![CDATA["$" + "P{MyDate} - 1 month"]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="0" y="80" width="255" height="20" uuid="92429a95-0c43-4a5e-b30b-0e9278a13c81"/>
                <box rightPadding="20"/>
                <textElement textAlignment="Right"/>
                <textFieldExpression><![CDATA[DateUtils.addMonths($P{MyDate},-2)]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="255" y="180" width="300" height="20" uuid="d72a3203-350e-4065-aaba-b63cbfafb57f"/>
                <textFieldExpression><![CDATA["Last day of previous month"]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="0" y="180" width="255" height="20" uuid="3bb732b3-0bac-42d5-8a06-e623942f78b8"/>
                <box rightPadding="20"/>
                <textElement textAlignment="Right"/>
                <textFieldExpression><![CDATA[DateUtils.addDays(
    DateUtils.truncate($P{MyDate},java.util.Calendar.MONTH),
    -1
)]]></textFieldExpression>

            </textField>
            <textField>
                <reportElement x="255" y="160" width="300" height="20" uuid="fa5f6972-53ff-4249-9721-ca72eda43993"/>
                <textFieldExpression><![CDATA["First day of previous month"]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="0" y="160" width="255" height="20" uuid="ede9293e-7d3e-449b-aef6-c53a6a2c6b7f"/>
                <box rightPadding="20"/>
                <textElement textAlignment="Right"/>
                <textFieldExpression><![CDATA[DateUtils.truncate(
    DateUtils.addMonths($P{MyDate},-1),
    java.util.Calendar.MONTH
)]]></textFieldExpression>

            </textField>
            <textField>
                <reportElement x="255" y="120" width="300" height="20" uuid="4279db76-2ba7-4f38-a14b-897c13041296"/>
                <textFieldExpression><![CDATA["$" + "P{MyDate} with time component removed"]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="0" y="120" width="255" height="20" uuid="0a6eb011-8bcd-4e55-a1e7-2b21327e37c8"/>
                <box rightPadding="20"/>
                <textElement textAlignment="Right"/>
                <textFieldExpression><![CDATA[DateUtils.truncate($P{MyDate},java.util.Calendar.DATE)]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="255" y="100" width="300" height="20" uuid="bbbaa2d6-b691-4c1c-b1ac-50ada10c1955"/>
                <textFieldExpression><![CDATA["$" + "P{MyDate} Rounded to the nearest hour"]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="0" y="100" width="255" height="20" uuid="f46cf21a-b4af-4c34-af62-eea466c810b8"/>
                <box rightPadding="20"/>
                <textElement textAlignment="Right"/>
                <textFieldExpression><![CDATA[DateUtils.round( $P{MyDate},java.util.Calendar.HOUR )]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="0" y="0" width="555" height="40" uuid="dc842c45-ae62-46c7-8309-3a69d46babb5"/>
                <textElement textAlignment="Center" verticalAlignment="Middle">
                    <font size="14" isBold="true"/>
                </textElement>
                <textFieldExpression><![CDATA["Useful date calculations with Java Commons Lang"]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="0" y="220" width="255" height="20" uuid="ddf5c047-cafd-4da8-94cd-61064e169fcf"/>
                <box rightPadding="20"/>
                <textElement textAlignment="Right"/>
                <textFieldExpression><![CDATA[new Long(
    DateUtils.getFragmentInDays( $P{MyDate},java.util.Calendar.YEAR )
)]]></textFieldExpression>

            </textField>
            <textField>
                <reportElement x="255" y="220" width="300" height="20" uuid="59d6413f-e146-4523-86df-e93e209c91c9"/>
                <textFieldExpression><![CDATA["Days since January 1"]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="0" y="200" width="255" height="20" uuid="74234013-db8b-4b74-a71a-fc70ea8c48b7"/>
                <box rightPadding="20"/>
                <textElement textAlignment="Right"/>
                <textFieldExpression><![CDATA[DateUtils.truncate(
    DateUtils.setDays( $P{MyDate}, 15 ),
    java.util.Calendar.DATE
)]]></textFieldExpression>

            </textField>
            <textField>
                <reportElement x="255" y="200" width="300" height="20" uuid="e93ed83f-a8a6-43d6-ab2f-5c4e77abcd17"/>
                <textFieldExpression><![CDATA["The fifteenth day of the month"]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="0" y="300" width="255" height="20" uuid="961aa26f-7ddc-427f-8edb-094252856ff9"/>
                <box rightPadding="20"/>
                <textElement textAlignment="Right"/>
                <textFieldExpression><![CDATA[DateFormatUtils.format(
    $P{MyDate},
    DateFormatUtils.ISO_DATE_FORMAT.getPattern()
)]]></textFieldExpression>

            </textField>
            <textField>
                <reportElement x="0" y="260" width="555" height="40" uuid="2101dfa6-2956-4685-8819-8e2f5570e8ac"/>
                <textElement textAlignment="Center" verticalAlignment="Middle">
                    <font size="14" isBold="true"/>
                </textElement>
                <textFieldExpression><![CDATA["Useful date formatting with Java Commons Lang"]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="255" y="300" width="300" height="20" uuid="8fa2ea6e-e989-409a-9933-b6cf0fca13c5"/>
                <textFieldExpression><![CDATA["$" + "P{MyDate} (unmodified) in ISO Date Format"]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="0" y="320" width="255" height="20" uuid="4c336368-d27b-48b3-b15a-532657f18294"/>
                <box rightPadding="20"/>
                <textElement textAlignment="Right"/>
                <textFieldExpression><![CDATA[DateFormatUtils.format(
    $P{MyDate},
    DateFormatUtils.ISO_TIME_FORMAT.getPattern()
)]]></textFieldExpression>

            </textField>
            <textField>
                <reportElement x="255" y="320" width="300" height="20" uuid="4e9c7a33-282d-4dc8-a409-18e0dc409d74"/>
                <textFieldExpression><![CDATA["$" + "P{MyDate} Time only in ISO8601 format no time zone"]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="0" y="340" width="255" height="20" uuid="5089020f-10d1-4c28-8e39-8c5ed8e4b5d8"/>
                <box rightPadding="20"/>
                <textElement textAlignment="Right"/>
                <textFieldExpression><![CDATA[DateFormatUtils.format(
    $P{MyDate},
    DateFormatUtils.ISO_TIME_TIME_ZONE_FORMAT.getPattern()
)]]></textFieldExpression>

            </textField>
            <textField>
                <reportElement x="255" y="340" width="300" height="20" uuid="d9f37168-1863-4f58-a809-f4d3267a31f8"/>
                <textFieldExpression><![CDATA["$" + "P{MyDate} Time only in ISO8601 format with time zone"]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="255" y="360" width="300" height="20" uuid="10768478-a19f-42c6-9e92-7d2de1a41baa"/>
                <textFieldExpression><![CDATA["$" + "P{MyDate} in New Zealand timezone"]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="0" y="360" width="255" height="20" uuid="e615cb87-2c1a-476a-b7b2-f57592590fdc"/>
                <box rightPadding="20"/>
                <textElement textAlignment="Right"/>
                <textFieldExpression><![CDATA[DateFormatUtils.format(
    $P{MyDate},
    DateFormatUtils.ISO_DATETIME_FORMAT.getPattern(),
    TimeZone.getTimeZone("Pacific/Auckland")
)]]></textFieldExpression>

            </textField>
        </band>
    </title>
    <pageHeader>
        <band splitType="Stretch"/>
    </pageHeader>
    <columnHeader>
        <band splitType="Stretch"/>
    </columnHeader>
    <detail>
        <band splitType="Stretch"/>
    </detail>
    <columnFooter>
        <band splitType="Stretch"/>
    </columnFooter>
    <pageFooter>
        <band splitType="Stretch"/>
    </pageFooter>
    <lastPageFooter>
        <band height="60">
            <textField>
                <reportElement x="0" y="0" width="555" height="20" uuid="1c56c313-3e0b-47d4-a7f0-86556ebeeb92"/>
                <textElement textAlignment="Center"/>
                <textFieldExpression><![CDATA["Sample report created by Matt Dahlman to show the use of Java Commons Lang date functions in JasperReports"]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="0" y="20" width="255" height="40" uuid="3c27ca9b-3a71-4397-9b8b-f5c2890667f9"/>
                <box rightPadding="20"/>
                <textElement textAlignment="Right"/>
                <textFieldExpression><![CDATA["version:\n"
+ "last modified:"]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="255" y="20" width="300" height="40" uuid="8140f760-5be7-4fc8-a2a7-0c50ff057b4e"/>
                <textFieldExpression><![CDATA["0.1\n"
+ "9 Sept 2009"]]></textFieldExpression>
            </textField>
        </band>
    </lastPageFooter>
</jasperReport>

References :
1)   https://mdahlman.wordpress.com/2009/09/09/jasperreports-first-dates/

Fusion Bar chart label rotation in Jasper Studio 6.x - Setting advanced properties for fustion charts

This post will give you the idea on how to set Advanced properties for fusion bar chart label rotation with 45 degrees.

There are two ways to set Advanced properties for Charts Pro ( for eg : in this post I'm showing for fusion bar chart).

1. setting properties from Advanced Properties button and then giving property name & value.
2. Writing lines of code in XML source.

Way 1 :
1st way is not working in Jasper Studio 6.x . i.e., you can not see the properties when give advanced properties with version 6.0.0 pro final but as quick as you click ok button once you set them you can find in the code.
1) Right click on charts
2) Go to Advanced properties
3) Give property name & value

Property Name : labelDisplay
Property Value : "Rotate"

4) In the same way give another property

Property Name : slantLabels
Property Value : new Integer(1)



Way 2 :

1) Click on XML source button. 
2) Find where the chart code is .. i.e., tags starting with <fc:chart xmlns:fc="http://jaspersoft.com/fusion" ...........
3) Write below code between the start tag and end tag of fusion chart.
  
<fc:chart xmlns:fc="http://jaspersoft.com/fusion" xsi:schemaLocation="http://jaspersoft.com/fusion http://jaspersoft.com/schema/fusion.xsd" type="Column3D" evaluationTime="Report">

-------------
-------------  Lines of other properties
-------------
                    <fc:chartProperty name="labelDisplay">
                             <fc:propertyExpression><![CDATA["Rotate"]]></fc:propertyExpression>
                    </fc:chartProperty>


                    <fc:chartProperty name="slantLabels">
                           <fc:propertyExpression><![CDATA[new Integer(1)]]></fc:propertyExpression>
                    </fc:chartProperty>


---------------
---------------    Lines of other properties
---------------

    </fc:chart>

Sample output :


I hope this tip will help you :-)

References :

Sadakar
BI Developer
 

Default Value Expression for Collection Type parameter in Jasper Studio 6.x

Below expression set the default values for a Collection type parameter

For Eg : Lets create a parameter called paramMyStrings which is a Collection type.

$X{IN,<fieldName>,<paramName>} is the parameter and its type is : java.util.Collection

Default value expression for this parameter could be as follows

new ArrayList(Arrays.asList(new String[] {"String1","String2","String3","String4"}))


:-)

Tip : Adding trend Lines to Fusion Charts in Jasper Studio 6.x ( Adding average trend line in jasper studio to a bar chart)

This post will give you the starting point of working with trend lines in jasper studio .

Adding trend Lines to Fusion Charts in Jasper Studio 6.x  ( Adding average trend line in jasper studio to a bar chart)

Software Setup : Jasper Studio Pro 6.x, Jasper Server 6.x Pro, foodmart db.

Sample Data : 

OUTPUT image : 



Steps : 
1) Create a variable and calculate Avg as shown in below image.




2) Give this variable( it should be of integer type though your field may output BigDecimal values) for Start Value Expression & End Value Expression as shown image.

                           

NOTES : 
Can we find moving average trend lines in jasper ? NO.

References : 
1) How to add advanced properties :
http://community.jaspersoft.com/wiki/how-wrap-labels-pie-chart-pro

2) Customization properties
http://docs.fusioncharts.com/flex/charts/Contents/xml_elements_trend.html

3) http://en.wikipedia.org/wiki/Linear_regression

Thursday 22 January 2015

Tip : HTML-5 Pie chart long label wrapping in Jasper Studio 6.x & Jasper Server 6.x (OR) HighCharts pie multi line labels

This small post will give you the tip of  label wrapping for HTML-5 pie chart in Jasper Studio 6.x (as well in Jasper 6.x server)version.

I'd like to show you the problem first , how it look when there are long categories(or labels) and then will show you how to make them wrap or splitting into multiple lines. 

A sample Data : 

Problem Statement : 

OUTPUT image : How we want it ?
How to get above functionality ? Solution :

1) Right Click on the chart -> Click on Edit Chart Properties
2) Click on Advanced Properties button 
3) Click on Add button add below property : Giving Label size 

4) Property name : plotOptions.pie.dataLabels.style.width    
    Property Value : 130

From Highcharts documentation ; 
style: CSSObject
Styles for the label. Defaults to {"color": "#606060", "fontSize": "11px"}.
    


5) Property Name : plotOptions.pie.dataLabels.x
    Property Value : 3
    
From Highcharts documentation ; 
x: Number
The x position offset of the label relative to the point. Defaults to 0.




What you can find in upcoming posts ?
Applying more advanced properties to get better look & feel as well other functionalities. 

I hope this post & reference links give starting point on exploring more & more on advanced properties starting with html-5 chart in Jasper desktop reporting. 

References :


Sadakar Pochampalli
BI developer 

Wednesday 14 January 2015

Tip : Intra charts/components linking technique in Jasper reports : HTML5 charts inter linking with in report in Jasper Studio 6.x

Happy new year...!!! - 2015

This post will give you the technique of inter relating components with in a report.
Software setup : Jasper Studio 6.x, Jasper Server 6.x, postgresql foodmart database.

Scenario :  2 charts in a report one is of pie chart and another is of bar chart.
Click on pie slice then the entire bar chart get reflected


JRXML File : 


<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.0.0.final using JasperReports Library version 6.0.0  -->
<!-- 2015-01-14T17:25:52 -->
<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="1_Chart1" pageWidth="1000" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="960" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="6f3a2ac6-912f-47e4-8ea9-b3d9c12fcc34">
    <property name="com.jaspersoft.studio.unit." value="pixel"/>
    <property name="ireport.jasperserver.url" value="http://localhost:8080/jasperserver-pro/"/>
    <property name="ireport.jasperserver.user" value="jasperadmin|"/>
    <property name="ireport.jasperserver.report.resource" value="/Test/1_Chart1_files/main_jrxml"/>
    <property name="ireport.jasperserver.reportUnit" value="/Test/1_Chart1"/>
    <property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/>
    <subDataset name="1_PieChart" uuid="79b56dcb-e731-4827-a1a3-1146339fe3f0">
        <property name="com.jaspersoft.studio.data.defaultdataadapter" value="foodmart"/>
        <parameter name="State" class="java.lang.String"/>
        <queryString>
            <![CDATA[SELECT
    c.state_province AS State,
    SUM(sf7.store_sales) StoreSales
FROM customer c
INNER JOIN sales_fact_1997 sf7 ON c.customer_id=sf7.customer_id
GROUP BY State]]>
        </queryString>
        <field name="state" class="java.lang.String"/>
        <field name="storesales" class="java.math.BigDecimal"/>
    </subDataset>
    <subDataset name="2_BarChart" uuid="0572b94e-1093-4dd6-b0e8-07508eef6e37">
        <property name="com.jaspersoft.studio.data.defaultdataadapter" value="foodmart"/>
        <parameter name="State" class="java.lang.String"/>
        <queryString language="SQL">
            <![CDATA[SELECT
    c.city AS city,
    SUM(sf7.store_sales) StoreSales
FROM customer c
INNER JOIN sales_fact_1997 sf7 ON c.customer_id=sf7.customer_id
WHERE c.state_province like  $P{State}
GROUP BY city limit 7]]>

        </queryString>
        <field name="city" class="java.lang.String"/>
        <field name="storesales" class="java.math.BigDecimal"/>
    </subDataset>
    <parameter name="State" class="java.lang.String" isForPrompting="false"/>
    <queryString>
        <![CDATA[]]>
    </queryString>
    <background>
        <band splitType="Stretch"/>
    </background>
    <title>
        <band height="37" splitType="Stretch"/>
    </title>
    <summary>
        <band height="313" splitType="Stretch">
            <componentElement>
                <reportElement x="0" y="0" width="380" height="313" uuid="6b65c0f7-e948-4d49-953c-309ba7f99d8c"/>
                <hc:chart xmlns:hc="http://jaspersoft.com/highcharts" xsi:schemaLocation="http://jaspersoft.com/highcharts http://jaspersoft.com/schema/highcharts.xsd" type="Pie">
                    <hc:chartSetting name="default">
                        <hc:chartProperty name="chart.borderColor">
                            <hc:propertyExpression><![CDATA[new java.awt.Color(-1)]]></hc:propertyExpression>
                        </hc:chartProperty>
                        <hc:chartProperty name="chart.plotBorderColor">
                            <hc:propertyExpression><![CDATA[new java.awt.Color(-1)]]></hc:propertyExpression>
                        </hc:chartProperty>
                        <hc:chartProperty name="chart.plotBorderWidth">
                            <hc:propertyExpression><![CDATA[new Integer(1)]]></hc:propertyExpression>
                        </hc:chartProperty>
                        <hc:chartProperty name="chart.zoomType">
                            <hc:propertyExpression><![CDATA["xy"]]></hc:propertyExpression>
                        </hc:chartProperty>
                        <hc:chartProperty name="credits.enabled">
                            <hc:propertyExpression><![CDATA[false]]></hc:propertyExpression>
                        </hc:chartProperty>
                        <hc:chartProperty name="credits.href">
                            <hc:propertyExpression><![CDATA[""]]></hc:propertyExpression>
                        </hc:chartProperty>
                        <hc:chartProperty name="credits.text">
                            <hc:propertyExpression><![CDATA[""]]></hc:propertyExpression>
                        </hc:chartProperty>
                        <hc:chartProperty name="plotOptions.pie.showInLegend" value="true"/>
                        <hc:chartProperty name="title.text">
                            <hc:propertyExpression><![CDATA[""]]></hc:propertyExpression>
                        </hc:chartProperty>
                        <hc:chartProperty name="tooltip.borderColor">
                            <hc:propertyExpression><![CDATA[new java.awt.Color(-15462127)]]></hc:propertyExpression>
                        </hc:chartProperty>
                        <hc:chartProperty name="tooltip.borderWidth">
                            <hc:propertyExpression><![CDATA[new Integer(1)]]></hc:propertyExpression>
                        </hc:chartProperty>
                        <hc:chartProperty name="yAxis.title.text">
                            <hc:propertyExpression><![CDATA[""]]></hc:propertyExpression>
                        </hc:chartProperty>
                    </hc:chartSetting>
                    <multiAxisData>
                        <multiAxisDataset>
                            <dataset>
                                <datasetRun subDataset="1_PieChart" uuid="04425503-33fc-4874-8eb6-893cf3afd8d9"/>
                            </dataset>
                        </multiAxisDataset>
                        <dataAxis axis="Rows">
                            <axisLevel name="Level1">
                                <labelExpression><![CDATA["Level Label expression"]]></labelExpression>
                                <axisLevelBucket class="java.lang.String">
                                    <bucketExpression><![CDATA[$F{state}]]></bucketExpression>
                                    <bucketProperty name="State"><![CDATA[$F{state}]]></bucketProperty>
                                    <bucketProperty name="url"><![CDATA["/Test/1_Chart1"]]></bucketProperty>
                                </axisLevelBucket>
                            </axisLevel>
                        </dataAxis>
                        <multiAxisMeasure name="Measure1" class="java.math.BigDecimal" calculation="Nothing">
                            <labelExpression><![CDATA["Measure label expression"]]></labelExpression>
                            <valueExpression><![CDATA[$F{storesales}]]></valueExpression>
                        </multiAxisMeasure>
                    </multiAxisData>
                    <hc:series name="Measure1">
                        <hc:contributor name="SeriesItemHyperlink">
                            <hc:contributorProperty name="hyperlinkTarget" valueType="Constant" value="Self"/>
                            <hc:contributorProperty name="hyperlinkType" valueType="Constant" value="ReportExecution"/>
                            <hc:contributorProperty name="_report" valueType="Bucket" value="Level1.url"/>
                            <hc:contributorProperty name="State" valueType="Bucket" value="Level1.State"/>
                        </hc:contributor>

                    </hc:series>
                </hc:chart>
            </componentElement>
            <componentElement>
                <reportElement x="420" y="0" width="540" height="313" uuid="003a4ecc-845a-45ee-8d42-21dbad8e87b4"/>
                <hc:chart xmlns:hc="http://jaspersoft.com/highcharts" xsi:schemaLocation="http://jaspersoft.com/highcharts http://jaspersoft.com/schema/highcharts.xsd" type="Column">
                    <hc:chartSetting name="default">
                        <hc:chartProperty name="chart.plotBorderColor">
                            <hc:propertyExpression><![CDATA[new java.awt.Color(-1)]]></hc:propertyExpression>
                        </hc:chartProperty>
                        <hc:chartProperty name="chart.plotBorderWidth">
                            <hc:propertyExpression><![CDATA[new Integer(1)]]></hc:propertyExpression>
                        </hc:chartProperty>
                        <hc:chartProperty name="chart.zoomType">
                            <hc:propertyExpression><![CDATA["xy"]]></hc:propertyExpression>
                        </hc:chartProperty>
                        <hc:chartProperty name="credits.enabled">
                            <hc:propertyExpression><![CDATA[false]]></hc:propertyExpression>
                        </hc:chartProperty>
                        <hc:chartProperty name="credits.href">
                            <hc:propertyExpression><![CDATA[""]]></hc:propertyExpression>
                        </hc:chartProperty>
                        <hc:chartProperty name="credits.text">
                            <hc:propertyExpression><![CDATA[""]]></hc:propertyExpression>
                        </hc:chartProperty>
                        <hc:chartProperty name="title.text">
                            <hc:propertyExpression><![CDATA[""]]></hc:propertyExpression>
                        </hc:chartProperty>
                        <hc:chartProperty name="yAxis.title.text">
                            <hc:propertyExpression><![CDATA[""]]></hc:propertyExpression>
                        </hc:chartProperty>
                    </hc:chartSetting>
                    <multiAxisData>
                        <multiAxisDataset>
                            <dataset>
                                <datasetRun subDataset="2_BarChart" uuid="f06690e2-a972-4556-a2ee-9881e880400a">
                                    <datasetParameter name="State">
                                        <datasetParameterExpression><![CDATA[$P{State}]]></datasetParameterExpression>
                                    </datasetParameter>
                                </datasetRun>
                            </dataset>
                        </multiAxisDataset>
                        <dataAxis axis="Rows">
                            <axisLevel name="Level1">
                                <labelExpression><![CDATA["Level Label expression"]]></labelExpression>
                                <axisLevelBucket class="java.lang.String">
                                    <bucketExpression><![CDATA[$F{city}]]></bucketExpression>
                                    <bucketProperty name="State"><![CDATA[$P{State}]]></bucketProperty>
                                    <bucketProperty name="url"><![CDATA["/Test/1_Chart1"]]></bucketProperty>
                                </axisLevelBucket>
                            </axisLevel>
                        </dataAxis>
                        <dataAxis axis="Columns"/>
                        <multiAxisMeasure name="Measure1" class="java.math.BigDecimal" calculation="Nothing">
                            <labelExpression><![CDATA["Cities"]]></labelExpression>
                            <valueExpression><![CDATA[$F{storesales}]]></valueExpression>
                        </multiAxisMeasure>
                    </multiAxisData>
                    <hc:series name="Measure1"/>
                </hc:chart>
            </componentElement>
        </band>
    </summary>
</jasperReport>


Output :
Image 1 :  Perform Click on OR state
 Image 2:  Perform Click on CA State
Image 3 : Perform Click on WA state


Core part : 
1) Right click pie chart -> Go to Chart Data -> Then to Configuration.
2) In category levels  double click on Level1 to open its bucket information & properties.
3) In bucket properties you need to give 2 parameters. one is State parameter(create it with String type) and url (the path of the same report)parameter as shown in below image

State = $F{state}
url = "/Test/1_chart1"



4) Go to value section ( talking about core part ) go to Advanced properties and configure below things one by one.
   hyperlinkTarget[SeriesItemHyperlink]
   hyperlinkType[SeriesItemHyperlink]
_report[SeriesItemHyperlink]
State[SeriesItemHyperlink]


Image is shown below
   hyperlinkTarget[SeriesItemHyperlink]








   hyperlinkType[SeriesItemHyperlink]

 _report[SeriesItemHyperlink]


 State[SeriesItemHyperlink]
                                                


Thanks for referring this post, hope it might helpful to some one :-)

Limitations/Notes :
1) Currently we can hyperlink target is Self  hence the entire report get refreshes with the passed parameter
2) Earlier in 5.5 Jasper Server we had content_frames to link to reports on legacy dashboard designer.
3) Point 2 can be achievable in 6.x Jaspersoft in Embedding BI using visualize.js scripting. 


Cheers..!!!