| blob | 84cad9a8a1ef10e82d28b5e602ae1f4c6c815801 |
1 <?xml version="1.0" encoding="UTF-8"?>
2 <!-- Generated by DataVision version 1.0.0 -->
3 <!-- http://datavision.sourceforge.net -->
4 <report dtd-version="1.2" name="WRMS Requester Activity" title="WRMS Requester Activity" author="Andrew McMillan">
5 <description><![CDATA[Report on who has created new requests for which
6 organisations / systems over a period.]]></description>
7 <bean-scripting-framework default-language="Ruby">
8 <language name="Ruby" class="org.jruby.javasupport.bsf.JRubyEngine"/>
9 </bean-scripting-framework>
10 <paper name="A4" orientation="portrait"/>
11 <field id="0" type="text">
12 <text><![CDATA[Report Default Field Format]]></text>
13 <bounds x="0.0" y="0.0" width="120.0" height="16.0"/>
14 <format font="Times New Roman" size="11.0" bold="false" italic="false" underline="false" wrap="true" align="left" color="0;0;0;255"/>
15 </field>
16 <usercols>
17 <usercol id="1" name="Period_Description"><![CDATA['WRMS Requester Activity from ' || to_char({?2}::timestamp,'D Month YYYY') || ' to ' || to_char({?1}::timestamp,'D Month YYYY')]]></usercol>
18 </usercols>
19 <source>
20 <database driverClassName="org.postgresql.Driver" connInfo="jdbc:postgresql:wrms" name="wrms" username="andrew"/>
21 <query>
22 <join from="public.request.requester_id" relation="=" to="public.usr.user_no"/>
23 <join from="public.usr.org_code" relation="=" to="public.organisation.org_code"/>
24 <join from="public.request.system_code" relation="=" to="public.work_system.system_code"/>
25 <where><![CDATA[{public.request.request_on} BETWEEN {?2} AND {?1}]]></where>
26 </query>
27 </source>
28 <parameters>
29 <parameter id="2" type="date" name="Start date" question="The start date of the reporting period" arity="single"/>
30 <parameter id="1" type="date" name="End_date" question="The last day of the period" arity="single"/>
31 </parameters>
32 <headers>
33 <section height="0.0"/>
34 </headers>
35 <footers>
36 <section height="0.0"/>
37 </footers>
38 <page>
39 <headers>
40 <section height="52.0">
41 <field id="24" type="text">
42 <text><![CDATA[System]]></text>
43 <bounds x="169.0" y="35.0" width="66.0" height="16.0"/>
44 <format size="10.0" bold="true"/>
45 </field>
46 <field id="28" type="text">
47 <text><![CDATA[Requester]]></text>
48 <bounds x="49.0" y="35.0" width="117.0" height="16.0"/>
49 <format size="10.0" bold="true"/>
50 </field>
51 <field id="30" type="text">
52 <text><![CDATA[New]]></text>
53 <bounds x="464.0" y="35.0" width="48.0" height="16.0"/>
54 <format size="10.0" bold="true" align="right"/>
55 </field>
56 <field id="41" type="usercol" value="1">
57 <bounds x="12.0" y="12.0" width="548.0" height="21.0"/>
58 <format size="12.0" bold="true" align="center"/>
59 </field>
60 </section>
61 </headers>
62 <footers>
63 <section height="58.0">
64 <field id="9" type="special" value="page.number">
65 <bounds x="271.0" y="20.0" width="120.0" height="16.0"/>
66 </field>
67 <field id="10" type="text">
68 <text><![CDATA[Page]]></text>
69 <bounds x="228.0" y="20.0" width="40.0" height="16.0"/>
70 <format align="right"/>
71 </field>
72 </section>
73 </footers>
74 </page>
75 <groups>
76 <group groupable-id="public.organisation.org_name" groupable-type="column" sort-order="asc">
77 <headers>
78 <section height="17.0">
79 <field id="34" type="column" value="public.organisation.org_name">
80 <bounds x="41.0" y="1.0" width="490.0" height="16.0"/>
81 <format bold="true"/>
82 </field>
83 </section>
84 </headers>
85 <footers>
86 <section height="24.0">
87 <field id="36" type="special" value="group.count">
88 <bounds x="426.0" y="8.0" width="86.0" height="14.0"/>
89 <format size="9.0" bold="true" wrap="false" align="right"/>
90 <border>
91 <edge location="top"/>
92 <edge location="bottom" number="2" style="dash"/>
93 </border>
94 </field>
95 <field id="43" type="text">
96 <text><![CDATA[----------]]></text>
97 <bounds x="475.0" y="0.0" width="37.0" height="8.0"/>
98 <format size="6.0" bold="true" wrap="false" align="right"/>
99 </field>
100 </section>
101 </footers>
102 </group>
103 <group groupable-id="public.usr.fullname" groupable-type="column" sort-order="asc">
104 <headers>
105 <section height="0.0"/>
106 </headers>
107 <footers>
108 <section height="0.0"/>
109 </footers>
110 </group>
111 <group groupable-id="public.request.system_code" groupable-type="column" sort-order="asc">
112 <headers>
113 <section height="0.0"/>
114 </headers>
115 <footers>
116 <section height="14.0">
117 <field id="29" type="special" value="group.count">
118 <bounds x="469.0" y="0.0" width="43.0" height="14.0"/>
119 <format size="10.0" align="right"/>
120 </field>
121 <field id="27" type="column" value="public.usr.fullname">
122 <bounds x="49.0" y="0.0" width="116.0" height="14.0"/>
123 <format size="9.0"/>
124 </field>
125 <field id="42" type="column" value="public.work_system.system_desc">
126 <bounds x="169.0" y="0.0" width="293.0" height="14.0"/>
127 <format size="9.0"/>
128 </field>
129 </section>
130 </footers>
131 </group>
132 </groups>
133 <details>
134 <section height="0.0"/>
135 </details>
136 </report>