RamaKrishna.B

hi We are using maps pro component in the jasper studio 6.2v . Requirement is we have country and its revenue trying show that on the that. On editing that component - Map data we aill give $F{sales_country}=="USA" ? '23' : ( $F{sales_country}=="Mexico" ? '16' : '05'). In the above expression why they are giving USA = 23 AND Mexico = 16. Please guys can any one explain me. Thanks Rama Krishna

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]

Hi field.equalsIgnoreCase("B")? "<style forecolor='red'>"+field+"</style>: "<style forecolor='bule'>"+field1+"</style> Thanks B Rama krishna

hi use the below link you can solve the isuue http://stackoverflow.com/questions/10722908/how-to-erase-rows-in-a-table-if-an-expression-is-valid-in-ireport Thanks Rama Krishna

i want in 5.5 or 5.6.1

Hi Team, I want to achieve the collapse and expand functionality in the Studio can you please help me out in this issue. Thanks B Rama Krishna

hi, We need to use parameter as below when we are using like operator in the query select * from parts where bin like '%' ||$P{Location Desired} || '%' Thanks B Rama Krishna

hi Using the print when expression for the titile band or for the text field in that band you can restrict the that band or text field Mostly Remove Line When Blank = true option will work. Can you try to check your report design.

In your query designer thier is some error . First directly pass the parameter value in the query and check the report. if it works then pass the parmeter to the query as below SELECT ship.id AS ShipID, ship.orderid AS OrderID, ship.ordertypeid AS OrderTypeFROM shipWHERE ship.id = $P{Parameter_name} Thanks B Rama Krishna

hi I don't know about the JDA WM. After deploying the report into Jasperserver. go to the report path in the Server and click on the edit button after that on the left side of that page you can see the control & resources ,click on that. If your report has the parameters then you can see the paramters on the control & resources page. Thanks B Rama Krishna

hi In the source code of the report you can see language="groovy" remove that and deploy the report it will work. Thanks B Rama Krishna

hi you want the parameter to be mandatory while executing the report in the Jasper Server ? if yes then it is the built-in functionality in the server When you edit the report in the server you have controls & resource in that you can see an option Always Prompt check box.Default it is checked(Mandatory) Thanks B Rama Krishna

hi, what is the data type of $F{Event_Scheduled_Date} ?

hi Right click on the report properties and then got to Tooltip in that you can see a option value Suffix in that you can give %. Thanks B Rama Krishna

hi can you explain the issue in detail so that i can help you