RamaKrishna.B Posted June 27, 2017 Share Posted June 27, 2017 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now