[Unable to configure Maps pro in jasper studio 6.2v]

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

 

[Tibco Maps configuration]

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]

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]

i want in 5.5 or 5.6.1

[collapse and expand functionality in Jasper Studio 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

[Run time queries in Jasper Studio reports]

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

[iReport : Table with Dataset ( Secondary datasource - SQL ) showing blank line when no data`]

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.

[why is iReport throwing me this error?]

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 OrderType
FROM ship
WHERE ship.id = $P{Parameter_name}

Thanks

B Rama Krishna

[how to make mandatory parameter field]

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]

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

[how to make mandatory parameter field]

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

[Greater than or equal to operators for date comparison in Jaspersoft Studio]

hi,

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

 

[How can i show values with percentage symbol, as display labels in column chart(HTML5)?]

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

[How do I code the "Timestamp Range" parameter class into the query?]

hi

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

[Can not find oracle jdbc drive for ireport]

hi

In tools -----> options -----> classpath  give the path of the driver and restart the ireport.

Thanks

B Rama Krishna

[How to create the the following:]

you can use crosstab and achieve that.

[How to pass a parameter from text field hyperlink?]

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

 

[Summary is not printing]

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

[html component will always cause publish error- invalid jrxml]

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

[How to make all scheduled jobs visible to all users, not just administrators?]

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.

[In email scheduled.- Charts image are not getting displayed]

The chart are HTML5 charts so you need to see in the browser so that you can see the charts.

[how to apply font size in coding while checking ternary operator condition]

hi Friend,

$P{product_name}==x?"<style isBold='true' font-size='10'>" + $P{product_name} + "</style>":"<style isBold='true' font-size='7'>" + $P{product_name} + "</style>"

Try this mostly it work . let me know if your facing any issues.

Thanks
B Rama Krishna

 

[Dynamic query - how to create?]

can you give me some more information.
Which query should execute when ?

[How to 'Remove Line When Blank' after evaluation?]

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

[adding Sub report in JasperSoft studio]

Hi Rajesh,

The functionality of JasperStudio and Ireport are different.
In jasper studio for the subreport configuration below are the steps,
The subreport report path
If any parameter need to pass from main to subreport then we need to map that paramters.

Thanks
B Rama Krishna