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 (%)"

Thanks for all the help Lucian. I finally found it was due to this version of openJDK: java-1.6.0-openjdk-src.i386 1:1.6.0.0-0.23.b09 download the up-to-date one from sun.com and everything works. I had to remove the openJDK completely before Eclipse would stop calling it and change the alternatives to point to suns VM. I can finally get back on with some real development work...lol. Thanks Chris

OK I just realised about logging in. Now I have managed to narrow this problem down to some sort or difference in versions between a system report I have that works and the same report that doesn't work run in a test environment. I have checked JFreeChart, JasperReports, JFree, Itext I know they are the same as we have run from command line adding the dependencies. Do you know any other class that might cause the missing text in the chart? Thanks Chris

Thanks Lucian, I tried to download the code but says error 404. Will wait a bit and try again. Have tried just the chart in separate report with same data source but no luck. Will try your data source and see if it makes a difference. Thanks Chris

Is there any chance of getting a copy of the working JRXML, so I can compare it with my none working JRXML. I do feel that it is the bean data source that is causing the problem. Thanks Chris

Hi Lucian, Sorry the pdf you posted works now. Can you tell me what data source you used? That is how the PDF should look. Would it be possible for you to send me the updated jrxml file so I can compare it. Thanks Chris

here is the pdf I get Thanks Chris

Hi Lucian, The link to the PDF doesn't seem to work. I tried ticking the box for the legend to show but it made no difference just showed a blank legend with no category names or anything else. I don't want the legend anyway so that is why I removed it again. I have tried posting the PDF result I get but the forum will not upload it. Thanks Chris

Here is the jrxml file I am using. Thanks Chris

Hi Lucian, The legend makes no difference its just blank. The problem is due to either the fields not being available when the chart is created (but I have tried every evaluateAt stage possible), the groups cause a problem with the fields that are available (Ihave tried incrementing by group) or the bean data source works differently to SQL data sources.

Hi, The charts bars are showing the correct values but where I use fields for the category series labels, etc the names are not resolved. Infact the only value which gets resolved is the Variable that calculates the percentage. However this variable is calculated using some of the other fields. I have tried passing all the fields into variables but still nothing. Thanks Chris