RamaKrishna.B
Members-
Posts
33 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Everything posted by 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]
-
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 -
Title: Issue while creating datasource with bigger password (encrypted).
RamaKrishna.B commented on Swapnil Pawar's entry in FAQs
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 -
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
-
you can use crosstab and achieve that.
-
How to pass a parameter from text field hyperlink?
RamaKrishna.B replied to jlongoria's topic in Products
Hi Hyperlinks on the text field can be done using below steps, LinkTarget : Self Link type : Report Execution Parameters : _report ----- 2nd report path in the server parameter_name ----- field _value (which value you want to pass to the 2nd report) the parameter_name in the main report should match with parameter_name in the 2nd report. if you need any further information let me know.Mostly it should work by using above steps. Thanks B Rama Krishna- 2 replies
-
- parameters
- hyperlink
-
(and 1 more)
Tagged with:
-
Right click on the report name in the Report Inspector and then got to properties. Check the option with "Summary with Page Header and Footer". If the issue is not resolved . can you please attach the .jrxml , so that i can give my suggestions. Thanks B Rama Krishna
- 1 reply
-
- table component
- ireport 5.6
-
(and 1 more)
Tagged with:
-
html component will always cause publish error- invalid jrxml
RamaKrishna.B replied to wangmin2001's topic in Products
same issue we are facing.We have replaced the "com.jaspersoft.studio.html_6.1.0.final.jar" jar file in the Jasper Server (C:Jaspersoftjasperreports-server-6.1.0apache-tomcatwebappsjasperserver-proWEB-INFlib) folder and restarted the server. Can you please tell me further we need to do any thing more for this isue- 3 replies
-
- jasperreports server
- jaspersoft studio
- (and 3 more)
-
i am don't know about the Japser Server 5.6 but in Jasperserver 5.6.1 normal user can schedule the reports. can once check that once.
- 4 replies
-
- permissions
- roles
-
(and 3 more)
Tagged with:
-
In email scheduled.- Charts image are not getting displayed
RamaKrishna.B replied to sebtain's topic in Products
The chart are HTML5 charts so you need to see in the browser so that you can see the charts. -
can you give me some more information. Which query should execute when ?
-
How to 'Remove Line When Blank' after evaluation?
RamaKrishna.B replied to linden's topic in Products
Select the text field and go to properties in that go to Appearance tab in that u can see "Remove Line When Blank" check box check that check box. Thanks B Ram krishna