My Ideas ,Linux related Links, etc..: Auto-compile Jasper subreports in OpenNMS

I was trying to make a database report in OpenNMS to collect CPU utilization information from JRobin files. To use a subreport and make it compile the subreport every time you run the report, I ended up with the following way of presentation of jrxml file. May it be useful to someone.

The parent report 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="node-response-time" pageWidth="668" pageHeight="842" whenNoDataType="NoDataSection" columnWidth="628" 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="Report_Title" forecolor="#000000" fontSize="20"/>
        <style name="Report_Subtitle" forecolor="#000000" vAlign="Middle" fontSize="10" isBold="false" isItalic="true" isUnderline="false" isStrikeThrough="false"/>
        <style name="Table_Detail" hAlign="Left" vAlign="Middle" fontName="SansSerif" fontSize="10" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false"/>
        <style name="Table_Grid" mode="Transparent" forecolor="#FFFFFF" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false">
                <pen lineWidth="0.0" lineColor="#FFFFFF"/>
                <box>
                        <bottompen lineWidth="1.0"/>
                </box>
                <conditionalstyle>
                        <conditionexpression><![CDATA[new Boolean($V{style_helper_COUNT}%new Integer("5") == new Integer("0"))]]></conditionExpression>
                        <style mode="Opaque" forecolor="#999999">
                                <pen lineWidth="1.0" lineColor="#666666"/>
                                <box>
                                        <bottompen lineWidth="1.0"/>
                                </box>
                        </style>
                </conditionalStyle>
        </style>
        <style name="Page_Footer" fontSize="10" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false"/>
        <style name="Table_Header" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false"/>
        <style name="Table_Header_BG" mode="Opaque" backcolor="#CCFFCC"/>
        <style name="Table_Surveillance_Cat" forecolor="#000000" vAlign="Middle" fontSize="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false"/>
        <style name="Table_Surveillance_Cat_BG" mode="Opaque" backcolor="#DFDFDF"/>
        <style name="Table_Surveillance_Cat_Footer_BG" mode="Transparent" backcolor="#FFFFFF">
                <pen lineWidth="1.0" lineStyle="Double"/>
        </style>
        <style name="Table_Surveillance_Cat_Footer" hAlign="Center" vAlign="Middle" fontSize="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false">
                <box>
                        <bottompen lineWidth="0.0" lineStyle="Double" lineColor="#000000"/>
                </box>
        </style>
        <style name="Table_Surveillance_Cat_Footer_Line" hAlign="Center" vAlign="Middle" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false">
                <box>
                        <bottompen lineWidth="2.0" lineStyle="Double" lineColor="#000000"/>
                </box>
        </style>
        <style name="Surveillance_Category_Group" mode="Opaque" backcolor="#CCFFCC" hAlign="Left" vAlign="Middle" fontSize="12" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false"/>
        <style name="Node_Group" mode="Opaque" backcolor="#DFDFDF" hAlign="Left" vAlign="Middle" fontSize="10" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false"/>
        <style name="table">
                <box>
                        <pen lineWidth="1.0" lineColor="#000000"/>
                </box>
        </style>
        <style name="table_TH" mode="Opaque" backcolor="#F0F8FF">
                <box>
                        <toppen lineWidth="0.5" lineColor="#000000"/>
                        <bottompen lineWidth="0.5" lineColor="#000000"/>
                </box>
        </style>
        <style name="table_CH" mode="Opaque" backcolor="#BFE1FF">
                <box>
                        <toppen lineWidth="0.5" lineColor="#000000"/>
                        <bottompen lineWidth="0.5" lineColor="#000000"/>
                </box>
        </style>
        <style name="table_TD" mode="Opaque" backcolor="#FFFFFF">
                <box>
                        <toppen lineWidth="0.5" lineColor="#000000"/>
                        <bottompen lineWidth="0.5" lineColor="#000000"/>
                </box>
        </style>
        <style name="style1"/>
        <style name="Interface_Header" hAlign="Center" vAlign="Middle" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false"/>
        <parameter name="COMPANY_LOGO" class="java.lang.String" isForPrompting="false">
                <defaultvalueexpression><![CDATA["/opt/opennms/etc/report-templates/opennms-logo.png"]]></defaultValueExpression>
        </parameter>
        <parameter name="SURVEILLANCE_CATEGORY" class="java.lang.String">
                <defaultvalueexpression><![CDATA["ReportCategory"]]></defaultValueExpression>
        </parameter>
        <parameter name="startDate" class="java.util.Date">
                <defaultvalueexpression><![CDATA[new java.util.Date(
new GregorianCalendar(new GregorianCalendar().get(Calendar.YEAR), new GregorianCalendar().get(Calendar.MONTH), new GregorianCalendar().get(Calendar.DATE) - 7).getTimeInMillis()
)]]></defaultValueExpression>
        </parameter>
        <parameter name="endDate" class="java.util.Date">
                <defaultvalueexpression><![CDATA[new java.util.Date(
new GregorianCalendar(new GregorianCalendar().get(Calendar.YEAR), new GregorianCalendar().get(Calendar.MONTH), new GregorianCalendar().get(Calendar.DATE)).getTimeInMillis()
)]]></defaultValueExpression>
        </parameter>
        <parameter name="rrdDir" class="java.lang.String" isForPrompting="false">
                <defaultvalueexpression><![CDATA["/opt/opennms/share/rrd/snmp/"]]></defaultValueExpression>
        </parameter>
        <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
                <defaultvalueexpression><![CDATA["/opt/opennms/etc/report-templates/subreports/"]]></defaultValueExpression>
        </parameter>
        <querystring>
                <![CDATA[SELECT
        categories.categoryname,
        node.nodelabel,
        node.nodeid
FROM
        node
RIGHT JOIN
        category_node
ON
        (category_node.nodeid = node.nodeid)
JOIN
        categories
ON
        (categories.categoryid = category_node.categoryid)
WHERE
        (node.nodetype = 'A' AND
        categories.categoryname = $P{SURVEILLANCE_CATEGORY})
ORDER BY
        categories.categoryname,
        node.nodelabel]]>
        </queryString>
        <field name="categoryname" class="java.lang.String"/>
        <field name="nodelabel" class="java.lang.String"/>
        <field name="nodeid" class="java.lang.Integer"/>
        <group name="surveillance_category_group">
                <groupexpression><![CDATA[$F{categoryname}]]></groupExpression>
                <groupheader>
                        <band height="24">
                                <textfield>
                                        <reportelement style="Surveillance_Category_Group" x="0" y="0" width="628" height="22"/>
                                        <textElement/>
                                        <textfieldexpression class="java.lang.String"><![CDATA["Surveillance category: " + $F{categoryname}]]></textFieldExpression>
                                </textField>
                        </band>
                </groupHeader>
                <groupfooter>
                        <band/>
                </groupFooter>
        </group>
        <group name="nodelabel_group">
                <groupexpression><![CDATA[$F{nodelabel}]]></groupExpression>
                <groupheader>
                        <band height="59">
                                <textfield>
                                        <reportelement style="Node_Group" x="0" y="0" width="628" height="20"/>
                                        <textelement textAlignment="Left"/>
                                        <textfieldexpression class="java.lang.String"><![CDATA["Node " + $F{nodelabel}]]></textFieldExpression>
                                </textField>
                                <statictext>
                                        <reportelement style="Interface_Header" x="1" y="21" width="99" height="36"/>
                                        <textelement textAlignment="Left"/>
                                        <text><![CDATA[NodeID]]></text>
                                </staticText>
                                <statictext>
                                        <reportelement style="Interface_Header" x="100" y="21" width="99" height="36"/>
                                        <textelement textAlignment="Right"/>
                                        <text><![CDATA[Average CPU IDLE]]></text>
                                </staticText>
                                <statictext>
                                        <reportelement style="Interface_Header" x="200" y="21" width="99" height="36"/>
                                        <textelement textAlignment="Right"/>
                                        <text><![CDATA[Peak CPU IDLE]]></text>
                                </staticText>
                                <statictext>
                                        <reportelement style="Interface_Header" x="300" y="21" width="99" height="36"/>
                                        <textelement textAlignment="Right"/>
                                        <text><![CDATA[Average CPU Sys]]></text>
                                </staticText>
                                <statictext>
                                        <reportelement style="Interface_Header" x="400" y="21" width="99" height="36"/>
                                        <textelement textAlignment="Right"/>
                                        <text><![CDATA[Peak CPU SYS]]></text>
                                </staticText>
                                <statictext>
                                        <reportelement style="Interface_Header" x="500" y="21" width="99" height="36"/>
                                        <textelement textAlignment="Right"/>
                                        <text><![CDATA[Average CPU Nice]]></text>
                                </staticText>
                                <statictext>
                                        <reportelement style="Interface_Header" x="600" y="21" width="99" height="36"/>
                                        <textelement textAlignment="Right"/>
                                        <text><![CDATA[Peak CPU Nice]]></text>
                                </staticText>
                                <statictext>
                                        <reportelement style="Interface_Header" x="700" y="21" width="99" height="36"/>
                                        <textelement textAlignment="Right"/>
                                        <text><![CDATA[Average CPU User]]></text>
                                </staticText>
                                <statictext>
                                        <reportelement style="Interface_Header" x="800" y="21" width="99" height="36"/>
                                        <textelement textAlignment="Right"/>
                                        <text><![CDATA[Peak CPU User]]></text>
                                </staticText>
                                <statictext>
                                        <reportelement style="Interface_Header" x="900" y="21" width="99" height="36"/>
                                        <textelement textAlignment="Right"/>
                                        <text><![CDATA[Cpu Usage Avg]]></text>
                                </staticText>
                                <statictext>
                                        <reportelement style="Interface_Header" x="1000" y="21" width="99" height="36"/>
                                        <textelement textAlignment="Right"/>
                                        <text><![CDATA[CPU Usage Peak]]></text>
                                </staticText>
                        </band>
                </groupHeader>
                <groupfooter>
                        <band/>
                </groupFooter>
        </group>
        <background>
                <band splitType="Stretch"/>
        </background>
        <title>
                <band height="4" splitType="Stretch"/>
        </title>
        <pageheader>
                <band height="104" splitType="Stretch">
                        <statictext>
                                <reportelement style="Report_Title" x="0" y="49" width="555" height="34"/>
                                <textelement verticalAlignment="Middle">
                                        <font size="20" isBold="true"/>
                                </textElement>
                                <text><![CDATA[Average and Peak Traffic Rates]]></text>
                        </staticText>
                        <image>
                                <reportelement x="195" y="0" width="164" height="49"/>
                                <imageexpression class="java.lang.String"><![CDATA[$P{COMPANY_LOGO}]]></imageExpression>
                        </image>
                        <line>
                                <reportelement x="0" y="103" width="626" height="1"/>
                                <graphicelement>
                                        <pen lineWidth="1.5"/>
                                </graphicElement>
                        </line>
                        <statictext>
                                <reportelement style="Report_Subtitle" x="2" y="83" width="67" height="15"/>
                                <textElement/>
                                <text><![CDATA[Report begin: ]]></text>
                        </staticText>
                        <textfield evaluationTime="Page">
                                <reportelement style="Report_Subtitle" x="69" y="83" width="126" height="14"/>
                                <textElement/>
                                <textfieldexpression class="java.util.Date"><![CDATA[$P{startDate}]]></textFieldExpression>
                        </textField>
                        <textfield evaluationTime="Page">
                                <reportelement style="Report_Subtitle" x="255" y="83" width="131" height="14"/>
                                <textElement/>
                                <textfieldexpression class="java.util.Date"><![CDATA[$P{endDate}]]></textFieldExpression>
                        </textField>
                        <statictext>
                                <reportelement style="Report_Subtitle" x="195" y="83" width="60" height="14"/>
                                <textElement/>
                                <text><![CDATA[Report end: ]]></text>
                        </staticText>
                </band>
        </pageHeader>
        <columnheader>
                <band height="8" splitType="Stretch"/>
        </columnHeader>
        <detail>
                <band height="29" splitType="Stretch">
                        <subreport>
                                <reportelement x="0" y="0" width="628" height="26"/>
                                <subreportparameter name="rrdDir">
                                        <subreportparameterexpression><![CDATA[$P{rrdDir}]]></subreportParameterExpression>
                                </subreportParameter>
                                <subreportparameter name="startDate">
                                        <subreportparameterexpression><![CDATA[$P{startDate}]]></subreportParameterExpression>
                                </subreportParameter>
                                <subreportparameter name="nodeid">
                                        <subreportparameterexpression><![CDATA[$F{nodeid}]]></subreportParameterExpression>
                                </subreportParameter>
                                <subreportparameter name="endDate">
                                        <subreportparameterexpression><![CDATA[$P{endDate}]]></subreportParameterExpression>
                                </subreportParameter>
                                <connectionexpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
                                <subreportexpression class="java.lang.String"><![CDATA[JasperCompileManager.compileReportToFile(new String("/opt/opennms/etc/report-templates/subreports/PeakCPU_subreport.jrxml"))]]></subreportExpression>
                        </subreport>
                </band>
        </detail>
        <columnfooter>
                <band splitType="Stretch"/>
        </columnFooter>
        <pagefooter>
                <band height="36" splitType="Stretch">
                        <line>
                                <reportelement x="0" y="9" width="626" height="1"/>
                                <graphicelement>
                                        <pen lineWidth="1.5"/>
                                </graphicElement>
                        </line>
                        <textfield>
                                <reportelement style="Page_Footer" x="521" y="13" width="80" height="20"/>
                                <textelement textAlignment="Right"/>
                                <textfieldexpression class="java.lang.String"><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
                        </textField>
                        <textfield evaluationTime="Report">
                                <reportelement style="Page_Footer" x="601" y="13" width="24" height="20"/>
                                <textElement/>
                                <textfieldexpression class="java.lang.String"><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
                        </textField>
                        <statictext>
                                <reportelement style="Page_Footer" x="0" y="13" width="67" height="15"/>
                                <textElement/>
                                <text><![CDATA[Report begin: ]]></text>
                        </staticText>
                        <statictext>
                                <reportelement style="Page_Footer" x="193" y="13" width="60" height="14"/>
                                <textElement/>
                                <text><![CDATA[Report end: ]]></text>
                        </staticText>
                        <textfield evaluationTime="Page">
                                <reportelement style="Report_Subtitle" x="67" y="13" width="126" height="14"/>
                                <textElement/>
                                <textfieldexpression class="java.util.Date"><![CDATA[$P{startDate}]]></textFieldExpression>
                        </textField>
                        <textfield evaluationTime="Page">
                                <reportelement style="Report_Subtitle" x="253" y="13" width="131" height="14"/>
                                <textElement/>
                                <textfieldexpression class="java.util.Date"><![CDATA[$P{endDate}]]></textFieldExpression>
                        </textField>
                </band>
        </pageFooter>
        <summary>
                <band height="42" splitType="Stretch"/>
        </summary>
        <nodata>
                <band height="50">
                        <statictext>
                                <reportelement x="237" y="15" width="154" height="20"/>
                                <textElement/>
                                <text><![CDATA[There is no data for this report]]></text>
                        </staticText>
                </band>
        </noData>
</jasperReport>

The subreport file:
/opt/opennms/etc/report-templates/subreports/PeakCPU_subreport.jrxml

My Ideas ,Linux related Links, etc..

Friday, November 08, 2013

Auto-compile Jasper subreports in OpenNMS

No comments:

About Me