new NXSL class "Event" attributes "source" and "sourceId"
[public/netxms.git] / reports / IP Inventory.jrxml
1 <?xml version="1.0" encoding="UTF-8"?>
2 <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="IP Inventory" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
3 <property name="ireport.zoom" value="1.0"/>
4 <property name="ireport.x" value="0"/>
5 <property name="ireport.y" value="0"/>
6 <queryString language="SQL">
7 <![CDATA[SELECT
8 interfaces.ip_addr AS interfaces_ip_addr,
9 interfaces.ip_netmask AS interfaces_ip_netmask,
10 object_properties.name AS object_properties_name,
11 interfaces.node_id AS interfaces_node_id
12 FROM
13 object_properties
14 INNER JOIN
15 interfaces
16 ON
17 object_properties.object_id = interfaces.node_id
18 ORDER BY
19 interfaces_node_id, interfaces_ip_addr]]>
20 </queryString>
21 <field name="interfaces_ip_addr" class="java.lang.String"/>
22 <field name="interfaces_ip_netmask" class="java.lang.String"/>
23 <field name="object_properties_name" class="java.lang.String"/>
24 <field name="interfaces_node_id" class="java.lang.Integer"/>
25 <group name="interfaces_node_id">
26 <groupExpression><![CDATA[$F{interfaces_node_id}]]></groupExpression>
27 <groupHeader>
28 <band height="20">
29 <textField>
30 <reportElement x="0" y="0" width="555" height="20"/>
31 <textElement>
32 <font size="14" isBold="true"/>
33 </textElement>
34 <textFieldExpression><![CDATA[$F{object_properties_name}]]></textFieldExpression>
35 </textField>
36 </band>
37 </groupHeader>
38 </group>
39 <background>
40 <band splitType="Stretch"/>
41 </background>
42 <detail>
43 <band height="20" splitType="Stretch">
44 <textField>
45 <reportElement x="20" y="0" width="143" height="20"/>
46 <textElement/>
47 <textFieldExpression><![CDATA[$F{interfaces_ip_addr}]]></textFieldExpression>
48 </textField>
49 <textField>
50 <reportElement x="163" y="0" width="143" height="20"/>
51 <textElement/>
52 <textFieldExpression><![CDATA[$F{interfaces_ip_netmask}]]></textFieldExpression>
53 </textField>
54 </band>
55 </detail>
56 <pageFooter>
57 <band height="21">
58 <line>
59 <reportElement x="0" y="0" width="555" height="1"/>
60 </line>
61 <textField pattern="dd/MM/yyyy HH:mm:ss">
62 <reportElement positionType="FixRelativeToBottom" x="0" y="1" width="100" height="20"/>
63 <textElement/>
64 <textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
65 </textField>
66 <textField>
67 <reportElement positionType="FixRelativeToBottom" x="435" y="1" width="80" height="20"/>
68 <textElement textAlignment="Right"/>
69 <textFieldExpression><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
70 </textField>
71 <textField evaluationTime="Report">
72 <reportElement positionType="FixRelativeToBottom" x="515" y="1" width="40" height="20"/>
73 <textElement/>
74 <textFieldExpression><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
75 </textField>
76 </band>
77 </pageFooter>
78 </jasperReport>