astrid.guenther

Hello, I am a starter with Jasper and I have got a problem formatting a XY Line Chart. The Chart should show me Dates per week of the year. I use as x value expression an integer field that counts the number of the week in the year. So I have only integers from 1 to 53. But the chart shows me as description on the x axis doubles like 2,5 and 52,5. Do any one have an idea how I can accomplish only full integer values as x axis description? Thanks in advance. This is my jrxml-file: <?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="managementbericht" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="07cb5558-8c2a-4648-805c-6bdffb27856d"> <property name="ireport.zoom" value="1.0"/> <property name="ireport.x" value="1"/> <property name="ireport.y" value="0"/> <property name="ireport.jasperserver.reportUnit" value="/reports/Prolog/529"/> <property name="ireport.jasperserver.url" value="http://25.13.33.219:8081/jasperserver/services/repository"/> <style name="Title" fontName="Times New Roman" fontSize="50" isBold="true" pdfFontName="Times-Bold"/> <style name="SubTitle" forecolor="#736343" fontName="Arial" fontSize="18"/> <style name="Column header" forecolor="#666666" fontName="Arial" fontSize="12" isBold="true"/> <style name="Detail" fontName="Arial" fontSize="12"/> <style name="Row" mode="Transparent"> <conditionalStyle> <conditionExpression><![CDATA[$V{REPORT_COUNT}%2 == 0]]></conditionExpression> <style backcolor="#E6DAC3"/> </conditionalStyle> </style> <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA[""]]></defaultValueExpression> </parameter> <parameter name="typ" class="java.lang.String"> <defaultValueExpression><![CDATA["CRS"]]></defaultValueExpression> </parameter> <queryString> <![CDATA[sELECT 97 AS schwellwert, "verfuegbarkeit" AS bereich, WEEKOFYEAR(tab_stoerung_import.`StoerungEnde`) AS Kalenderwoche, tab_stoerung_import.`typ` AS tab_stoerung_import_typ, avg(100-(TIMESTAMPDIFF(MINUTE,tab_stoerung_import.`StoerungBeginn`,tab_stoerung_import.`StoerungEnde`)/100.8)) as durchschnitt FROM `tab_stoerung_import` tab_stoerung_import WHERE YEAR(tab_stoerung_import.`StoerungEnde`) = YEAR(CURDATE()) and TIMESTAMPDIFF(MINUTE,tab_stoerung_import.`StoerungBeginn`,tab_stoerung_import.`StoerungEnde`) > 5 GROUP BY Kalenderwoche, tab_stoerung_import.`typ` ORDER BY Kalenderwoche ASC, tab_stoerung_import.`Terminalnummer` ASC]]> </queryString> <field name="schwellwert" class="java.lang.Long"/> <field name="bereich" class="java.lang.String"/> <field name="Kalenderwoche" class="java.lang.Integer"/> <field name="tab_stoerung_import_typ" class="java.lang.String"/> <field name="durchschnitt" class="java.math.BigDecimal"/> <summary> <band height="465"> <xyLineChart> <chart evaluationTime="Report"> <reportElement uuid="cef670f0-da2e-4347-b36f-ab1f2eebc17b" x="0" y="0" width="802" height="465"/> <chartTitle/> <chartSubtitle/> <chartLegend/> </chart> <xyDataset> <dataset> <incrementWhenExpression><![CDATA[$F{tab_stoerung_import_typ}.equals( $P{typ} )]]></incrementWhenExpression> </dataset> <xySeries> <seriesExpression><![CDATA["Schwellwert"]]></seriesExpression> <xValueExpression><![CDATA[$F{Kalenderwoche}]]></xValueExpression> <yValueExpression><![CDATA[$F{schwellwert}]]></yValueExpression> <labelExpression><![CDATA["Schwellwert"]]></labelExpression> </xySeries> <xySeries> <seriesExpression><![CDATA["Durchschnittliche Verfügbarkeit"]]></seriesExpression> <xValueExpression><![CDATA[$F{Kalenderwoche}]]></xValueExpression> <yValueExpression><![CDATA[$F{durchschnitt}]]></yValueExpression> <labelExpression><![CDATA["Durchschnittliche Verfügbarkeit"]]></labelExpression> </xySeries> </xyDataset> <linePlot isShowShapes="false"> <plot/> <categoryAxisFormat> <axisFormat/> </categoryAxisFormat> <valueAxisFormat> <axisFormat/> </valueAxisFormat> <domainAxisMinValueExpression><![CDATA[0]]></domainAxisMinValueExpression> <domainAxisMaxValueExpression><![CDATA[53]]></domainAxisMaxValueExpression> <rangeAxisMinValueExpression><![CDATA[$F{schwellwert}-5]]></rangeAxisMinValueExpression> <rangeAxisMaxValueExpression><![CDATA[100]]></rangeAxisMaxValueExpression> </linePlot> </xyLineChart> </band> </summary> <noData> <band height="20"> <staticText> <reportElement uuid="a202219b-4ff0-4528-bb3c-6f5711f02880" x="0" y="0" width="802" height="20"/> <textElement/> <text><![CDATA[Keine Daten zum Anzeigen vorhanden]]></text> </staticText> </band> </noData> </jasperReport>

I do not think that you have to change something concerning the Parameters, if you deploy your report on JapserServer. Did it work for you in iReport? What error message did you get on JasperServer?

I made the connection over window "Jasper Reports Server Repository". You can oven this over window|Jasper Report Server Repository. First this window is empty. But you can add new Servers over a button in the top of the window. Unfortunately I have no glue for the right documentation. I expected this information in this guide: http://community.jaspersoft.com/documentation/ireport-ultimate-guide But I didn’t found something about this topic. Do any one else know the right documentation? Hope this helps.

I have the same installation and for me it no problem to save the ireport.conf. Are you sure that you are the rights for doing this in the operating system?

My pleasure!

I am very new here but I try an idea: You can change the encoding used for exporting here: Options | Export Options | Common. But I am sure you know this. Did you use the properties pdfFontName, isPdfEmbedded and pdfEncoding in your textfield?

Hi, if you have configured the Parameters you can use them like this: WHERE P.INTERNAL_NAME=$P{PROVIDERNAME}or P.CODE=$P{ProviderCODE} You can find this here: http://community.jaspersoft.com/documentation/ireport-ultimate-guide