gcochard
-
Posts
6 -
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
Posts posted by gcochard
-
-
Hi,
I see exactly what you mean and I provided a screenshot as requested.
The behaviour is the following :
When the series expression is repeated in the dataset for different category expression (even sorted by series expression) , the BAR does not get aligned with the label as it ould save some space for other bars??!!
Strange!!
Code: <?xml version="1.0" encoding="UTF-8"?><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="Evaluation" language="groovy" pageWidth="1440" pageHeight="2160" columnWidth="1400" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isIgnorePagination="true"> <property name="ireport.zoom" value="0.5"/> <property name="ireport.x" value="0"/> <property name="ireport.jasperserver.reportUnit" value="/COHERANS/PRODUCTION/REPORTS/Evaluation/Cloud_Report"/> <property name="ireport.jasperserver.url" value="http://iptr.coherans.com:8080/jasperserver/services/repository"/> <property name="ireport.y" value="0"/> <style name="Crosstab Data Text" hAlign="Center"/> <style name="table"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Heading 1" fontSize="16" isBold="true"/> <subDataset name="Evaluation"> <parameter name="Org_Name_Input" class="java.math.BigDecimal"> <defaultValueExpression><![CDATA[40]]></defaultValueExpression> </parameter> <parameter name="Choisir_le_niveau" class="java.lang.String"> <defaultValueExpression><![CDATA[3]]></defaultValueExpression> </parameter> <parameter name="Action_Id" class="java.lang.Long"> <defaultValueExpression><![CDATA[4]]></defaultValueExpression> </parameter> <parameter name="Level" class="java.lang.String"> <defaultValueExpression><![CDATA[2]]></defaultValueExpression> </parameter> <parameter name="AvgAction" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA[1.5]]></defaultValueExpression> </parameter> <queryString> <![CDATA[sELECTp_sk.name,eval_number,comp,avg(level_input) as avg_level,$P{AvgAction} as avgFROM dw_eval_fact skINNER JOIN skill p_sk ON sk.lft BETWEEN p_sk.lft AND p_sk.rgt AND p_sk.root_id = sk.root_idWHEREsk.level = $P{Choisir_le_niveau}andp_sk.level = $P{Level}andaction_id = $P{Action_Id}and (site_id = $P{Org_Name_Input} OR div_id = $P{Org_Name_Input} OR compte_id = $P{Org_Name_Input} OR groupe_id = $P{Org_Name_Input})GROUP BYeval_number, comp , p_sk.nameORDER BY comp , p_sk.name]]> </queryString> <field name="name" class="java.lang.String"/> <field name="eval_number" class="java.lang.String"/> <field name="comp" class="java.lang.String"/> <field name="avg_level" class="java.math.BigDecimal"/> <field name="avg" class="java.math.BigDecimal"/> </subDataset> <parameter name="Liste_stagiaire" class="java.lang.String"> <defaultValueExpression><![CDATA["OIGP.000052"]]></defaultValueExpression> </parameter> <parameter name="Level" class="java.lang.String"> <defaultValueExpression><![CDATA[2]]></defaultValueExpression> </parameter> <parameter name="Action_Id" class="java.lang.Long"> <defaultValueExpression><![CDATA[4]]></defaultValueExpression> </parameter> <parameter name="Time_Dim_Input" class="java.lang.String"> <defaultValueExpression><![CDATA[2]]></defaultValueExpression> </parameter> <parameter name="Org_Dim_Input" class="java.lang.Long"> <defaultValueExpression><![CDATA[0]]></defaultValueExpression> </parameter> <parameter name="Time_Chooser" class="java.util.Collection"/> <parameter name="Choisir_le_niveau" class="java.lang.String"> <defaultValueExpression><![CDATA[3]]></defaultValueExpression> </parameter> <parameter name="Org_Name_Input" class="java.math.BigDecimal"> <defaultValueExpression><![CDATA[40]]></defaultValueExpression> </parameter> <queryString> <![CDATA[sELECTeval_number,comp,avg(level_input) as avg_levelFROM dw_eval_fact skWHEREsk.level = 0andaction_id = $P{Action_Id}GROUP BYeval_number, compORDER BY comp]]> </queryString> <field name="eval_number" class="java.lang.String"/> <field name="comp" class="java.lang.String"/> <field name="avg_level" class="java.math.BigDecimal"/> <variable name="avg_level_1" class="java.math.BigDecimal" calculation="Average"> <variableExpression><![CDATA[$F{avg_level}]]></variableExpression> </variable> <background> <band splitType="Stretch"/> </background> <title> <band height="50" splitType="Stretch"/> </title> <pageHeader> <band splitType="Stretch"/> </pageHeader> <columnFooter> <band splitType="Stretch"/> </columnFooter> <pageFooter> <band splitType="Stretch"/> </pageFooter> <summary> <band height="2120" splitType="Stretch"> <multiAxisChart> <chart isShowLegend="true" renderType="image" theme="CoheransChart Theme V2"> <reportElement x="0" y="0" width="1400" height="586"/> <chartTitle/> <chartSubtitle/> <chartLegend position="Top"/> </chart> <multiAxisPlot> <plot labelRotation="0.0"/> <axis> <barChart> <chart isShowLegend="true" renderType="image" theme="CoheransChart Theme V2"> <reportElement x="0" y="0" width="0" height="0" backcolor="#FFFFFF"/> <chartTitle color="#000000"/> <chartSubtitle color="#000000"/> <chartLegend textColor="#000000" backgroundColor="#FFFFFF" position="Top"/> </chart> <categoryDataset> <dataset> <datasetRun subDataset="Evaluation"> <datasetParameter name="AvgAction"> <datasetParameterExpression><![CDATA[$V{avg_level_1}]]></datasetParameterExpression> </datasetParameter> <datasetParameter name="Action_Id"> <datasetParameterExpression><![CDATA[$P{Action_Id}]]></datasetParameterExpression> </datasetParameter> <datasetParameter name="Org_Name_Input"> <datasetParameterExpression><![CDATA[$P{Org_Name_Input}]]></datasetParameterExpression> </datasetParameter> <datasetParameter name="Choisir_le_niveau"> <datasetParameterExpression><![CDATA[$P{Choisir_le_niveau}]]></datasetParameterExpression> </datasetParameter> <datasetParameter name="Level"> <datasetParameterExpression><![CDATA[$P{Level}]]></datasetParameterExpression> </datasetParameter> </datasetRun> </dataset> <categorySeries> <seriesExpression><![CDATA[$F{name}]]></seriesExpression> <categoryExpression><![CDATA[$F{comp}]]></categoryExpression> <valueExpression><![CDATA[$F{avg_level}]]></valueExpression> <itemHyperlink> <hyperlinkTooltipExpression><![CDATA[$F{avg_level}]]></hyperlinkTooltipExpression> </itemHyperlink> </categorySeries> </categoryDataset> <barPlot isShowLabels="true" isShowTickLabels="true" isShowTickMarks="true"> <plot labelRotation="90.0"/> <itemLabel color="#000000" backgroundColor="#FFFFFF"/> <categoryAxisFormat labelRotation="90.0"> <axisFormat verticalTickLabels="true"> <labelFont/> <tickLabelFont> <font size="8"/> </tickLabelFont> </axisFormat> </categoryAxisFormat> <valueAxisFormat> <axisFormat verticalTickLabels="false"> <labelFont/> <tickLabelFont/> </axisFormat> </valueAxisFormat> <rangeAxisMinValueExpression><![CDATA[0]]></rangeAxisMinValueExpression> <rangeAxisMaxValueExpression><![CDATA[3]]></rangeAxisMaxValueExpression> </barPlot> </barChart> </axis> <axis> <lineChart> <chart isShowLegend="true" renderType="draw" theme="aegean"> <reportElement x="0" y="0" width="0" height="0" backcolor="#FFFFFF"/> <chartTitle color="#000000"/> <chartSubtitle color="#000000"/> <chartLegend textColor="#000000" backgroundColor="#FFFFFF" position="Top"/> </chart> <categoryDataset> <dataset> <datasetRun subDataset="Evaluation"> <datasetParameter name="AvgAction"> <datasetParameterExpression><![CDATA[$V{avg_level_1}]]></datasetParameterExpression> </datasetParameter> <datasetParameter name="Level"> <datasetParameterExpression><![CDATA[$P{Level}]]></datasetParameterExpression> </datasetParameter> <datasetParameter name="Action_Id"> <datasetParameterExpression><![CDATA[$P{Action_Id}]]></datasetParameterExpression> </datasetParameter> <datasetParameter name="Choisir_le_niveau"> <datasetParameterExpression><![CDATA[$P{Choisir_le_niveau}]]></datasetParameterExpression> </datasetParameter> <datasetParameter name="Org_Name_Input"> <datasetParameterExpression><![CDATA[$P{Org_Name_Input}]]></datasetParameterExpression> </datasetParameter> </datasetRun> </dataset> <categorySeries> <seriesExpression><![CDATA["Moyenne Générale"]]></seriesExpression> <categoryExpression><![CDATA[$F{comp}]]></categoryExpression> <valueExpression><![CDATA[$F{avg}]]></valueExpression> <itemHyperlink> <hyperlinkTooltipExpression><![CDATA[$F{avg_level}]]></hyperlinkTooltipExpression> </itemHyperlink> </categorySeries> </categoryDataset> <linePlot isShowLines="true" isShowShapes="false"> <plot labelRotation="90.0"/> <categoryAxisFormat labelRotation="90.0"> <axisFormat verticalTickLabels="true"> <labelFont/> <tickLabelFont/> </axisFormat> </categoryAxisFormat> <valueAxisFormat> <axisFormat verticalTickLabels="false"> <labelFont/> <tickLabelFont/> </axisFormat> </valueAxisFormat> <rangeAxisMinValueExpression><![CDATA[0]]></rangeAxisMinValueExpression> <rangeAxisMaxValueExpression><![CDATA[3]]></rangeAxisMaxValueExpression> </linePlot> </lineChart> </axis> </multiAxisPlot> </multiAxisChart> </band> </summary></jasperReport>
-
Thanks but this is iReport.
I'd like to get the JasperServer version with the bundle tomcat & jasperdb repository.
Any idea?
-
Hello,
I would like to download and install JaserReport CE to test new features but I do not find any place where you can actually donwload installers for Windows & Linux like previous versions.
Any idea?
Thanks,
-
Thanks for the prompt answer.
Looking forward getting the CE edition...
-
Hello,
This is my first post to the forum and I would like to thank to contributors to Jasperver for everything and good work they have been doing.
Now, to come to my point, I realized that Spider Charts were available in iReport 3.7.6 and I wanted to deploy my reports to Jasperserver, which I did.
But, during the execution I received the following error :
com.jaspersoft.jasperserver.api.JSExceptionWrapper: org.xml.sax.SAXParseException: cvc-complex-type.2.4.a: Invalid content was found starting with element 'sc:spiderChart'. One of '{"http://jasperreports.sourceforge.net/jasperreports":component}' is expected.
Has somebody ever had this issue? Does Jasperserver support Spider Charts? Am I missing a library in my setup?
Thanks for your help,
More than two subdatasets causes error!
in Products
Posted
Hi,
I get this issue as well but it looks like this is restricted to the use of import functionality in iReport against a different environment (Java version).In any case, you can save the JRXML from iReport and upload it through the UI directly by uploading the file.
This is not very convenient but it works.
Any help here from the Jaspersoft core team would be appreciated.
Thanks,