chr15athome

No one interested. Looks like its a no go then, its a shame because we were considering buying jasper if it worked. Back to Crystal. Chris

Anyone? I have just tried adding the webservice response to an iframe but still have all the same problems .i.e. images missing, header and -----Part text displayed, etc. Maybe there is a better way to do this but I have searched Google for hours and can't find any other solution. Can anyone help? Thnaks Chris

Hi All, It's been a while since my last use of jasper reporting software. I have recently been given a new project to add reporting capabilities to a PHP application so far I have been able to create a report in ireport load it into Jasper Server and request the report from a browser with paramters. This has all been setup to work via a webservice. This works great for my PDF reports but I would like to offer a html and CSV/XLS version of each report. I have managed to output some of the html version of the report to the page but my charts don't work and the csv version has all sorts of data in it that I don't really need like the web pages source. Just to get these html and csv reports working I had to manually parse the server response which seems wrong to me, maybe I am overlooking something. I can include sample code if needed. What I really want to know, is there an alternative way of obtaining the html and csv reports or is the webservice route the way to go? I have read about PHP-java Bridge and having used Jasper in a Java system before I feel this maybe the way to go. If anyone has any experiece of working with Jasper and PHP I would be grateful to hear your recommendations. Thanks Chris

Hi, I need to put the percentage value of each bar immediately above each bar in the chart, can anyone help? I have a customizer class. Thanks Chris

Hi Here is the code I ended up using:- Does anyone know how to change the bar widths in the code below? Thanks Chris Code:public void customize(JFreeChart chart, JRChart jrChart) { final CategoryAxis categoryAxis = new CategoryAxis("Category"); final ValueAxis valueAxis = new LogarithmicAxis("Percentage (%)"); this.chart = chart; LogarithmicAxis logScale = new LogarithmicAxis("Percentage (%)"); // CategoryPlot plot = null;// NumberAxis axis = new LogarithmicAxis("Percentage"); // plot.setRangeAxis(axis);// logScale.setStrictValuesFlag(false); logScale.setRange(0.00, 100.0); logScale.setAutoTickUnitSelection(true); //logScale. //logScale.autoAdjustRange(); chart.getCategoryPlot().setRangeAxis(logScale); categoryAxis.setUpperMargin(0.5); //plot.setRangeAxis(logScale); }

Also I would like to show more values on the vlue axis maybe 0,10,50,100. Is this possible? Thanks Chris

Hi Lucian, I managed to figure the chart customizer out. I just need to increase the bar width so that I can display the value of the bars percentage. My code so far:- Code:public void customize(JFreeChart chart, JRChart jrChart) { final CategoryAxis categoryAxis = new CategoryAxis("Category"); this.chart = chart; LogarithmicAxis logScale = new LogarithmicAxis("Percentage (%)"); logScale.setStrictValuesFlag(false); logScale.setRange(0.00, 100.0); logScale.setTickLabelsVisible(true); chart.getCategoryPlot().setRangeAxis(logScale); categoryAxis.setUpperMargin(0.5); }

Hi Lucian, Do you have any examples of how this can be done or a guide? I have had a quick Google on chart customizers but not much help is available. Do I write the customizer to extend JRAbstractChartCustomizer? Do I have to create the chart sparately and send it as an object? Thanks Chris

What you veiwing the report with?

Are you saying that you get the incompatible value errors all the time or only after it is stored in the database?

Hi, I have a single datasource a collection of Beans. I have a chart that is created from the datasource with no problems. However I would like to group the data into 3 separate charts but I have so far been unable to do so. Can anybody give me any ideas as to how this can be done? Thanks Chris

<bar3DChart> <chart isShowLegend="false" evaluationTime="Report" customizerClass="chartcustomizer.class"> <reportElement key="element-1" stretchType="RelativeToBandHeight" x="3" y="26" width="580" height="204"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <chartTitle/> <chartSubtitle/> <chartLegend/> </chart> <categoryDataset> <dataset resetType="None"/> <categorySeries> <seriesExpression><![CDATA[$F{statisticType}]]></seriesExpression> <categoryExpression><![CDATA[$F{alternativeDescription}]]></categoryExpression> <valueExpression><![CDATA[$V{PERCENTAGE}]]></valueExpression> <itemHyperlink/> </categorySeries> </categoryDataset> <bar3DPlot isShowLabels="true"> <plot backcolor="#FFFFFF" labelRotation="30.0"/> <categoryAxisFormat> <axisFormat> <labelFont> <font fontName="SansSerif" size="12" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/> </labelFont> <tickLabelFont> <font fontName="SansSerif" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/> </tickLabelFont> </axisFormat> </categoryAxisFormat> <valueAxisLabelExpression><![CDATA["Percentage (%)"]]></valueAxisLabelExpression> <valueAxisFormat> <axisFormat tickLabelMask=""> <labelFont/> <tickLabelFont/> </axisFormat> </valueAxisFormat> </bar3DPlot> </bar3DChart>

Sorry code is not visible will try again. Chris Code: $F{statisticType} $F{alternativeDescription} $V{PERCENTAGE} "Percentage (%)"

Why do you need 2 detail sections, wooldn't a group work? Chris

Hi, I have a 3D bar chart that displays values from 0-70%. Most of the values are between 0-10% maybe 1 or 2 are upto 70%. Is there anyway of having the scale alternate to make the smaller values look more significant because most of them actually are significant to our client but look insignificant on the chart. Thanks Chris Code: $F{statisticType} $F{alternativeDescription} $V{PERCENTAGE} "Percentage (%)"