Hi Andrew,
Im Using InfoPath 2003 SP1 and Excel 2003 Pro SP2 the xsl is as follows:
<?mso-infoPathSolutionsolutionVersion="1.0.0.18" productVersion="11.0.6357"
PIVersion="1.0.0.0"
href="file:///\\sh-NAS1\shared\Advisors\Advisor%20Visit%20Forms\High%20Balance.xsn"
name="urn:schemas-microsoft-com
ffice:infopath:High-Balance:-myXSD-2007-08-02T13-49-28" ?>
<?mso-applicationprogid="InfoPath.Document"?>
-<my:myFields xml:lang="en-gb">
-<my:VRPG2>
<my
efaultReason>Customer informs default was due to
unemployment</my
efaultReason>
<my:Situation>Recovered Situation</my:Situation>
<my
ayDate xsi:nil="true"/>
<my
ay2Date xsi:nil="true"/>
<my
ayFrequency>Weekly</my
ayFrequency>
<my
ay2Frequency/>
<my
ayDetails>Customer total monthly salary is £2000.00</my
ayDetails>
<my
ay2Details/>
-<my:Benefits>
<my:BenefitAmount xsi:nil="true"/>
<my:BenefitDetails/>
<my:BenefitsDate xsi:nil="true"/>
<my:BenefitsFrequency/>
</my:Benefits>
-<my:Additional_Income>
<my:AdditionalIncome xsi:nil="true"/>
<my:field133/>
<my:field134/>
<my:AdditionalDetails/>
<my:AdditionalDate xsi:nil="true"/>
<my:AdditionalFreq/>
</my:Additional_Income>
<my:SOMTV>110</my:SOMTV>
<my:SOMTax>120</my:SOMTax>
<my:SOMWater>130</my:SOMWater>
<my:SOMGas>140</my:SOMGas>
<my:SOMElec>150</my:SOMElec>
<my:SOMInsure>160</my:SOMInsure>
<my:SOMPhone>170</my:SOMPhone>
<my:SOMHouse>180</my:SOMHouse>
<my:SOMChild>190</my:SOMChild>
<my:SOMTravel>200</my:SOMTravel>
<my:SOMMorg>210</my:SOMMorg>
<my:SOMFines>0</my:SOMFines>
<my:SOMLoans>0</my:SOMLoans>
<my:ArrearsTV>0</my:ArrearsTV>
<my:ArrearsTax>0</my:ArrearsTax>
<my:ArrearsWater>0</my:ArrearsWater>
<my:ArrearsGas>0</my:ArrearsGas>
<my:ArrearsElec>0</my:ArrearsElec>
<my:ArrearsInsure>0</my:ArrearsInsure>
<my:ArrearsPhone>0</my:ArrearsPhone>
<my:ArrearsHouse>0</my:ArrearsHouse>
<my:ArrearsChild>0</my:ArrearsChild>
<my:ArrearsTravel>0</my:ArrearsTravel>
<my:ArrearsMorg>0</my:ArrearsMorg>
<my:ArrearsFines>0</my:ArrearsFines>
<my:ArrearsLLoans>0</my:ArrearsLLoans>
<my:BalanceRent>0</my:BalanceRent>
<my:BalanceFines>0</my:BalanceFines>
<my:BalanceLoans>0</my:BalanceLoans>
-<my:Additional_Expenditure>
<my:AddEx/>
<my:AddExAmount xsi:nil="true"/>
<my:AddExArrears xsi:nil="true"/>
<my:AddExBalance xsi:nil="true"/>
</my:Additional_Expenditure>
-<my:Credit_Cards>
<my:CCName>MasterCard</my:CCName>
<my:CCBalance>4000</my:CCBalance>
<my:CCLimit>6000</my:CCLimit>
<my:CCMinPay>200</my:CCMinPay>
</my:Credit_Cards>
-<my:Bank_Accounts>
<my:BAName/>
<my:BABalance xsi:nil="true"/>
<my:BAOverdraft xsi:nil="true"/>
</my:Bank_Accounts>
<my
ropertyValue xsi:nil="true"/>
<my:Mortgage xsi:nil="true"/>
<my:Equity>0</my:Equity>
-<my:OSL>
<my:OLSName/>
<my:OSLAmount xsi:nil="true"/>
<my:OSLLength/>
<my:OSLPayAmount xsi:nil="true"/>
</my:OSL>
<my:BalanceTotal>4000</my:BalanceTotal>
<my:TotalExpenditure>1960</my:TotalExpenditure>
<my:IncomeTotal>2000</my:IncomeTotal>
<my:AvailableCommitment>40</my:AvailableCommitment>
<my:VehicleValue xsi:nil="true"/>
<my:Savings xsi:nil="true"/>
<my:Investments xsi:nil="true"/>
<my:OtherAssets xsi:nil="true"/>
<my:RaiseArrearsDate>2007-09-07</my:RaiseArrearsDate>
<my:RaiseFinanceDate>2007-09-28</my:RaiseFinanceDate>
<my:FutureIncomeDate xsi:nil="true"/>
<my:RaiseArrearsAmount>2000</my:RaiseArrearsAmount>
<my:RaiseFinanceAmount>500</my:RaiseFinanceAmount>
<my:FutureIncomeAmount xsi:nil="true"/>
<my:HowRaiseArrears>Customer has made a debit card payment for the full
arrears.</my:HowRaiseArrears>
<my:RaiseFinance>Customer is to pay the monthly instalment to client direct
on the instalment date.</my:RaiseFinance>
<my:FutureIncomeDetails/>
<my:CCJs>No</my:CCJs>
<my:ChargingOrder>No</my:ChargingOrder>
<my:AOE>No</my:AOE>
<my:CCJDetails/>
<my:ChargingOrderDetails/>
<my:AOEDetails/>
<my:IncomeMonth>2000</my:IncomeMonth>
<my:IncomeMonth2>0</my:IncomeMonth2>
<my:MortgageLender/>
</my:VRPG2>
-<my:VisitReport>
<my:Recommendations>Fully Paid</my:Recommendations>
<my:Report>Contact made with customer on 07123456789 and appointment was
arranged. Customer advised was able to pay the arrears and we received
£2000.00 by debit card 06/09/07. Our advisor attended the address to discuss
the customers financial situation. Customer informed default was due to
previous unemployment. Customer had been living at file address with his son,
and is to move to the following address 21/08/07- * ******** ***** *********
**** ******* **** **** The rent re payment amount stated on the statement of
means is for the customers new address. Customer is now back in employment
and is a self employed engineer. The statement of means information confirms
the amounts customer was paying for utilities at the sons address, the
amounts may be subject to change at the new address. The amount stated for
car expense of £160.00 consists of £160.00 for the monthly re payment for the
agreement, so the loan may have been for the purchase of a vehicle, but
customer would not confirm this. The customer is to call the client on the
next instalment date to pay the next instalment 24/09/07. Customer is to pay
the remaining instalments to the client by standing order. ****</my:Report>
<my:Risk>Low Risk</my:Risk>
<my:Risk_Reason/>
</my:VisitReport>
-<my:Input>
<my:Logo></my:Logo>
-<my:Account_Information>
<my:CCM>96300</my:CCM>
<my:AgreementNo>2245925</my:AgreementNo>
<my:Client>Alliance + Leicester</my:Client>
</my:Account_Information>
-<my:Appointment_Details>
<my:AdvisorName>Brendan Lambkin</my:AdvisorName>
<my:VisitWithName>Customer</my:VisitWithName>
<my:TimeSubmitted>19.00</my:TimeSubmitted>
<my
ateSubmitted>2007-08-20</my
ateSubmitted>
<my:CustomerName>Dan Pearson</my:CustomerName>
<my:Venue>Vehicle</my:Venue>
</my:Appointment_Details>
</my:Input>
-<my:Address>
<my
ebtorAddLineOne/>
<my
ebtorAddLineTwo/>
<my
ebtorAddLineThree/>
<my
ebtorAddLineFour/>
<my
ebtorPostcode/>
</my:Address>
-<my:VRPG1>
-<my:Employment_Details>
<my:EmpPosition>Engineer</my:EmpPosition>
<my:TIEYears>1</my:TIEYears>
<my:TIEMonths>0</my:TIEMonths>
<my
OEAddUnknown>false</my
OEAddUnknown>
<my
OEAddLineOne>Self Employed</my
OEAddLineOne>
<my
OEAddLineTwo>File Address</my
OEAddLineTwo>
<my
OEAddLineThree/>
<my
OEAddLineFour/>
<my
OEPostcode/>
</my:Employment_Details>
-<my:Customer_Details>
<my:HomePhone>01234567890</my:HomePhone>
<my:WorkPhone xsi:nil="true"/>
<my:MobilePhone>07123456789</my:MobilePhone>
<my:BestContactTime xsi:nil="true"/>
<my:EMailAddress/>
<my:MaritalStatus/>
<my
ependants/>
<my:HomeAddressConf>true</my:HomeAddressConf>
<my:YearsAtAddress>0</my:YearsAtAddress>
<my:MonthsAtAddress>4</my:MonthsAtAddress>
<my
ropertyStatus/>
<my:Interior/>
<my:Exterior>Average</my:Exterior>
<my:Neighbourhood>Average</my:Neighbourhood>
</my:Customer_Details>
</my:VRPG1>
<my:Employee/>
<my:TimeDateSubmitted>2007-09-21T09:07:02</my:TimeDateSubmitted>
<my:group1/>
</my:myFields>
Any help gratefully recieved!
Thanks
Dan
