Hitachi Vantara Pentaho Community Forums
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: New JasperReports plugin project - Any Volunteers?

  1. #11

    Default

    Check the schemas declarations on the jrxml file. Or could you post the jrxml content ?.

  2. #12
    Join Date
    Oct 2012
    Posts
    11

    Default

    This is the jrxml content:

    ---

    <?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="Quadrant4.0" language="groovy" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
    <property name="ireport.zoom" value="1.0"/>
    <property name="ireport.x" value="0"/>
    <property name="ireport.y" value="0"/>
    <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="TestParameter" class="java.lang.String">
    <defaultValueExpression><![CDATA["Parameter Message"]]></defaultValueExpression>
    </parameter>
    <parameter name="intParam" class="java.lang.Integer">
    <defaultValueExpression><![CDATA[99]]></defaultValueExpression>
    </parameter>
    <parameter name="floatParam" class="java.lang.Float">
    <defaultValueExpression><![CDATA[99.9]]></defaultValueExpression>
    </parameter>
    <parameter name="boolParam" class="java.lang.Boolean">
    <defaultValueExpression><![CDATA[true]]></defaultValueExpression>
    </parameter>
    <queryString>
    <![CDATA[select QUADRANT_ACTUALS.REGION,
    QUADRANT_ACTUALS.DEPARTMENT,
    QUADRANT_ACTUALS.POSITIONTITLE,
    QUADRANT_ACTUALS.ACTUAL,
    QUADRANT_ACTUALS.BUDGET,
    QUADRANT_ACTUALS.VARIANCE
    from QUADRANT_ACTUALS
    ORDER BY REGION, DEPARTMENT, POSITIONTITLE]]>
    </queryString>
    <field name="REGION" class="java.lang.String"/>
    <field name="DEPARTMENT" class="java.lang.String"/>
    <field name="POSITIONTITLE" class="java.lang.String"/>
    <field name="ACTUAL" class="java.math.BigDecimal"/>
    <field name="BUDGET" class="java.math.BigDecimal"/>
    <field name="VARIANCE" class="java.math.BigDecimal"/>
    <group name="Region">
    <groupExpression><![CDATA[$F{REGION}]]></groupExpression>
    <groupHeader>
    <band height="38">
    <textField>
    <reportElement mode="Opaque" x="0" y="0" width="347" height="38" backcolor="#33CC00"/>
    <textElement>
    <font size="26"/>
    </textElement>
    <textFieldExpression class="java.lang.String"><![CDATA["Region: "+$F{REGION}]]></textFieldExpression>
    </textField>
    </band>
    </groupHeader>
    </group>
    <group name="Department">
    <groupExpression><![CDATA[$F{DEPARTMENT}]]></groupExpression>
    <groupHeader>
    <band height="41">
    <frame>
    <reportElement mode="Opaque" x="0" y="0" width="555" height="41" backcolor="#FF9933"/>
    <textField>
    <reportElement x="0" y="0" width="247" height="22" forecolor="#FFFFFF"/>
    <textElement>
    <font size="13" isBold="true"/>
    </textElement>
    <textFieldExpression class="java.lang.String"><![CDATA["Department: "+$F{DEPARTMENT}]]></textFieldExpression>
    </textField>
    <staticText>
    <reportElement x="51" y="22" width="100" height="19" forecolor="#FFFFFF"/>
    <textElement textAlignment="Center">
    <font isBold="true"/>
    </textElement>
    <text><![CDATA[Position]]></text>
    </staticText>
    <staticText>
    <reportElement x="247" y="22" width="100" height="19" forecolor="#FFFFFF"/>
    <textElement textAlignment="Center">
    <font isBold="true"/>
    </textElement>
    <text><![CDATA[Actual]]></text>
    </staticText>
    <staticText>
    <reportElement x="347" y="22" width="100" height="19" forecolor="#FFFFFF"/>
    <textElement textAlignment="Center">
    <font isBold="true"/>
    </textElement>
    <text><![CDATA[Budget]]></text>
    </staticText>
    <staticText>
    <reportElement x="447" y="22" width="100" height="19" forecolor="#FFFFFF"/>
    <textElement textAlignment="Center">
    <font isBold="true"/>
    </textElement>
    <text><![CDATA[Variance]]></text>
    </staticText>
    </frame>
    </band>
    </groupHeader>
    </group>
    <title>
    <band height="136" splitType="Stretch">
    <image>
    <reportElement x="0" y="0" width="164" height="126"/>
    <imageExpression class="java.lang.String"><![CDATA["coffee.jpg"]]></imageExpression>
    </image>
    <staticText>
    <reportElement style="Title" x="170" y="0" width="262" height="62"/>
    <textElement verticalAlignment="Middle">
    <font size="40" pdfFontName="Times-Roman"/>
    </textElement>
    <text><![CDATA[JasperPlugin]]></text>
    </staticText>
    <staticText>
    <reportElement style="SubTitle" x="219" y="62" width="196" height="22"/>
    <textElement>
    <font fontName="Times New Roman" pdfFontName="Times-Roman"/>
    </textElement>
    <text><![CDATA[Exiting Quadrant Data]]></text>
    </staticText>
    <image>
    <reportElement x="433" y="-115" width="267" height="209"/>
    <imageExpression class="java.lang.String"><![CDATA["coffee_stain.png"]]></imageExpression>
    </image>
    <textField>
    <reportElement mode="Opaque" x="219" y="84" width="100" height="20" forecolor="#736343"/>
    <textElement verticalAlignment="Middle"/>
    <textFieldExpression class="java.lang.String"><![CDATA[$P{TestParameter}]]></textFieldExpression>
    </textField>
    </band>
    </title>
    <detail>
    <band height="20" splitType="Stretch">
    <textField>
    <reportElement x="51" y="0" width="100" height="20"/>
    <textElement/>
    <textFieldExpression class="java.lang.String"><![CDATA[$F{POSITIONTITLE}]]></textFieldExpression>
    </textField>
    <textField pattern="¤ #,##0.00">
    <reportElement x="247" y="0" width="100" height="20"/>
    <textElement textAlignment="Right"/>
    <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{ACTUAL}]]></textFieldExpression>
    </textField>
    <textField pattern="¤ #,##0.00">
    <reportElement x="347" y="0" width="100" height="20"/>
    <textElement textAlignment="Right"/>
    <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{BUDGET}]]></textFieldExpression>
    </textField>
    <textField pattern="¤ #,##0.00">
    <reportElement x="447" y="0" width="100" height="20"/>
    <textElement textAlignment="Right"/>
    <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VARIANCE}]]></textFieldExpression>
    </textField>
    </band>
    </detail>
    <summary>
    <band height="80">
    <textField>
    <reportElement x="0" y="0" width="100" height="20"/>
    <textElement/>
    <textFieldExpression class="java.lang.String"><![CDATA[$P{TestParameter}]]></textFieldExpression>
    </textField>
    <textField>
    <reportElement x="0" y="20" width="100" height="20"/>
    <textElement/>
    <textFieldExpression class="java.lang.Integer"><![CDATA[$P{intParam}]]></textFieldExpression>
    </textField>
    <textField>
    <reportElement x="0" y="40" width="100" height="20"/>
    <textElement/>
    <textFieldExpression class="java.lang.Float"><![CDATA[$P{floatParam}]]></textFieldExpression>
    </textField>
    <textField>
    <reportElement x="0" y="60" width="100" height="20"/>
    <textElement/>
    <textFieldExpression class="java.lang.Boolean"><![CDATA[$P{boolParam}]]></textFieldExpression>
    </textField>
    </band>
    </summary>
    </jasperReport>

  3. #13
    Join Date
    Oct 2012
    Posts
    11

    Default

    Any idea (report is standard report as comes with installation) ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2017 Pentaho Corporation. All Rights Reserved.