RamaKrishna.B
Members-
Posts
33 -
Joined
-
Last visited
RamaKrishna.B's Achievements
-
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]
-
changing color of header in crosstab by expression
RamaKrishna.B replied to skijop's topic in Products
Hi field.equalsIgnoreCase("B")? "<style forecolor='red'>"+field+"</style>: "<style forecolor='bule'>"+field1+"</style> Thanks B Rama krishna -
collapse and expand functionality in Jasper Studio 5.6.1
RamaKrishna.B replied to RamaKrishna.B's topic in Products
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
-
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
-
Errors compiling and parameter is not working
RamaKrishna.B replied to bmccorkle's topic in Products
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
-
How do I code the "Timestamp Range" parameter class into the query?
RamaKrishna.B replied to coltae's topic in Products
hi can you explain the issue in detail so that i can help you- 2 replies
-
- java
- parameters
-
(and 1 more)
Tagged with:
-
hi In tools -----> options -----> classpath give the path of the driver and restart the ireport. Thanks B Rama Krishna