[XY Line Chart]

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>

[How to use the where clause in Jasper using parameters in this query?]

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?

 

[Jasper Server - how to upload/deposit ireports?]

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.

 

[Why I can't save the ireport.conf?]

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?

[How to use the where clause in Jasper using parameters in this query?]

My pleasure!

[Export to PDF not displaying extended ASCII characters]

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?

 

[How to use the where clause in Jasper using parameters in this query?]

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