Jump to content
We've recently updated our Privacy Statement, available here ×

Tibco Maps configuration


RamaKrishna.B

Recommended Posts

Hi Friends,

We have configured the tibco maps in japser studio 6.3v but we are unable to get the styles configuration on the map.

Please can any one tell me where we are missing...

Below is the .jrxml.

<?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.3.0.final using JasperReports Library version 6.3.0  --><!-- 2017-06-27T15:25:26 -->    <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="USPopulation" pageWidth="842" pageHeight="595"                  orientation="Landscape" whenNoDataType="AllSectionsNoDetail"                  columnWidth="802" leftMargin="20" rightMargin="20"                  topMargin="20" bottomMargin="20"                  uuid="5a04794b-ae8f-4816-9f64-9069e5c05261">        <property name="com.jaspersoft.studio.data.sql.tables" value=""/>        <property name="com.jaspersoft.studio.data.defaultdataadapter" value="New Data Adapter "/>        <property name="ireport.jasperserver.url" value="http://localhost:8081/jasperserver-pro/"/>        <property name="ireport.jasperserver.user" value="superuser|"/>        <property name="ireport.jasperserver.report.resource" value="/organizations/organization_1/BSG/TibcoMapso_files/main_jrxml"/>        <property name="ireport.jasperserver.reportUnit" value="/organizations/organization_1/BSG/TibcoMapso"/>        <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>            <![CDATA[select mc.name as state_name,                            cast (sum(mcr.value) as int) as population,                       case when mc.name='United Kingdom' then 55.3781                            when mc.name = 'United States' then 37.0902                            when mc.name = 'Canada' then 56.1304                            end as latitude,                       case when mc.name='United Kingdom' then 3.4360                            when mc.name = 'United States' then 95.7129                            when mc.name = 'Canada' then 106.3468                            end as longitude                       from                             account a join mi_country mc on a.country = mc.code                       join mi_charge_record mcr on mcr.account_number = a.account_number                      group by mc.name                      order by state_name]]>        </queryString>        <field name="STATE_NAME" class="java.lang.String"/>        <field name="POPULATION" class="java.lang.Integer"/>        <field name="LATITUDE" class="java.math.BigDecimal"/>        <field name="LONGITUDE" class="java.math.BigDecimal"/>        <summary>            <band height="554" splitType="Stretch">                <componentElement>                    <reportElement key="" x="0" y="0"                                    width="800" height="554"                                   uuid="a154086d-9a32-46e2-bafb-10fc689e17dc"/>                    <c:tibcoMap xmlns:c="http://jaspersoft.com/tibcomaps"                                xsi:schemaLocation="http://jaspersoft.com/tibcomaps http://jaspersoft.com/schema/tibcomaps.xsd">                        <c:mapData>                            <c:item>                                <c:itemProperty name="latitude" value="40.279941"/>                                <c:itemProperty name="longitude" value="-95.476303"/>                                <c:itemProperty name="zoom" value="4"/>                                <c:itemProperty name="layers.control" value="true"/>                                <c:itemProperty name="layerName" value="Map"/>                                <c:itemProperty name="pathsLayerName" value="States"/>                            </c:item>                        </c:mapData>                        <c:pathStyle>                            <c:item>                                <c:itemProperty name="name" value="Light"/>                                <c:itemProperty name="isPolygon" value="true"/>                                <c:itemProperty name="clickable" value="true"/>                                <c:itemProperty name="color" value="#099000"/>                                <c:itemProperty name="fillOpacity" value="0.25"/>                            </c:item>                            <c:item>                                <c:itemProperty name="name" value="Med"/>                                <c:itemProperty name="isPolygon" value="true"/>                                <c:itemProperty name="color" value="#FFCC00"/>                                <c:itemProperty name="clickable" value="true"/>                                <c:itemProperty name="fillOpacity" value="0.25"/>                            </c:item>                            <c:item>                                <c:itemProperty name="name" value="Dark"/>                                <c:itemProperty name="isPolygon" value="true"/>                                <c:itemProperty name="color" value="#FF0000"/>                                <c:itemProperty name="clickable" value="true"/>                                <c:itemProperty name="fillOpacity" value="0.25"/>                            </c:item>                        </c:pathStyle>                        <c:pathData>                            <dataset/>                            <c:item>                                <c:itemProperty name="latitude">                                    <valueExpression><![CDATA[$F{LATITUDE}]]></valueExpression>                                </c:itemProperty>                                <c:itemProperty name="name">                                    <valueExpression><![CDATA[$F{STATE_NAME}]]></valueExpression>                                </c:itemProperty>                                <c:itemProperty name="style">                                    <valueExpression><![CDATA[iF($F{POPULATION}< 17000, "Light",IF($F{POPULATION} < 20000, "Med","Dark"))]]></valueExpression>                                </c:itemProperty>                                <c:itemProperty name="longitude">                                    <valueExpression><![CDATA[$F{LONGITUDE}]]></valueExpression>                                </c:itemProperty>                            </c:item>                        </c:pathData>                    </c:tibcoMap>                </componentElement>            </band>        </summary>    </jasperReport>[/code]
Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...