Jump to content
We've recently updated our Privacy Statement, available here ×

kharmel

Members
  • Posts

    2
  • Joined

  • Last visited

kharmel's Achievements

Newbie

Newbie (1/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Conversation Starter Rare

Recent Badges

0

Reputation

  1. Here is my JRXML. To recap, in 5.6, the legend shows only the first line of the X-Axis value. In 6.2.1, the entire X-axis value is displayed. <?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.2.1.final using JasperReports Library version 6.2.1 --><!-- 2016-07-20T23:32:06 --><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="JDRFCAYearlyOpportunityActionsPanel" language="groovy" pageWidth="400" pageHeight="260" orientation="Landscape" columnWidth="400" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="3e314457-b924-43f0-add5-e3f71a0dd579"><property name="com.jaspersoft.studio.data.defaultdataadapter" value="JDRFCA Test"/><property name="ireport.jasperserver.url" value="http://softrek-jrs01.softrek.com/jasperserver-pro/"/><property name="ireport.jasperserver.report.resource" value="/organizations/pmoljdrfcat/Panels/JDRFCACEActionsYTDPanel_files/main_jrxml"/><property name="ireport.jasperserver.reportUnit" value="/organizations/pmoljdrfcat/Panels/JDRFCACEActionsYTDPanel"/><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"/><property name="com.jaspersoft.jasperreports.highcharts.interactive" value="false"/><property name="ireport.jasperserver.user" value="superuser"/><subDataset name="ACTIONS" uuid="0ac6b730-0fab-496a-a896-d87b9136a231"><property name="com.jaspersoft.studio.data.defaultdataadapter" value="JDRFCA Test"/><parameter name="P_OPPTYP_COLLECTION" class="java.util.Collection"><defaultValueExpression><![CDATA[Arrays.asList("CE".split(","))]]></defaultValueExpression></parameter><parameter name="P_UNIT_SQL" class="java.lang.String" isForPrompting="false"/><parameter name="P_OPPTYP_NULL_SQL" class="java.lang.String"><parameterDescription><![CDATA[]]></parameterDescription></parameter><parameter name="P_UNIT_CONVERTED" class="java.lang.String" isForPrompting="false"/><parameter name="P_YEAR" class="java.lang.Integer"/><parameter name="P_UNIT_ID" class="java.lang.Integer"/><parameter name="P_ROLLUP" class="java.lang.Boolean"/><parameter name="P_REPORT_TYPE_SQL" class="java.lang.String"/><parameter name="P_STAGE_SQL" class="java.lang.String"/><parameter name="P_OPPTYP_NULL_YTD_SQL" class="java.lang.String"><parameterDescription><![CDATA[]]></parameterDescription><defaultValueExpression><![CDATA[$P{P_OPPTYP_COLLECTION}.contains("-99")?" or t.opportunity_type is null) ":" and 1=1) "]]></defaultValueExpression></parameter><parameter name="P_REPORT_TYPE" class="java.lang.String"><defaultValueExpression><![CDATA["B"]]></defaultValueExpression></parameter><parameter name="P_CE_STAGE_SQL_1" class="java.lang.String"><parameterDescription><![CDATA[]]></parameterDescription><defaultValueExpression><![CDATA[$P{P_OPPTYP_COLLECTION}.contains("CE")? "UNION ALL (select a.description , c.actioncode, trunc(c.actiondate), cst.description , c.transnum, c.idnumber, '', '','', to_number(null), c.timestamp from prospect pr, contact c, status cst, actions a where c.statuscode=cst.code(+) and c.actioncode=a.code(+) and c.idnumber = pr.idnumber and to_char(c.timestamp,'YYYY')= ":""]]></defaultValueExpression></parameter><parameter name="P_CE_STAGE_SQL_2" class="java.lang.String"><parameterDescription><![CDATA[]]></parameterDescription><defaultValueExpression><![CDATA[$P{P_OPPTYP_COLLECTION}.contains("CE")? " and c.appealcode=CE' and c.proposalnumber is null )":"]]></defaultValueExpression></parameter><parameter name="P_CE_STAGE_YEAR" class="java.lang.String"><parameterDescription><![CDATA[]]></parameterDescription><defaultValueExpression><![CDATA[$P{P_OPPTYP_COLLECTION}.contains("CE")? $P{P_YEAR}.toString():""]]></defaultValueExpression></parameter><parameter name="P_CE_STAGE_REPORT_TYPE_SQL" class="java.lang.String"><parameterDescription><![CDATA[]]></parameterDescription><defaultValueExpression><![CDATA[$P{P_OPPTYP_COLLECTION}.contains("CE")? $P{P_REPORT_TYPE_SQL}:""]]></defaultValueExpression></parameter><parameter name="P_CE_STAGE_UNIT_CONVERTED" class="java.lang.String"><parameterDescription><![CDATA[]]></parameterDescription><defaultValueExpression><![CDATA[$P{P_OPPTYP_COLLECTION}.contains("CE")? $P{P_UNIT_CONVERTED}:""]]></defaultValueExpression></parameter><parameter name="P_CE_STAGE_DONOR_COUNT_SQL" class="java.lang.String"><parameterDescription><![CDATA[]]></parameterDescription><defaultValueExpression><![CDATA[$P{P_OPPTYP_COLLECTION}.contains("CE")? "(select nvl(count(distinct c.idnumber),0) from prospect pr, contact c where c.idnumber = pr.idnumber and c.appealcode=CE' and c.proposalnumber is null and to_char(c.timestamp,'YYYY')= ":"(Select 0 from dual ]]></defaultValueExpression></parameter><parameter name="P_CE_STAGE_ACTION_COUNT_SQL" class="java.lang.String"><parameterDescription><![CDATA[]]></parameterDescription><defaultValueExpression><![CDATA[$P{P_OPPTYP_COLLECTION}.contains("CE")? "(select nvl(count(distinct c.transnum),0) from prospect pr, contact c where c.idnumber = pr.idnumber and c.appealcode=CE' and c.proposalnumber is null and to_char(c.timestamp,'YYYY')= ":"(Select 0 from dual ]]></defaultValueExpression></parameter><queryString language="SQL"><![CDATA[select action_stage_description, ((select nvl(count(distinct tr.idnumber),0) from tracking tr, status s, user_codes uc, prospect pr, contact c where tr.idnumber = pr.idnumber and tr.idnumber=c.idnumber and tr.proposalnumber=c.proposalnumber and tr.status = s.code(+) and s.type=uc.code(+) and nvl(uc.code_table,'STATUS.TYPE')='STATUS.TYPE' and s.type between 0 and 7 $P!{P_REPORT_TYPE_SQL} and ($X{IN,tr.opportunity_type,P_OPPTYP_COLLECTION} $P!{P_OPPTYP_NULL_SQL} and extract(year from tr.timestamp)= $P!{P_YEAR} $P!{P_UNIT_CONVERTED} )+ $P!{P_CE_STAGE_DONOR_COUNT_SQL} $P!{P_CE_STAGE_YEAR} $P!{P_CE_STAGE_UNIT_CONVERTED} $P!{P_CE_STAGE_REPORT_TYPE_SQL} )) as ytd_count_donors, ((select nvl(count(distinct c.transnum),0) from tracking tr, status s, user_codes uc, prospect pr, contact c where tr.idnumber = pr.idnumber and tr.idnumber=c.idnumber and tr.proposalnumber=c.proposalnumber and tr.status = s.code(+) and s.type=uc.code(+) and nvl(uc.code_table,'STATUS.TYPE')='STATUS.TYPE' and s.type between 0 and 7 $P!{P_REPORT_TYPE_SQL} and ($X{IN,tr.opportunity_type,P_OPPTYP_COLLECTION} $P!{P_OPPTYP_NULL_SQL} and extract(year from tr.timestamp)= $P!{P_YEAR} $P!{P_UNIT_CONVERTED} ) + $P!{P_CE_STAGE_ACTION_COUNT_SQL} $P!{P_CE_STAGE_YEAR} $P!{P_CE_STAGE_UNIT_CONVERTED} $P!{P_CE_STAGE_REPORT_TYPE_SQL} )) as ytd_count_actions, nvl(count(distinct idnumber),0) as count_donors, nvl(count(distinct case when actiondate is null then idnumber else to_number(null) end),0) as count_open_action_donors, nvl(count(distinct case when actiondate is not null then idnumber else to_number(null) end),0) as count_closed_action_donors, nvl(count(distinct transnum),0) as count_actions, nvl(count(distinct case when actiondate is null then transnum else to_number(null) end),0) as count_open_actions, nvl(count(distinct case when actiondate is not null then transnum else to_number(null) end),0) as count_closed_actions from ( ( select a.description as action, c.actioncode, trunc(c.actiondate) as actiondate, cst.description as action_stage_description, c.transnum, c.idnumber, tr.status as status_code, st.description as status_description, st.type as status_type, tr.proposalnumber, tr.timestamp as oppty_timestamp from tracking tr, status st, prospect pr, user_codes sd, contact c, status cst, actions a where tr.idnumber=c.idnumber and tr.proposalnumber=c.proposalnumber and c.statuscode=cst.code(+) and c.actioncode=a.code(+) and tr.status = st.code(+) and st.type=sd.code(+) and nvl(sd.code_table,'STATUS.TYPE')='STATUS.TYPE' and tr.idnumber = pr.idnumber(+) and to_number(st.type) between 0 and 7 and extract(year from tr.timestamp)=$P!{P_YEAR} and ($X{IN,tr.opportunity_type,P_OPPTYP_COLLECTION} $P!{P_OPPTYP_NULL_SQL} $P!{P_UNIT_CONVERTED} $P!{P_REPORT_TYPE_SQL} ) $P!{P_CE_STAGE_SQL_1} $P!{P_CE_STAGE_YEAR} $P!{P_CE_STAGE_REPORT_TYPE_SQL} $P!{P_CE_STAGE_UNIT_CONVERTED} $P!{P_CE_STAGE_SQL_2} ) Group By Action_Stage_Description order by 1]]></queryString><field name="COUNT_DONORS" class="java.lang.Integer"/><field name="YTD_COUNT_DONORS" class="java.lang.Integer"/><field name="ACTION_STAGE_DESCRIPTION" class="java.lang.String"/><field name="COUNT_OPEN_ACTION_DONORS" class="java.lang.Integer"/><field name="COUNT_CLOSED_ACTION_DONORS" class="java.lang.Integer"/><field name="YTD_COUNT_ACTIONS" class="java.lang.Integer"/><field name="COUNT_OPEN_ACTIONS" class="java.lang.Integer"/><field name="COUNT_CLOSED_ACTIONS" class="java.lang.Integer"/><field name="COUNT_ACTIONS" class="java.lang.Integer"/></subDataset><parameter name="P_UNIT_ID" class="java.lang.Integer"><parameterDescription><![CDATA[]]></parameterDescription><defaultValueExpression><![CDATA[-1]]></defaultValueExpression></parameter><parameter name="P_OPPTYP_COLLECTION" class="java.util.Collection"><defaultValueExpression><![CDATA[Arrays.asList("CE".split(","))]]></defaultValueExpression></parameter><parameter name="P_OPPTYP_NULL_SQL" class="java.lang.String" isForPrompting="false"><defaultValueExpression><![CDATA[$P{P_OPPTYP_COLLECTION}.contains("-99")?" or code is null ":""]]></defaultValueExpression></parameter><parameter name="P_YEAR" class="java.lang.Integer"/><parameter name="P_ROLLUP" class="java.lang.Boolean"><defaultValueExpression><![CDATA[true]]></defaultValueExpression></parameter><parameter name="P_UNIT" class="java.lang.Integer" isForPrompting="false"><parameterDescription><![CDATA[]]></parameterDescription></parameter><parameter name="P_UNIT_LEVEL" class="java.lang.Integer"/><parameter name="P_UNIT_CONVERTED" class="java.lang.String" isForPrompting="false"><parameterDescription><![CDATA[]]></parameterDescription><defaultValueExpression><![CDATA[new Boolean($P{P_ROLLUP}) ? ($P{P_UNIT_ID} != null && $P{P_UNIT_ID} == -1 ? " " :" AND pr.UNITID IN (SELECT SUB_UNIT_ID FROM W_PRSUNT_D WHERE PARENT_UNIT_ID IN ('"+$P{P_UNIT_ID}+"') ) " ): ($P{P_UNIT_ID} != null && $P{P_UNIT_ID} == -1 ? " " : " AND pr.UNITID = " + $P{P_UNIT_ID} )]]></defaultValueExpression></parameter><parameter name="P_ROLLUP_CONVERTED" class="java.lang.String" isForPrompting="false"><defaultValueExpression><![CDATA[new Boolean($P{P_ROLLUP}) ?"Yes" :"No"]]></defaultValueExpression></parameter><parameter name="P_STAGE" class="java.lang.String"><defaultValueExpression><![CDATA["--ALL--"]]></defaultValueExpression></parameter><parameter name="P_REPORT_TYPE" class="java.lang.String"><parameterDescription><![CDATA[]]></parameterDescription><defaultValueExpression><![CDATA["B"]]></defaultValueExpression></parameter><queryString language="SQL"><![CDATA[select 'We are LIVE' warehouse_str, (select listagg(nvl(code,'Not Coded'),',') within group (order by code) from W_OPPTYP_D w where $X{IN,code,P_OPPTYP_COLLECTION} $P!{P_OPPTYP_NULL_SQL} ) as opp_type_str,(CASE WHEN $P{P_REPORT_TYPE} ='B'THEN ' 'WHEN $P{P_REPORT_TYPE} ='O'THEN ' and c.actiondate is null 'ELSE ' and c.actiondate is not null 'END) as report_type_sqlfrom dual]]></queryString><field name="WAREHOUSE_STR" class="java.lang.String"/><field name="OPP_TYPE_STR" class="java.lang.String"/><field name="REPORT_TYPE_SQL" class="java.lang.String"/><variable name="V_PARAMETERS" class="java.lang.String"><variableExpression><![CDATA["<b>Unit ID: </b>"+($P{P_UNIT_ID}==-99||$P{P_UNIT_ID}==-1?"ALL":$P{P_UNIT_ID})+" | <b>Rollup: </b>"+$P{P_ROLLUP_CONVERTED}+" | <b>Year: </b>"+$P{P_YEAR}+" | <b>Opportunity Outcome: </b>"+($P{P_REPORT_TYPE}=="B"?"ALL":($P{P_REPORT_TYPE}=="O"?"Open":"Closed"))+" | <b>Opportunity Type(s): </b>"+(($P{P_OPPTYP_COLLECTION}.isEmpty()||$P{P_OPPTYP_COLLECTION}.contains("-99"))?"ALL":$F{OPP_TYPE_STR})+" | <b>Stage: </b>"+($P{P_STAGE}=="--ALL--"||$P{P_STAGE}==null?"ALL":$P{P_STAGE})]]></variableExpression></variable><detail><band height="249" splitType="Stretch"><property name="local_mesure_unitheight" value="pixel"/><property name="com.jaspersoft.studio.unit.height" value="px"/><componentElement><reportElement x="0" y="0" width="400" height="210" uuid="58ce68f3-f9a4-41e7-92e1-9562fd713c88"><property name="local_mesure_unitheight" value="pixel"/><property name="com.jaspersoft.studio.unit.height" value="px"/></reportElement><hc:chart xmlns:hc="http://jaspersoft.com/highcharts" xsi:schemaLocation="http://jaspersoft.com/highcharts http://jaspersoft.com/schema/highcharts.xsd" type="Pie"><hc:chartSetting name="default"><hc:chartProperty name="_showDataPoints"><hc:propertyExpression><![CDATA[boolean.TRUE]]></hc:propertyExpression></hc:chartProperty><hc:chartProperty name="_showMeasureNameOnValueAxis"><hc:propertyExpression><![CDATA[boolean.FALSE]]></hc:propertyExpression></hc:chartProperty><hc:chartProperty name="chart.ignoreHiddenSeries"><hc:propertyExpression><![CDATA[boolean.FALSE]]></hc:propertyExpression></hc:chartProperty><hc:chartProperty name="chart.marginBottom" value="25"/><hc:chartProperty name="chart.marginLeft" value="5"/><hc:chartProperty name="chart.showAxes"><hc:propertyExpression><![CDATA[boolean.FALSE]]></hc:propertyExpression></hc:chartProperty><hc:chartProperty name="chart.zoomType" value="xy"/><hc:chartProperty name="colors"><hc:propertyExpression><![CDATA[java.util.Arrays.asList("#0994CF","#FEC305","#7E61C6","#87C117","#A82C2C","#92A8CD","#D85507","#D85507","#868686")]]></hc:propertyExpression></hc:chartProperty><hc:chartProperty name="credits.enabled"><hc:propertyExpression><![CDATA[boolean.FALSE]]></hc:propertyExpression></hc:chartProperty><hc:chartProperty name="legend.align"><hc:propertyExpression><![CDATA["left"]]></hc:propertyExpression></hc:chartProperty><hc:chartProperty name="legend.enabled"><hc:propertyExpression><![CDATA[boolean.TRUE]]></hc:propertyExpression></hc:chartProperty><hc:chartProperty name="legend.floating"><hc:propertyExpression><![CDATA[boolean.TRUE]]></hc:propertyExpression></hc:chartProperty><hc:chartProperty name="legend.itemStyle.fontSize" value="10px"/><hc:chartProperty name="legend.labelFormatter"><hc:propertyExpression><![CDATA["function(){return this.name.substring(0,this.name.indexOf('<br>'))}"]]></hc:propertyExpression></hc:chartProperty><hc:chartProperty name="legend.layout" value=""vertical""/><hc:chartProperty name="legend.margin"><hc:propertyExpression><![CDATA[new Integer(10)]]></hc:propertyExpression></hc:chartProperty><hc:chartProperty name="legend.verticalAlign" value=""top""/><hc:chartProperty name="plotOptions.pie.center"><hc:propertyExpression><![CDATA[[275,75]]]></hc:propertyExpression></hc:chartProperty><hc:chartProperty name="plotOptions.pie.showInLegend" value="true"/><hc:chartProperty name="plotOptions.series.dataLabels.enabled"><hc:propertyExpression><![CDATA[boolean.FALSE]]></hc:propertyExpression></hc:chartProperty><hc:chartProperty name="plotOptions.series.visible"><hc:propertyExpression><![CDATA[boolean.TRUE]]></hc:propertyExpression></hc:chartProperty><hc:chartProperty name="title.text"><hc:propertyExpression><![CDATA[""]]></hc:propertyExpression></hc:chartProperty><hc:chartProperty name="title.y"><hc:propertyExpression><![CDATA[new Integer(0)]]></hc:propertyExpression></hc:chartProperty><hc:chartProperty name="tooltip.backgroundColor"><hc:propertyExpression><![CDATA[new java.awt.Color(16777215)]]></hc:propertyExpression></hc:chartProperty><hc:chartProperty name="tooltip.pointFormat"><hc:propertyExpression><![CDATA["<b>Click to run detail report.</b>"]]></hc:propertyExpression></hc:chartProperty><hc:chartProperty name="tooltip.style.font" value="12px Arial, sans-serif"/><hc:chartProperty name="tooltip.useHTML"><hc:propertyExpression><![CDATA[boolean.TRUE]]></hc:propertyExpression></hc:chartProperty><hc:chartProperty name="xAxis.labels.formatter"><hc:propertyExpression><![CDATA["function(){return this.value.substring(0,this.value.indexOf(' '))}"]]></hc:propertyExpression></hc:chartProperty><hc:chartProperty name="xAxis.labels.style.color" value="#868686"/><hc:chartProperty name="xAxis.labels.style.font" value="10px Arial, sans-serif"/><hc:chartProperty name="xAxis.labels.useHTML"><hc:propertyExpression><![CDATA[boolean.TRUE]]></hc:propertyExpression></hc:chartProperty><hc:chartProperty name="xAxis.lineColor" value="#000000"/><hc:chartProperty name="xAxis.lineWidth" value="1"/><hc:chartProperty name="xAxis.tickColor" value="#000000"/><hc:chartProperty name="xAxis.tickmarkPlacement" value="on"/><hc:chartProperty name="xAxis.title.offset" value="25"/><hc:chartProperty name="xAxis.title.style.color" value="#000000"/><hc:chartProperty name="xAxis.title.style.font" value="16px Arial, sans-serif"/><hc:chartProperty name="xAxis.title.text"><hc:propertyExpression><![CDATA[""]]></hc:propertyExpression></hc:chartProperty><hc:chartProperty name="yAxis.labels.formatter"><hc:propertyExpression><![CDATA["function() {return ((window.Highcharts && Highcharts.numberFormat(this.value,0)) || this.value) }"]]></hc:propertyExpression></hc:chartProperty><hc:chartProperty name="yAxis.labels.step" value="2"/><hc:chartProperty name="yAxis.labels.style.color" value="#868686"/><hc:chartProperty name="yAxis.labels.style.font" value="12px Arial, sans-serif"/><hc:chartProperty name="yAxis.lineColor" value="#000000"/><hc:chartProperty name="yAxis.lineWidth" value="1"/><hc:chartProperty name="yAxis.tickColor" value="#000000"/><hc:chartProperty name="yAxis.tickWidth" value="1"/><hc:chartProperty name="yAxis.tickmarkPlacement" value="on"/><hc:chartProperty name="yAxis.title.offset" value="25"/><hc:chartProperty name="yAxis.title.style.color" value="#000000"/><hc:chartProperty name="yAxis.title.style.font" value="16px Arial, sans-serif"/><hc:chartProperty name="plotOptions.pie.marker.enabled"><hc:propertyExpression><![CDATA[boolean.TRUE]]></hc:propertyExpression></hc:chartProperty><hc:chartProperty name="yAxis.title.text" value=""/></hc:chartSetting><multiAxisData><multiAxisDataset><dataset><datasetRun subDataset="ACTIONS" uuid="0e4ebbf1-4057-4a21-b648-146b23a81b33"><datasetParameter name="P_OPPTYP_COLLECTION"><datasetParameterExpression><![CDATA[$P{P_OPPTYP_COLLECTION}]]></datasetParameterExpression></datasetParameter><datasetParameter name="P_OPPTYP_NULL_SQL"><datasetParameterExpression><![CDATA[$P{P_OPPTYP_COLLECTION}.contains("-99")?" or tr.opportunity_type is null) ":" and 1=1) "]]></datasetParameterExpression></datasetParameter><datasetParameter name="P_UNIT_CONVERTED"><datasetParameterExpression><![CDATA[$P{P_UNIT_CONVERTED}]]></datasetParameterExpression></datasetParameter><datasetParameter name="P_YEAR"><datasetParameterExpression><![CDATA[$P{P_YEAR}]]></datasetParameterExpression></datasetParameter><datasetParameter name="P_UNIT_ID"><datasetParameterExpression><![CDATA[$P{P_UNIT_ID}]]></datasetParameterExpression></datasetParameter><datasetParameter name="P_ROLLUP"><datasetParameterExpression><![CDATA[$P{P_ROLLUP}]]></datasetParameterExpression></datasetParameter><datasetParameter name="P_REPORT_TYPE_SQL"><datasetParameterExpression><![CDATA[$F{REPORT_TYPE_SQL}]]></datasetParameterExpression></datasetParameter><datasetParameter name="P_REPORT_TYPE"><datasetParameterExpression><![CDATA[$P{P_REPORT_TYPE}]]></datasetParameterExpression></datasetParameter><connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression></datasetRun></dataset></multiAxisDataset><dataAxis axis="Rows"><axisLevel name="Level1"><labelExpression><![CDATA["Level Label expression"]]></labelExpression><axisLevelBucket order="None" class="java.lang.String"><bucketExpression><![CDATA[($F{ACTION_STAGE_DESCRIPTION}==null?"<b>NO STAGE</b>":"<b>"+$F{ACTION_STAGE_DESCRIPTION}.toUpperCase()+" </b>")+"<br>--------------------------------<br>"+"<b>Stage Action Count: "+($F{COUNT_ACTIONS}==null?" </b>":$F{COUNT_ACTIONS}.toString()+"</b>")+"<br>"+"<b>Stage Open Action Count: "+($F{COUNT_OPEN_ACTIONS}==null?" </b>":$F{COUNT_OPEN_ACTIONS}.toString()+"</b>")+"<br>"+"<b>Stage Closed Action Count: "+($F{COUNT_CLOSED_ACTIONS}==null?" </b>":$F{COUNT_CLOSED_ACTIONS}.toString()+"</b>")+"<br>"+"<b>Year Action Count: "+($F{YTD_COUNT_ACTIONS}==null?" </b>":$F{YTD_COUNT_ACTIONS}.toString()+"</b>")+"<br>--------------------------------"]]></bucketExpression><bucketProperty name="ActionStage"><![CDATA[$F{ACTION_STAGE_DESCRIPTION}]]></bucketProperty><bucketProperty name="OpportunityTypes"><![CDATA[$P{P_OPPTYP_COLLECTION}]]></bucketProperty><bucketProperty name="Report_Type"><![CDATA[$P{P_REPORT_TYPE}]]></bucketProperty><bucketProperty name="Rollup"><![CDATA[$P{P_ROLLUP}]]></bucketProperty><bucketProperty name="Unit"><![CDATA[$P{P_UNIT_ID}]]></bucketProperty><bucketProperty name="Year"><![CDATA[$P{P_YEAR}]]></bucketProperty></axisLevelBucket></axisLevel></dataAxis><dataAxis axis="Columns"/><multiAxisMeasure name="Measure1" class="java.lang.Integer" calculation="Nothing"><labelExpression><![CDATA["Count of Actions"]]></labelExpression><valueExpression><![CDATA[$F{COUNT_ACTIONS}]]></valueExpression></multiAxisMeasure></multiAxisData><hc:series name="Measure1"><hc:contributor name="SeriesItemHyperlink"><hc:contributorProperty name="hyperlinkType" valueType="Constant" value="ReportExecution"/><hc:contributorProperty name="hyperlinkTarget" valueType="Constant" value="Blank"/><hc:contributorProperty name="_report" valueType="Constant" value="/iReports/JDRFCAOpportunityTypeActionsYTDDetails"/><hc:contributorProperty name="P_UNIT" valueType="Bucket" value="Level1.Unit"/><hc:contributorProperty name="P_OPPTYP_COLLECTION" valueType="Bucket" value="Level1.OpportunityTypes"/><hc:contributorProperty name="P_ROLLUP" valueType="Bucket" value="Level1.Rollup"/><hc:contributorProperty name="P_YEAR" valueType="Bucket" value="Level1.Year"/><hc:contributorProperty name="P_ACTION_STAGE" valueType="Bucket" value="Level1.ActionStage"/><hc:contributorProperty name="P_REPORT_TYPE" valueType="Bucket" value="Level1.Report_Type"/></hc:contributor></hc:series></hc:chart></componentElement><textField isStretchWithOverflow="true" isBlankWhenNull="true"><reportElement mode="Transparent" x="0" y="210" width="400" height="39" forecolor="#868686" backcolor="#FFFFFF" uuid="b00dc28b-8a46-4146-9278-b862d9a9f369"><property name="local_mesure_unitheight" value="pixel"/><property name="com.jaspersoft.studio.unit.height" value="px"/><property name="local_mesure_unity" value="pixel"/><property name="com.jaspersoft.studio.unit.y" value="px"/></reportElement><box topPadding="2" leftPadding="5" bottomPadding="5" rightPadding="5"/><textElement textAlignment="Left" verticalAlignment="Bottom" rotation="None" markup="html"><font fontName="SansSerif" size="10" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/></textElement><textFieldExpression><![CDATA[$V{V_PARAMETERS}]]></textFieldExpression></textField></band></detail></jasperReport>
  2. Good afternoon. For an HTML5 pie chart that I developed in Jasper Studio 5.6, I built an expression for the chart data category so that my tooltip would display detailed information about each pie slice. The expression is as follows: ($F{CATEGORY_DESCRIPTION}==null?"<b>NO STAGE</b>":"<b>"+$F{CATEGORY_DESCRIPTION}.toUpperCase()+" </b>")+"<br>--------------------------------<br>"+"<b>Stage Action Count: "+($F{COUNT_ACTIONS}==null?" </b>":$F{COUNT_ACTIONS}.toString()+"</b>")+"<br>"+"<b>Stage Open Action Count: "+($F{COUNT_OPEN_ACTIONS}==null?" </b>":$F{COUNT_OPEN_ACTIONS}.toString()+"</b>")+"<br>"+"<b>Stage Closed Action Count: "+($F{COUNT_CLOSED_ACTIONS}==null?" </b>":$F{COUNT_CLOSED_ACTIONS}.toString()+"</b>")+"<br>"+"<b>Year Action Count: "+($F{YTD_COUNT_ACTIONS}==null?" </b>":$F{YTD_COUNT_ACTIONS}.toString()+"</b>")+"<br>--------------------------------" I only need the legend to display the first line of that expression however. To accomplish this, I added a legend.labelFormatter property in Advanced Chart Properties. The value for that property is: "function(){return this.name.substring(0, this.name.indexOf('<br>'))}"The chart has been rendering perfectly on the 5.6 JasperServer. Now that we've upgraded our JasperServer to 6.2.1, the legend no longer shows only the first line of the expression. Rather, it is showing the expression in its entirety as it doesn't seem to be processing the substring() function at all. I have tried removing the this.name.indexOf('<br>') portion and just providing another numerical string position but to no avail. Any insight you can provide would be greatly appreciated! Thank you. Karen
×
×
  • Create New...