Document Actions
Aggregation Demo
last modified
2008-06-30 11:11
A BIRT report to accompany the Aggregation powerpoint presentation.
Size 67.1 kB - File type text/xml
Click here to get the file
File contents
<?xml version="1.0" encoding="UTF-8"?>
<!-- Written by Eclipse BIRT 2.0 -->
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.6" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 2.1.2.v20070205-1728 Build <20070205-1728></property>
<property name="units">in</property>
<property name="comments">Copyright (c) 2006 <<Your Company Name here>></property>
<parameters>
<scalar-parameter name="RPReportStartDate" id="122">
<text-property name="helpText">YYYY-MM-dd</text-property>
<property name="valueType">static</property>
<property name="dataType">string</property>
<text-property name="promptText">Enter the report start date</text-property>
<property name="controlType">text-box</property>
<property name="defaultValue">2007-03-01</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="RPReportEndDate" id="123">
<text-property name="helpText">YYYY-MM-dd</text-property>
<property name="valueType">static</property>
<property name="dataType">string</property>
<text-property name="promptText">Enter the report end date</text-property>
<property name="controlType">text-box</property>
<property name="defaultValue">2008-03-30</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<cascading-parameter-group name="BranchLoanOfficerCascadingParameterGroup" id="395">
<property name="promptText">Select the branch and then loan officer</property>
<property name="dataSetMode">multiple</property>
<parameters>
<scalar-parameter name="CRPBranch" id="396">
<property name="valueType">dynamic</property>
<property name="allowNull">false</property>
<property name="controlType">list-box</property>
<property name="dataSetName">Branch RP Data Set</property>
<expression name="valueExpr">row["branch_id"]</expression>
<expression name="labelExpr">row["branch_name"]</expression>
<property name="mustMatch">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="CRPLoanOfficer" id="397">
<property name="valueType">dynamic</property>
<property name="allowNull">false</property>
<property name="controlType">list-box</property>
<property name="dataSetName">Loan Officer RP Data Set</property>
<expression name="valueExpr">row["loan_officer_id"]</expression>
<expression name="labelExpr">row["loan_officer_name"]</expression>
<property name="mustMatch">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
</parameters>
</cascading-parameter-group>
</parameters>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Mifos JDBC Data Source" id="4">
<property name="odaDriverClass">com.mysql.jdbc.Driver</property>
<property name="odaURL">jdbc:mysql://localhost:3306/mifos</property>
<property name="odaUser">root</property>
<encrypted-property name="odaPassword">bXlzcWw=</encrypted-property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Loan Data Set" id="32">
<list-property name="columnHints">
<structure>
<property name="columnName">DISPLAY_NAME</property>
<property name="alias">loan_officer_name</property>
</structure>
<structure>
<property name="columnName">DISPLAY_NAME_2</property>
<property name="alias">center_name</property>
</structure>
<structure>
<property name="columnName">DISPLAY_NAME_3</property>
<property name="alias">group_name</property>
</structure>
<structure>
<property name="columnName">DISPLAY_NAME_4</property>
<property name="alias">client_name</property>
</structure>
<structure>
<property name="columnName">DISPLAY_NAME_5</property>
<property name="alias">branch_name</property>
</structure>
<structure>
<property name="columnName">LOOKUP_NAME</property>
<property name="alias">business_activity</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">loan_officer_name</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">center_name</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">group_name</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">client_name</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">branch_name</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">GLOBAL_CUST_NUM</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">PRD_OFFERING_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">GLOBAL_ACCOUNT_NUM</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">LOAN_AMOUNT</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">INTEREST_RATE</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">NO_OF_INSTALLMENTS</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">DISBURSEMENT_DATE</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">business_activity</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Mifos JDBC Data Source</property>
<property name="cachedRowCount">-1</property>
<list-property name="parameters">
<structure>
<property name="name">DSPLoanOfficerID</property>
<property name="paramName">CRPLoanOfficer</property>
<property name="dataType">any</property>
<property name="position">1</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">DSPReportStartDate</property>
<property name="paramName">RPReportStartDate</property>
<property name="dataType">string</property>
<property name="position">2</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">DSPReportEndDate</property>
<property name="paramName">RPReportEndDate</property>
<property name="dataType">string</property>
<property name="position">3</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">DISPLAY_NAME</property>
<property name="nativeName">DISPLAY_NAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">DISPLAY_NAME_2</property>
<property name="nativeName">DISPLAY_NAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">DISPLAY_NAME_3</property>
<property name="nativeName">DISPLAY_NAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">DISPLAY_NAME_4</property>
<property name="nativeName">DISPLAY_NAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">DISPLAY_NAME_5</property>
<property name="nativeName">DISPLAY_NAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">GLOBAL_CUST_NUM</property>
<property name="nativeName">GLOBAL_CUST_NUM</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">PRD_OFFERING_NAME</property>
<property name="nativeName">PRD_OFFERING_NAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">GLOBAL_ACCOUNT_NUM</property>
<property name="nativeName">GLOBAL_ACCOUNT_NUM</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">LOAN_AMOUNT</property>
<property name="nativeName">LOAN_AMOUNT</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">3</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">INTEREST_RATE</property>
<property name="nativeName">INTEREST_RATE</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">3</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">NO_OF_INSTALLMENTS</property>
<property name="nativeName">NO_OF_INSTALLMENTS</property>
<property name="dataType">integer</property>
<property name="nativeDataType">5</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">DISBURSEMENT_DATE</property>
<property name="nativeName">DISBURSEMENT_DATE</property>
<property name="dataType">date-time</property>
<property name="nativeDataType">91</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">LOOKUP_NAME</property>
<property name="nativeName">LOOKUP_NAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<property name="queryText">SELECT
p.display_name,
ccntr.display_name,
cgrp.display_name,
cmem.display_name,
o.display_name,
cmem.global_cust_num,
po.prd_offering_name,
a.global_account_num,
la.loan_amount,
la.interest_rate,
la.no_of_installments,
la.disbursement_date,
lv.lookup_name
FROM
customer AS ccntr
JOIN customer AS cgrp
ON ccntr.customer_id = cgrp.parent_customer_id
JOIN customer AS cmem
ON cgrp.customer_id = cmem.parent_customer_id
JOIN personnel p
ON cmem.loan_officer_id = p.personnel_id
JOIN office o
ON p.office_id = o.office_id
JOIN account a
ON cmem.customer_id = a.customer_id
JOIN loan_account la
ON a.account_id = la.account_id
JOIN prd_offering po
ON la.prd_offering_id = po.prd_offering_id
LEFT JOIN lookup_value lv
ON la.business_activities_id = lv.lookup_id
WHERE
cmem.status_id = 3 /* active */
AND
a.account_state_id IN (5,9) /* active in good and active in bad standing */
AND
ccntr.loan_officer_id = ?
AND
la.disbursement_date between (SELECT @ReportStartDate := ?)
and (SELECT @ReportEndDate := ?);</property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>DISPLAY_NAME</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>200</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>loan_officer</design:label>
<design:formattingHints>
<design:displaySize>200</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>DISPLAY_NAME</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>200</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>center</design:label>
<design:formattingHints>
<design:displaySize>200</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>DISPLAY_NAME</design:name>
<design:position>3</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>200</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>group_name</design:label>
<design:formattingHints>
<design:displaySize>200</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>DISPLAY_NAME</design:name>
<design:position>4</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>200</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>client</design:label>
<design:formattingHints>
<design:displaySize>200</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>GLOBAL_CUST_NUM</design:name>
<design:position>5</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>100</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>client_system_id</design:label>
<design:formattingHints>
<design:displaySize>100</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>PRD_OFFERING_NAME</design:name>
<design:position>6</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>50</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>product_name</design:label>
<design:formattingHints>
<design:displaySize>50</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>GLOBAL_ACCOUNT_NUM</design:name>
<design:position>7</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>100</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>account_system_id</design:label>
<design:formattingHints>
<design:displaySize>100</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>LOAN_AMOUNT</design:name>
<design:position>8</design:position>
<design:nativeDataTypeCode>3</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>3</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>loan_amount</design:label>
<design:formattingHints>
<design:displaySize>12</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>INTEREST_RATE</design:name>
<design:position>9</design:position>
<design:nativeDataTypeCode>3</design:nativeDataTypeCode>
<design:precision>13</design:precision>
<design:scale>10</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>interest_rate</design:label>
<design:formattingHints>
<design:displaySize>15</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>NO_OF_INSTALLMENTS</design:name>
<design:position>10</design:position>
<design:nativeDataTypeCode>5</design:nativeDataTypeCode>
<design:precision>6</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>no_of_installments</design:label>
<design:formattingHints>
<design:displaySize>6</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>DISBURSEMENT_DATE</design:name>
<design:position>11</design:position>
<design:nativeDataTypeCode>91</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>disbursement_date</design:label>
<design:formattingHints>
<design:displaySize>10</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>LOOKUP_NAME</design:name>
<design:position>12</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>100</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>purpose_of_loan</design:label>
<design:formattingHints>
<design:displaySize>100</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Branch RP Data Set" id="393">
<list-property name="columnHints">
<structure>
<property name="columnName">OFFICE_ID</property>
<property name="alias">branch_id</property>
</structure>
<structure>
<property name="columnName">DISPLAY_NAME</property>
<property name="alias">branch_name</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">branch_id</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">branch_name</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Mifos JDBC Data Source</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">OFFICE_ID</property>
<property name="nativeName">OFFICE_ID</property>
<property name="dataType">integer</property>
<property name="nativeDataType">5</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">DISPLAY_NAME</property>
<property name="nativeName">DISPLAY_NAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<property name="queryText">SELECT
OFFICE_ID,
DISPLAY_NAME
FROM
OFFICE
WHERE
OFFICE_LEVEL_ID = '5' /* BRANCH */
AND
STATUS_ID = '1' /* ACTIVE */
/* AND
IF((SELECT LEVEL_ID FROM PERSONNEL WHERE PERSONNEL_ID = (SELECT @PersonnelID := 14 ))=1,
OFFICE_ID = (SELECT OFFICE_ID FROM PERSONNEL WHERE PERSONNEL_ID = @PersonnelID),1)
*/</property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>OFFICE_ID</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>5</design:nativeDataTypeCode>
<design:precision>6</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>OFFICE_ID</design:label>
<design:formattingHints>
<design:displaySize>6</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>DISPLAY_NAME</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>200</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>DISPLAY_NAME</design:label>
<design:formattingHints>
<design:displaySize>200</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Loan Officer RP Data Set" id="394">
<list-property name="columnHints">
<structure>
<property name="columnName">PERSONNEL_ID</property>
<property name="alias">loan_officer_id</property>
</structure>
<structure>
<property name="columnName">DISPLAY_NAME</property>
<property name="alias">loan_officer_name</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">loan_officer_id</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">loan_officer_name</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Mifos JDBC Data Source</property>
<list-property name="parameters">
<structure>
<property name="name">DSPBranchID</property>
<property name="paramName">CRPBranch</property>
<property name="dataType">any</property>
<property name="position">1</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">PERSONNEL_ID</property>
<property name="nativeName">PERSONNEL_ID</property>
<property name="dataType">integer</property>
<property name="nativeDataType">5</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">DISPLAY_NAME</property>
<property name="nativeName">DISPLAY_NAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<property name="queryText">SELECT
PERSONNEL_ID,
DISPLAY_NAME
FROM
PERSONNEL
WHERE
PERSONNEL_STATUS = 1 /* ACTIVE */
AND
LEVEL_ID = 1 /* LOAN OFFICER */
AND
OFFICE_ID = ?</property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>PERSONNEL_ID</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>5</design:nativeDataTypeCode>
<design:precision>6</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>PERSONNEL_ID</design:label>
<design:formattingHints>
<design:displaySize>6</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>DISPLAY_NAME</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>200</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>DISPLAY_NAME</design:label>
<design:formattingHints>
<design:displaySize>200</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
</data-sets>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<property name="orientation">landscape</property>
<page-header>
<grid id="398">
<property name="fontFamily">"Arial"</property>
<property name="fontSize">small</property>
<property name="width">100%</property>
<column id="399">
<property name="width">4.5in</property>
</column>
<column id="400">
<property name="width">1.1354166667in</property>
</column>
<column id="401">
<property name="width">2.8541666667in</property>
</column>
<row id="402">
<cell id="403">
<property name="colSpan">3</property>
<property name="rowSpan">1</property>
<label id="404">
<property name="fontSize">larger</property>
<property name="fontWeight">bold</property>
<property name="textAlign">center</property>
<text-property name="text">Disbursed Loans Report</text-property>
</label>
</cell>
</row>
<row id="405">
<cell id="406"/>
<cell id="407">
<label id="408">
<property name="fontWeight">bold</property>
<text-property name="text">Loan Officer:</text-property>
</label>
</cell>
<cell id="409">
<data id="410">
<property name="dataSet">Loan Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">loan_officer_name</property>
<expression name="expression">dataSetRow["loan_officer_name"]</expression>
<property name="dataType">any</property>
</structure>
</list-property>
<property name="resultSetColumn">loan_officer_name</property>
</data>
</cell>
</row>
<row id="411">
<cell id="412"/>
<cell id="413">
<label id="414">
<property name="fontWeight">bold</property>
<text-property name="text">Branch:</text-property>
</label>
</cell>
<cell id="415">
<data id="416">
<property name="dataSet">Loan Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">branch_name</property>
<expression name="expression">dataSetRow["branch_name"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="resultSetColumn">branch_name</property>
</data>
</cell>
</row>
<row id="417">
<cell id="418"/>
<cell id="419">
<label id="420">
<property name="fontWeight">bold</property>
<text-property name="text">Report Range:</text-property>
</label>
</cell>
<cell id="421">
<data id="422">
<list-property name="boundDataColumns">
<structure>
<property name="name">report_range</property>
<expression name="expression">params["RPReportStartDate"]+" to "+params["RPReportEndDate"]</expression>
<property name="dataType">any</property>
</structure>
</list-property>
<property name="resultSetColumn">report_range</property>
</data>
</cell>
</row>
<row id="423">
<cell id="424"/>
<cell id="425">
<label id="426">
<property name="fontWeight">bold</property>
<text-property name="text">Report Was Run On:</text-property>
</label>
</cell>
<cell id="427">
<data id="428">
<structure name="dateTimeFormat">
<property name="category">Custom</property>
<property name="pattern">yyyy-MM-dd HH:mm</property>
</structure>
<list-property name="boundDataColumns">
<structure>
<property name="name">data item</property>
<expression name="expression">new Date()</expression>
<property name="dataType">any</property>
</structure>
</list-property>
<property name="resultSetColumn">data item</property>
</data>
</cell>
</row>
</grid>
</page-header>
<page-footer>
<text id="3">
<property name="fontFamily">"Arial"</property>
<property name="fontSize">small</property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property>
</text>
</page-footer>
</simple-master-page>
</page-setup>
<body>
<table id="189">
<property name="fontFamily">"Arial"</property>
<property name="fontSize">small</property>
<property name="width">100%</property>
<property name="dataSet">Loan Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">loan_officer_name</property>
<expression name="expression">dataSetRow["loan_officer_name"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">center_name</property>
<expression name="expression">dataSetRow["center_name"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">group_name</property>
<expression name="expression">dataSetRow["group_name"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">client_name</property>
<expression name="expression">dataSetRow["client_name"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">branch_name</property>
<expression name="expression">dataSetRow["branch_name"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">GLOBAL_CUST_NUM</property>
<expression name="expression">dataSetRow["GLOBAL_CUST_NUM"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">PRD_OFFERING_NAME</property>
<expression name="expression">dataSetRow["PRD_OFFERING_NAME"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">GLOBAL_ACCOUNT_NUM</property>
<expression name="expression">dataSetRow["GLOBAL_ACCOUNT_NUM"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">LOAN_AMOUNT</property>
<expression name="expression">dataSetRow["LOAN_AMOUNT"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">INTEREST_RATE</property>
<expression name="expression">dataSetRow["INTEREST_RATE"]+"%"</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">NO_OF_INSTALLMENTS</property>
<expression name="expression">dataSetRow["NO_OF_INSTALLMENTS"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">DISBURSEMENT_DATE</property>
<expression name="expression">dataSetRow["DISBURSEMENT_DATE"]</expression>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="name">business_activity</property>
<expression name="expression">dataSetRow["business_activity"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CenterLoanTotal</property>
<expression name="expression">Total.sum(dataSetRow["LOAN_AMOUNT"])</expression>
<property name="dataType">any</property>
<property name="aggregateOn">CenterNameTableGroup</property>
</structure>
<structure>
<property name="name">GrandLoanTotal</property>
<expression name="expression">Total.sum(dataSetRow["LOAN_AMOUNT"])</expression>
<property name="dataType">any</property>
</structure>
<structure>
<property name="name">CenterLT</property>
<expression name="expression">row["CenterLoanTotal"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">GrandLT</property>
<expression name="expression">row["GrandLoanTotal"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">GroupLoanTotal</property>
<expression name="expression">Total.sum(dataSetRow["LOAN_AMOUNT"])</expression>
<property name="dataType">any</property>
<property name="aggregateOn">GroupNameTableGroup</property>
</structure>
<structure>
<property name="name">GroupLT</property>
<expression name="expression">row["GroupLoanTotal"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">GroupClientTotal</property>
<expression name="expression">Total.count()</expression>
<property name="dataType">any</property>
<property name="aggregateOn">GroupNameTableGroup</property>
</structure>
<structure>
<property name="name">CenterClientTotal</property>
<expression name="expression">Total.count()</expression>
<property name="dataType">any</property>
<property name="aggregateOn">CenterNameTableGroup</property>
</structure>
<structure>
<property name="name">GrandClientTotal</property>
<expression name="expression">Total.count()</expression>
<property name="dataType">any</property>
</structure>
<structure>
<property name="name">GroupCT</property>
<expression name="expression">row["GroupClientTotal"]</expression>
<property name="dataType">any</property>
</structure>
<structure>
<property name="name">CenterCT</property>
<expression name="expression">row["CenterClientTotal"]</expression>
<property name="dataType">any</property>
</structure>
<structure>
<property name="name">GrandCT</property>
<expression name="expression">row["GrandClientTotal"]</expression>
<property name="dataType">any</property>
</structure>
<structure>
<property name="name">GroupLoanSum</property>
<expression name="expression">Total.sum(dataSetRow["LOAN_AMOUNT"])</expression>
<property name="dataType">any</property>
<property name="aggregateOn">GroupNameTableGroup</property>
</structure>
<structure>
<property name="name">CenterLoanSum</property>
<expression name="expression">Total.sum(dataSetRow["LOAN_AMOUNT"])</expression>
<property name="dataType">any</property>
<property name="aggregateOn">CenterNameTableGroup</property>
</structure>
<structure>
<property name="name">GrandLoanSum</property>
<expression name="expression">Total.sum(dataSetRow["LOAN_AMOUNT"])</expression>
<property name="dataType">any</property>
</structure>
</list-property>
<column id="259">
<property name="width">8%</property>
</column>
<column id="260">
<property name="width">8%</property>
</column>
<column id="261">
<property name="width">20%</property>
</column>
<column id="264"/>
<column id="265"/>
<column id="266"/>
<column id="267"/>
<column id="268"/>
<column id="269"/>
<column id="270"/>
<header>
<row id="190">
<property name="fontWeight">bold</property>
<cell id="193">
<label id="194">
<text-property name="text">Center</text-property>
</label>
</cell>
<cell id="195">
<label id="196">
<text-property name="text">Group</text-property>
</label>
</cell>
<cell id="197">
<label id="198">
<text-property name="text">Client</text-property>
</label>
</cell>
<cell id="203">
<label id="204">
<text-property name="text">Product</text-property>
</label>
</cell>
<cell id="205">
<label id="206">
<text-property name="text">ID</text-property>
</label>
</cell>
<cell id="207">
<label id="208">
<property name="textAlign">right</property>
<text-property name="text">Amount</text-property>
</label>
</cell>
<cell id="209">
<label id="210">
<property name="textAlign">right</property>
<text-property name="text">Int. Rate</text-property>
</label>
</cell>
<cell id="211">
<label id="212">
<property name="textAlign">right</property>
<text-property name="text">No.</text-property>
</label>
</cell>
<cell id="213">
<label id="214">
<property name="textAlign">right</property>
<text-property name="text">Disb. Date</text-property>
</label>
</cell>
<cell id="215">
<label id="216">
<text-property name="text">Business</text-property>
</label>
</cell>
</row>
</header>
<group id="353">
<property name="groupName">CenterNameTableGroup</property>
<property name="interval">none</property>
<property name="sortDirection">asc</property>
<expression name="keyExpr">row["center_name"]</expression>
<property name="repeatHeader">true</property>
<property name="hideDetail">false</property>
<property name="pageBreakAfter">auto</property>
<property name="pageBreakBefore">auto</property>
<header>
<row id="354">
<cell id="355">
<property name="colSpan">3</property>
<property name="rowSpan">1</property>
<data id="376">
<property name="fontWeight">bold</property>
<property name="resultSetColumn">center_name</property>
</data>
</cell>
<cell id="358"/>
<cell id="359"/>
<cell id="360"/>
<cell id="361"/>
<cell id="362"/>
<cell id="363"/>
<cell id="364"/>
</row>
</header>
<footer>
<row id="365">
<cell id="366">
<property name="colSpan">2</property>
<property name="rowSpan">1</property>
<label id="378">
<property name="textAlign">left</property>
<text-property name="text">Center Totals</text-property>
</label>
</cell>
<cell id="368"/>
<cell id="369">
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">double</property>
<property name="borderBottomWidth">thick</property>
<data id="389">
<property name="resultSetColumn">CenterCT</property>
</data>
</cell>
<cell id="370"/>
<cell id="371">
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">double</property>
<property name="borderBottomWidth">thick</property>
<data id="384">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">#,##0.000</property>
</structure>
<property name="textAlign">right</property>
<property name="resultSetColumn">CenterLT</property>
</data>
</cell>
<cell id="372"/>
<cell id="373"/>
<cell id="374"/>
<cell id="375"/>
</row>
</footer>
</group>
<group id="305">
<property name="groupName">GroupNameTableGroup</property>
<property name="interval">none</property>
<property name="sortDirection">asc</property>
<expression name="keyExpr">row["group_name"]</expression>
<property name="repeatHeader">true</property>
<property name="hideDetail">false</property>
<property name="pageBreakAfter">auto</property>
<property name="pageBreakBefore">auto</property>
<header>
<row id="306">
<cell id="307"/>
<cell id="308">
<property name="colSpan">2</property>
<property name="rowSpan">1</property>
<data id="328">
<property name="fontWeight">bold</property>
<property name="resultSetColumn">group_name</property>
</data>
</cell>
<cell id="310"/>
<cell id="311"/>
<cell id="312"/>
<cell id="313"/>
<cell id="314"/>
<cell id="315"/>
<cell id="316"/>
</row>
</header>
<footer>
<row id="317">
<cell id="318"/>
<cell id="319">
<property name="colSpan">2</property>
<property name="rowSpan">1</property>
<label id="377">
<property name="textAlign">left</property>
<text-property name="text">Group Totals</text-property>
</label>
</cell>
<cell id="321">
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<data id="388">
<property name="resultSetColumn">GroupCT</property>
</data>
</cell>
<cell id="322">
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
</cell>
<cell id="323">
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<data id="387">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">#,##0.000</property>
</structure>
<property name="textAlign">right</property>
<property name="resultSetColumn">GroupLT</property>
</data>
</cell>
<cell id="324">
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
</cell>
<cell id="325">
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
</cell>
<cell id="326">
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
</cell>
<cell id="327">
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
</cell>
</row>
</footer>
</group>
<detail>
<row id="217">
<cell id="220"/>
<cell id="222"/>
<cell id="224">
<data id="225">
<property name="resultSetColumn">client_name</property>
</data>
</cell>
<cell id="230">
<data id="231">
<property name="resultSetColumn">PRD_OFFERING_NAME</property>
</data>
</cell>
<cell id="232">
<data id="233">
<property name="resultSetColumn">GLOBAL_ACCOUNT_NUM</property>
</data>
</cell>
<cell id="234">
<data id="235">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">#,##0.000</property>
</structure>
<property name="textAlign">right</property>
<property name="resultSetColumn">LOAN_AMOUNT</property>
</data>
</cell>
<cell id="236">
<data id="237">
<property name="textAlign">right</property>
<property name="resultSetColumn">INTEREST_RATE</property>
</data>
</cell>
<cell id="238">
<data id="239">
<property name="textAlign">right</property>
<property name="resultSetColumn">NO_OF_INSTALLMENTS</property>
</data>
</cell>
<cell id="240">
<data id="241">
<structure name="dateTimeFormat">
<property name="category">Custom</property>
<property name="pattern">yyyy-MM-dd</property>
</structure>
<property name="textAlign">right</property>
<property name="resultSetColumn">DISBURSEMENT_DATE</property>
</data>
</cell>
<cell id="242">
<data id="243">
<property name="resultSetColumn">business_activity</property>
</data>
</cell>
</row>
</detail>
<footer>
<row id="244">
<cell id="246">
<property name="colSpan">2</property>
<property name="rowSpan">1</property>
<label id="386">
<property name="textAlign">left</property>
<text-property name="text">Grand Totals</text-property>
</label>
</cell>
<cell id="248"/>
<cell id="251">
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">double</property>
<property name="borderBottomWidth">thick</property>
<data id="390">
<property name="resultSetColumn">GrandCT</property>
</data>
</cell>
<cell id="252"/>
<cell id="253">
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">double</property>
<property name="borderBottomWidth">thick</property>
<data id="385">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">#,##0.000</property>
</structure>
<property name="textAlign">right</property>
<property name="resultSetColumn">GrandLT</property>
</data>
</cell>
<cell id="254"/>
<cell id="255"/>
<cell id="256"/>
<cell id="257"/>
</row>
</footer>
</table>
</body>
</report>