sreerambabu.palaniswamy Posted September 15, 2016 Share Posted September 15, 2016 Hi all,I've designed the HTML chart using the oracle query which passes Single value paramater and it worked fine. I used the method of placing the HTML Chart in theSummary band and set the Evalution time to Now and it worked fine.Now I would like to show the same HTML chart for multi value Parameter. I would like to show the chart element for each project in each pdf page.Hence Logically I need to place the HTML chart at Detail band rather than the Summary band. But now it doesn't work and throws error "incrementing bidimensional dataset".Is there any work around.FYI, I'm using this Chart report as subreport to another main report. Jaspersoft studio version:5.6.1 finalPlease do help ASAP.Thanks,Sreeram<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="Charts" pageWidth="200" pageHeight="275" orientation="Landscape" columnWidth="200" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="c6523df6-0c5f-4728-87c2-57825f88fca3"> <property name="com.jaspersoft.studio.unit." value="inch" /> <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.data.defaultdataadapter" value="Dev DB Conn" /> <parameter name="param_month" class="java.lang.String" /> <parameter name="param_year" class="java.lang.String" /> <parameter name="param_project" class="java.util.Collection" /> <queryString language="SQL"> <![CDATA[sELECT i.id prid,c.INUSAGE,d.CURRUSAGE FROM project table i, custom table c where i.id = c.id and $X{IN,I.id,param_project}]]> </queryString> <field name="prid" class="java.math.BigDecimal" /> <field name="INUSAGE" class="java.math.BigDecimal" /> <field name="CURRUSAGE" class="java.math.BigDecimal" /> <summary> <band height="223"> <componentElement> <reportElement positionType="Float" isPrintRepeatedValues="false" x="0" y="3" width="190" height="220" uuid="0a0e6b98-2d59-453a-8642-3a65d4b30bb1"> <property name="local_mesure_unitwidth" value="inch" /> </reportElement> <hc:chart xmlns:hc="http://jaspersoft.com/highcharts" xsi:schemaLocation="http://jaspersoft.com/highcharts http://jaspersoft.com/schema/highcharts.xsd" type="Column" evaluationGroup=""> <hc:chartSetting name="default"> <hc:chartProperty name="_showDataPoints"> <hc:propertyExpression> <![CDATA[boolean.FALSE]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="_showMeasureNameOnValueAxis"> <hc:propertyExpression> <![CDATA[boolean.FALSE]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="chart.alignTicks"> <hc:propertyExpression> <![CDATA[boolean.FALSE]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="chart.animation"> <hc:propertyExpression> <![CDATA[boolean.TRUE]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="chart.borderRadius"> <hc:propertyExpression> <![CDATA[new Integer(0)]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="chart.borderWidth"> <hc:propertyExpression> <![CDATA[new Integer(0)]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="chart.ignoreHiddenSeries"> <hc:propertyExpression> <![CDATA[boolean.FALSE]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="chart.selectionMarkerFill"> <hc:propertyExpression> <![CDATA[new java.awt.Color(-1)]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="chart.shadow"> <hc:propertyExpression> <![CDATA[boolean.FALSE]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="chart.spacingBottom"> <hc:propertyExpression> <![CDATA[new Integer(20)]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="chart.zoomType"> <hc:propertyExpression> <![CDATA["none"]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="colors"> <hc:propertyExpression> <![CDATA[java.util.Arrays.asList("#779499","#C0D9DE","#8bbc21","#910000","#1aadce","#492970","#f28f43","#77a1e5","#c42525","#a6c96a","#C0D9DE")]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="credits.enabled"> <hc:propertyExpression> <![CDATA[false]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="credits.href"> <hc:propertyExpression> <![CDATA[""]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="credits.text"> <hc:propertyExpression> <![CDATA[""]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.align"> <hc:propertyExpression> <![CDATA["center"]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.borderRadius"> <hc:propertyExpression> <![CDATA[new Integer(5)]]> </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.FALSE]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.layout"> <hc:propertyExpression> <![CDATA["horizontal"]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.lineHeight"> <hc:propertyExpression> <![CDATA[new Integer(30)]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.margin"> <hc:propertyExpression> <![CDATA[new Integer(15)]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.padding"> <hc:propertyExpression> <![CDATA[new Integer(8)]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.symbolPadding"> <hc:propertyExpression> <![CDATA[new Integer(5)]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.symbolWidth"> <hc:propertyExpression> <![CDATA[new Integer(30)]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.verticalAlign"> <hc:propertyExpression> <![CDATA["bottom"]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.x"> <hc:propertyExpression> <![CDATA[new Integer(10)]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legend.y"> <hc:propertyExpression> <![CDATA[new Integer(10)]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="legened.itemStyle.fontSize" value="4" /> <hc:chartProperty name="plotOptions.series.animation"> <hc:propertyExpression> <![CDATA[boolean.TRUE]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="plotOptions.series.dataLabels.enabled" value="true" /> <hc:chartProperty name="plotOptions.series.dataLabels.format" value="{point.y:,.0f}" /> <hc:chartProperty name="plotOptions.series.lineWidth"> <hc:propertyExpression> <![CDATA[new Integer(2)]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="plotOptions.series.shadow"> <hc:propertyExpression> <![CDATA[boolean.TRUE]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="plotOptions.series.showInLegend"> <hc:propertyExpression> <![CDATA[boolean.TRUE]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="plotOptions.series.visible"> <hc:propertyExpression> <![CDATA[boolean.TRUE]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="title.align"> <hc:propertyExpression> <![CDATA["left"]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="title.style.color"> <hc:propertyExpression> <![CDATA[new java.awt.Color(-4138530)]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="title.text"> <hc:propertyExpression> <![CDATA[""]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="title.verticalAlign"> <hc:propertyExpression> <![CDATA["top"]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="tooltip.animation"> <hc:propertyExpression> <![CDATA[boolean.TRUE]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="tooltip.enabled"> <hc:propertyExpression> <![CDATA[boolean.TRUE]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="tooltip.shadow"> <hc:propertyExpression> <![CDATA[boolean.TRUE]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="xAxis.labels.step"> <hc:propertyExpression> <![CDATA[new Integer(0)]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="yAxis.gridLineColor" value="'#FFFFFF'" /> <hc:chartProperty name="plotOptions.column.marker.enabled"> <hc:propertyExpression> <![CDATA[boolean.FALSE]]> </hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="yAxis.title.text" value="" /> </hc:chartSetting> <multiAxisData> <multiAxisDataset /> <dataAxis axis="Rows"> <axisLevel name="InvName"> <labelExpression> <![CDATA[]]> </labelExpression> <axisLevelBucket class="java.lang.String"> <bucketExpression> <![CDATA[]]> </bucketExpression> </axisLevelBucket> </axisLevel> </dataAxis> <dataAxis axis="Columns" /> <multiAxisMeasure name="Initial Baseline" class="java.lang.Integer" calculation="Highest"> <labelExpression> <![CDATA["Initial Baseline"]]> </labelExpression> <valueExpression> <![CDATA[$F{INUSAGE}]]> </valueExpression> </multiAxisMeasure> <multiAxisMeasure name="Current Baseline" class="java.lang.Integer" calculation="Highest"> <labelExpression> <![CDATA["Current Baseline"]]> </labelExpression> <valueExpression> <![CDATA[$F{CURRUSAGE}]]> </valueExpression> </multiAxisMeasure> </multiAxisData> <hc:series name="Current Baseline" /> <hc:series name="Initial Baseline" /> </hc:chart> </componentElement> </band> </summary></jasperReport>[/code] Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now