*** I am using IE 7 on an XP machine.
I am developing a couple of Content Management type systems for a company. Unfortunately they do not want to use any server side applications such as PHP or ASP or ColdFusion (personal favourite) and they require MS Access as the frontend/backend simply because that is what their employees have.
The basic idea is to change from EXCEL to ACCESS.
ID - Name - Phone - CloseDate - NumberOfServices - etc..
I have created and populated a single flat-file database, with one table named Corporate, and the basic fields.
1. MAIN VIEW -- A customer overview - using a Pivot Table to represent ALL customers with ALL fields -- just like a spreadsheet would look, as that is what they are used to.
2. SECONDARY VIEW -- A customer detail view - just a drill down view of each individual customer record -- a form view with each field layed out for editing and printing.
So, I have created both Data Access Pages, and they appear to work fine WITHIN access.
CODE FOR OVERVIEW (Pivot Table) DATA ACCESS PAGE (Sorry I didn't clean the code up first):
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:x =
"urn:schemas-microsoft-com:office:excel" xmlns:a =
"urn:schemas-microsoft-com:office:access" xmlns:dt =
"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"><HEAD><TITLE>Corporate</TITLE><LINK
href="Corporate_files/filelist.xml" type=text/xml rel=File-List>
<META content=Access.Application name=ProgId>
<META name=VBSForEventHandlers VALUE="TRUE">
<META http-equiv=Content-Type content="text/html; charset=windows-1252">
<META content=10.00.3420 name=DesignerVersion>
<META content="HTML 4.0" name=vs_targetSchema>
<OBJECT id=MSODSC tabIndex=-1
classid=CLSID:0002E553-0000-0000-C000-000000000046><PARAM NAME="XMLData" VALUE="<xml xmlns:a="urn:schemas-microsoft-com:office:access">
<a:DataSourceControl>
<a:OWCVersion>10.0.0.5605 </a:OWCVersion>
<a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Shop Database Development\Corporate\Corporate.mdb;Mode=Share Deny None;Extended Properties="";Persist Security Info=False;Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=0;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False</a:ConnectionString>
<a:MaxRecords>10000</a:MaxRecords>
<a:GridX>10</a:GridX>
<a:GridY>10</a:GridY>
<a:OfflineType>2</a:OfflineType>
<a:XMLLocation>0</a:XMLLocation>
<a:XMLDataTarget></a:XMLDataTarget>
<a:ConnectionFile></a:ConnectionFile>
<a:ElementExtension>
<a:ElementID>PivotTable3</a:ElementID>
<a:ConsumesRecordset/>
</a:ElementExtension>
<a:GroupLevel>
<a:RecordSource>Corporate</a:RecordSource>
<a:DefaultSort></a:DefaultSort>
<a:HeaderElementId>HeaderCorporate</a:HeaderElementId>
<a:FooterElementId></a:FooterElementId>
<a:CaptionElementId>CaptionCorporate</a:CaptionElementId>
<a:RecordNavigationElementId></a:RecordNavigationElementId>
<a:DataPageSize>1</a:DataPageSize>
<a:GroupFilterControl></a:GroupFilterControl>
</a:GroupLevel>
<a:Datamodel a:version="0816">
<a:SchemaRowsource a:id="Corporate" a:type="dscTable">
<a:SchemaField a:id="Warehouse" a:datatype="2" a:size="0"/>
<a:SchemaField a:id="SalesRep" a:datatype="130" a:size="50"/>
<a:SchemaField a:id="CustomerStatus" a:datatype="130" a:size="50"/>
<a:SchemaField a:id="CustomerType" a:datatype="130" a:size="50"/>
<a:SchemaField a:id="CustomerName" a:datatype="130" a:size="50"/>
<a:SchemaField a:id="ContactName" a:datatype="130" a:size="50"/>
<a:SchemaField a:id="ContactNumber" a:datatype="3" a:size="0"/>
<a:SchemaField a:id="ContactEmail" a:datatype="130" a:size="50"/>
<a:SchemaField a:id="OpportunityName" a:datatype="130" a:size="50"/>
<a:SchemaField a:id="NumberServices" a:datatype="2" a:size="0"/>
<a:SchemaField a:id="PartnerName" a:datatype="130" a:size="50"/>
<a:SchemaField a:id="ExpCloseDate" a:datatype="7" a:size="0"/>
<a:SchemaField a:id="SaleProbability" a:datatype="2" a:size="0"/>
<a:SchemaField a:id="ExpectedGP" a:datatype="2" a:size="0"/>
<a:SchemaField a:id="ProbabilityGP" a:datatype="2" a:size="0"/>
<a:SchemaField a:id="Notes" a:datatype="203" a:size="0"/>
</a:SchemaRowsource>
<a:RecordsetDef a:id="Corporate">
<a:PageField a:id="Notes"/>
<a:PageField a:id="Warehouse"/>
<a:PageField a:id="SalesRep"/>
<a:PageField a:id="CustomerStatus"/>
<a:PageField a:id="CustomerType"/>
<a:PageField a:id="CustomerName"/>
<a:PageField a:id="ContactName"/>
<a:PageField a:id="ContactNumber"/>
<a:PageField a:id="ContactEmail"/>
<a:PageField a:id="OpportunityName"/>
<a:PageField a:id="NumberServices"/>
<a:PageField a:id="PartnerName"/>
<a:PageField a:id="ExpCloseDate"/>
<a:PageField a:id="SaleProbability"/>
<a:PageField a:id="ExpectedGP"/>
<a:PageField a:id="ProbabilityGP"/>
</a:RecordsetDef>
</a:Datamodel>
</a:DataSourceControl>
</xml>"></OBJECT>
<META content="MSHTML 6.00.5700.6" name=GENERATOR>
<STYLE id=MSODAPDEFAULTS type=text/css>.MSTheme-Label {
BORDER-RIGHT: 0px; PADDING-RIGHT: 3px; BORDER-TOP: 0px; PADDING-LEFT: 3px; FONT-SIZE: 8pt; OVERFLOW: visible; BORDER-LEFT: 0px; WIDTH: 2.539cm; BORDER-BOTTOM: 0px; FONT-FAMILY: Tahoma; HEIGHT: 0.396cm; TEXT-ALIGN: left
}
.MsoTextbox {
PADDING-RIGHT: 3px; PADDING-LEFT: 3px; FONT-SIZE: 8pt; OVERFLOW: hidden; WIDTH: 2.539cm; FONT-FAMILY: Tahoma; HEIGHT: 0.502cm
}
.MsoBoundSpan {
BORDER-RIGHT: 0px; PADDING-RIGHT: 3px; BORDER-TOP: 0px; PADDING-LEFT: 3px; FONT-SIZE: 8pt; OVERFLOW: hidden; BORDER-LEFT: 0px; BORDER-BOTTOM: 0px; FONT-FAMILY: Tahoma; TEXT-ALIGN: left
}
.MsoHyperlinkDisplayText {
BORDER-RIGHT: 0px; PADDING-RIGHT: 3px; BORDER-TOP: 0px; PADDING-LEFT: 3px; FONT-SIZE: 8pt; OVERFLOW: hidden; BORDER-LEFT: 0px; CURSOR: hand; BORDER-BOTTOM: 0px; FONT-FAMILY: Tahoma; TEXT-ALIGN: left
}
.Mso2dSection {
LEFT: 0px; BEHAVIOR: url(#DEFAULT#Mso2dSection); OVERFLOW: hidden; POSITION: relative; TOP: 0px; BACKGROUND-COLOR: transparent
}
.Mso2dSectionBanner {
PADDING-RIGHT: 4px; DISPLAY: none; PADDING-LEFT: 4px; FONT-WEIGHT: normal; FONT-SIZE: 8pt; LEFT: 0px; BEHAVIOR: url(#DEFAULT#Mso2dSectionBanner); OVERFLOW: visible; PADDING-TOP: 2px; FONT-FAMILY: Tahoma; TOP: 0px; HEIGHT: 0.507cm; BACKGROUND-COLOR: buttonface
}
.MsoRectangle {
BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; OVERFLOW: hidden; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid
}
.MsoTitle {
DISPLAY: none; FONT-WEIGHT: normal; COLOR: inactivecaptiontext
}
.MsoExpandCollapse {
CURSOR: hand
}
.MsoNavContainer {
BORDER-RIGHT: gainsboro 1px solid; BORDER-TOP: gainsboro 1px solid; Z-INDEX: -1; BORDER-LEFT: gainsboro 1px solid; CURSOR: hand; BORDER-BOTTOM: gainsboro 1px solid; HEIGHT: 25px; BACKGROUND-COLOR: gainsboro
}
.MsoNavButton {
BORDER-RIGHT: gainsboro 1px solid; BORDER-TOP: gainsboro 1px solid; BORDER-LEFT: gainsboro 1px solid; CURSOR: auto; BORDER-BOTTOM: gainsboro 1px solid; BACKGROUND-REPEAT: no-repeat
}
.MsoNavButtonMouseOver {
BORDER-RIGHT: highlight 1px solid; BORDER-TOP: highlight 1px solid; BORDER-LEFT: highlight 1px solid; BORDER-BOTTOM: highlight 1px solid; BACKGROUND-COLOR: buttonhighlight
}
.MsoNavToggleButtonMouseOver {
BORDER-RIGHT: buttonshadow 1px solid; BORDER-TOP: buttonshadow 1px solid; BORDER-LEFT: buttonshadow 1px solid; BORDER-BOTTOM: buttonshadow 1px solid; BACKGROUND-REPEAT: no-repeat; BACKGROUND-COLOR: buttonshadow
}
.MsoNavButtonMouseDown {
BORDER-RIGHT: buttonshadow 1px solid; BORDER-TOP: buttonshadow 1px solid; BORDER-LEFT: buttonshadow 1px solid; CURSOR: hand; BORDER-BOTTOM: buttonshadow 1px solid; BACKGROUND-COLOR: buttonshadow
}
.MsoNavRecordsetLabel {
BORDER-RIGHT: gainsboro 1px solid; BORDER-TOP: gainsboro 1px solid; PADDING-LEFT: 0px; FONT-SIZE: 8pt; OVERFLOW: hidden; BORDER-LEFT: gainsboro 1px solid; WIDTH: 100%; CURSOR: default; PADDING-TOP: 0px; BORDER-BOTTOM: gainsboro 1px solid; FONT-FAMILY: Tahoma; POSITION: relative
}
.MsoRecordSelector {
BORDER-RIGHT: buttonshadow 1px solid; BORDER-TOP: buttonshadow 1px solid; OVERFLOW: hidden; BORDER-LEFT: buttonshadow 1px solid; BORDER-BOTTOM: buttonshadow 1px solid; HEIGHT: 100%; BACKGROUND-COLOR: gainsboro
}
.MsoRecordSelectorCurrent {
BACKGROUND-POSITION: 1px 0px; BACKGROUND-IMAGE: url(owc://GIF/#11240); BACKGROUND-REPEAT: no-repeat
}
.MsoRecordSelectorSelectedImage {
BACKGROUND-POSITION: 1px 0px; BACKGROUND-IMAGE: url(owc://GIF/#11241); BACKGROUND-REPEAT: no-repeat
}
.MsoRecordSelectorSelected {
BORDER-RIGHT: buttonshadow 1px solid; BORDER-TOP: buttonshadow 1px solid; LEFT: 0px; OVERFLOW: hidden; BORDER-LEFT: buttonshadow 1px solid; BORDER-BOTTOM: buttonshadow 1px solid; TOP: 0px; HEIGHT: 100%; BACKGROUND-COLOR: buttonshadow
}
.MsoRecordSelectorDirtyCurrent {
BACKGROUND-POSITION: -1px 0px; BACKGROUND-IMAGE: url(owc://GIF/#11242); BACKGROUND-REPEAT: no-repeat
}
.MsoRecordSelectorDirty {
BACKGROUND-POSITION: -1px 0px; BACKGROUND-IMAGE: url(owc://GIF/#11245); BACKGROUND-REPEAT: no-repeat
}
.MsoRecordSelectorTransparent {
LEFT: 0px; OVERFLOW: hidden; TOP: 0px
}
HR {
COLOR: black
}
SELECT {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
INPUT {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
BODY {
FONT-SIZE: 10pt; FONT-FAMILY: Tahoma
}
MARQUEE {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
LEGEND {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
BUTTON {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
TEXTAREA {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
</STYLE>
<script language=Javascript id=MSODSC_Validation>
validateBrowser();
function validateBrowser() {
strVers=navigator.appVersion
strName=navigator.appName
strPlat=navigator.platform
intIndex1=strVers.indexOf("MSIE");
intIndex1=intIndex1+5
intIndex2=strVers.lastIndexOf(";");
intVer=strVers.substring(intIndex1, intIndex2)
intVer=parseInt(intVer)
if (strName=="Microsoft Internet Explorer" && strPlat=="Win32" && intVer>="5") {
validateOWC();
}
else {
strMsgGetIE="<TABLE cellSpacing=0 cellPadding=0 width='95%' border=0 height='8'><TR>"
strMsgGetIE+="<TD bgColor='#336699' height=25 width=15> </TD><TD bgColor='#666666' width=500px><FONT face=Tahoma "
strMsgGetIE+="size=4 color=white><b> Data Access Page Notification</B></FONT></TD></TR>"
strMsgGetIE+="<TR><TD bgColor='#cccccc' width=15> </TD><TD bgColor='#cccccc' width=500px><BR>"
strMsgGetIE+="<p><font face='Tahoma' size='2'>"
strMsgGetIE+="This page requires Windows IE 5.0 or higher.</p>"
strMsgGetIE+="<a href='http://www.microsoft.com/isapi/redir.dll?Prd=Office&Sbp=Access&Pver=10&Ar=DPdesigner&Sba=IEhome&Plcid=1033'><p align='center'>"
strMsgGetIE+="Click here to install the latest version of Internet Explorer.</a></font></p><br></TD></TR></TABLE>"
document.write(strMsgGetIE)
}
}
function validateOWC() {
if (MSODSC.object==null) {
strMsgGetOWC="<TABLE width='95%' cellpadding=0 cellspacing=0 border=0 height='8'>"
strMsgGetOWC+="<TR><TD bgColor='#336699' height=25 width=15> </TD><TD bgColor='#666666' width=500px>"
strMsgGetOWC+="<FONT face=Tahoma color=white size=4><B> "
strMsgGetOWC+="Data Access Page Notification</B></FONT></TD></TR><TR><TD bgColor='#cccccc' width=15> </TD>"
strMsgGetOWC+="<TD bgColor='#cccccc' width='500px'><BR>"
strMsgGetOWC+="<p><font face='Tahoma' size='2'>This page requires the Microsoft Office Web Components.</p>"
strMsgGetOWC+="</font><p><font face='Tahoma' size='2'>See the <a HRef='http://r.office.microsoft.com/r/rlidmsowcpub?clid=1033&p1=Microsoft Access&HelpLCID=1033'>Microsoft Office Web site</a> for more information. "
strMsgGetOWC+="</font></p><BR></TD></TR></TABLE>"
document.write(strMsgGetOWC)
}
}
</SCRIPT>
<!--[if gte mso 9]><xml>
<o:DocumentProperties>
<o:Author>Michael Gallagher</o:Author>
<o:LastAuthor>Michael Gallagher</o:LastAuthor>
<o:Revision>3</o:Revision>
<o:TotalTime>63</o:TotalTime>
<o:Created>2007-06-07T22:44:57Z</o:Created>
<o:LastSaved>2007-06-08T01:19:50Z</o:LastSaved>
<o:Company>-</o:Company>
<o:Version>11.5606</o:Version>
</o:DocumentProperties>
</xml><![endif]--></HEAD>
<BODY style="OVERFLOW: auto" vLink=#800080 link=#0000ff>
<DIV class=Mso2dSectionBanner id=CaptionCorporateBanner
style="MARGIN-LEFT: 0px; WIDTH: 25.4cm" tabIndex=-1><SPAN
id=CaptionCorporateBannerCaption>Caption: Corporate</SPAN></DIV>
<DIV class=Mso2dSection id=CaptionCorporate
style="FONT-WEIGHT: bold; VISIBILITY: hidden; MARGIN-LEFT: 0px; WIDTH: 25.4cm; COLOR: white; HEIGHT: 2.09cm; BACKGROUND-COLOR: steelblue"><IMG
id=Image1
style="Z-INDEX: 1; LEFT: 0cm; WIDTH: 960px; POSITION: absolute; TOP: 0cm; HEIGHT: 79px"
tabIndex=1 height=79 src="Corporate_files\image001.gif" width=960><IMG id=Image2
style="Z-INDEX: 2; LEFT: 0.292cm; POSITION: absolute; TOP: 0.211cm" tabIndex=2
src="Corporate_files\image002.gif" ACCESS_CB_FORMAT><SPAN class=MSTheme-Label
id=Label2
style="FONT-SIZE: 10pt; Z-INDEX: 4; LEFT: 1.402cm; OVERFLOW: hidden; WIDTH: 2.983cm; FONT-STYLE: italic; POSITION: absolute; TOP: 0.953cm; HEIGHT: 0.555cm">CORPORATE</SPAN><SPAN
class=MSTheme-Label id=HTML1 dataFormatAs=TEXT
style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; PADDING-LEFT: 1px; FONT-SIZE: 28pt; Z-INDEX: 3; LEFT: 174px; OVERFLOW: hidden; BORDER-LEFT: 0px; WIDTH: 9.205cm; COLOR: #ff6600; BORDER-BOTTOM: 0px; POSITION: absolute; TOP: 15px; HEIGHT: 1.301cm; TEXT-ALIGN: left; TEXT-DECORATION: none">
<H1 class="" id=HeadingText2 align=center><FONT style="FONT-SIZE: 36px"
size=7>Customer Detail</FONT></H1></SPAN><SPAN class=MSTheme-Label id=Label10
style="FONT-WEIGHT: 700; FONT-SIZE: 24pt; Z-INDEX: 5; LEFT: 19.393cm; OVERFLOW: hidden; WIDTH: 5.396cm; FONT-STYLE: italic; POSITION: absolute; TOP: 0.503cm; HEIGHT: 1.083cm; TEXT-ALIGN: right">Jaimee</SPAN></DIV>
<DIV class=Mso2dSectionBanner id=HeaderCorporateBanner
style="MARGIN-LEFT: 0px; WIDTH: 25.4cm" tabIndex=-1><SPAN
id=HeaderCorporateBannerCaption>Header: Corporate</SPAN></DIV>
<DIV class=Mso2dSection id=HeaderCorporate
style="VISIBILITY: hidden; MARGIN-LEFT: 0px; WIDTH: 25.4cm; COLOR: black; HEIGHT: 13.282cm; BACKGROUND-COLOR: #ff6600">
<OBJECT id=PivotTable3
style="FONT-WEIGHT: 700; Z-INDEX: 1; LEFT: 0.107cm; WIDTH: 952px; POSITION: absolute; TOP: 0.107cm; HEIGHT: 491px; TEXT-ALIGN: center"
tabIndex=3 height=491 width=952
classid=CLSID:0002E552-0000-0000-C000-000000000046><PARAM NAME="XMLData" VALUE="<xml xmlns:x="urn:schemas-microsoft-com:office:excel">
<x:PivotTable>
<x:OWCVersion>10.0.0.5605 </x:OWCVersion>
<x:NoDisplayToolbar/>
<x:DisplayScreenTips/>
<x:NoAutoFit/>
<x:Height>491</x:Height>
<x:Width>952</x:Width>
<x:NoAllowGrouping/>
<x:CubeProvider>msolap.2</x:CubeProvider>
<x:CacheDetails/>
<x:DataMember>Corporate</x:DataMember>
<x:Name>Corporate Customers</x:Name>
<x:PivotField>
<x:Name>Notes</x:Name>
<x:PLDataOrientation/>
<x:PLPosition>10</x:PLPosition>
<x:EncodedType>adLongVarWChar</x:EncodedType>
<x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy>
</x:PivotField>
<x:PivotField>
<x:Name>Warehouse</x:Name>
<x:DataType>Integer</x:DataType>
<x:EncodedType>adSmallInt</x:EncodedType>
<x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy>
</x:PivotField>
<x:PivotField>
<x:Name>Sales Rep</x:Name>
<x:SourceName>SalesRep</x:SourceName>
<x:FilterCaption>SalesRep</x:FilterCaption>
<x:EncodedType>adWChar</x:EncodedType>
<x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy>
</x:PivotField>
<x:PivotField>
<x:Name>Status</x:Name>
<x:SourceName>CustomerStatus</x:SourceName>
<x:FilterCaption>CustomerStatus</x:FilterCaption>
<x:EncodedType>adWChar</x:EncodedType>
<x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy>
</x:PivotField>
<x:PivotField>
<x:Name>Type</x:Name>
<x:SourceName>CustomerType</x:SourceName>
<x:FilterCaption>CustomerType</x:FilterCaption>
<x:EncodedType>adWChar</x:EncodedType>
<x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy>
</x:PivotField>
<x:PivotField>
<x:Name>Company</x:Name>
<x:SourceName>CustomerName</x:SourceName>
<x:FilterCaption>CustomerName</x:FilterCaption>
<x:EncodedType>adWChar</x:EncodedType>
<x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy>
</x:PivotField>
<x:PivotField>
<x:Name>Contact</x:Name>
<x:SourceName>ContactName</x:SourceName>
<x:IsHyperlink/>
<x:FilterCaption>ContactName</x:FilterCaption>
<x:PLDataOrientation/>
<x:EncodedType>adWChar</x:EncodedType>
<x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy>
</x:PivotField>
<x:PivotField>
<x:Name>Phone</x:Name>
<x:SourceName>ContactNumber</x:SourceName>
<x:DataType>Integer</x:DataType>
<x:FilterCaption>ContactNumber</x:FilterCaption>
<x:PLDataOrientation/>
<x:PLPosition>2</x:PLPosition>
<x:EncodedType>adInteger</x:EncodedType>
<x:NumberFormat>0000000000</x:NumberFormat>
<x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy>
</x:PivotField>
<x:PivotField>
<x:Name>Email</x:Name>
<x:SourceName>ContactEmail</x:SourceName>
<x:FilterCaption>ContactEmail</x:FilterCaption>
<x:PLDataOrientation/>
<x:PLPosition>3</x:PLPosition>
<x:EncodedType>adWChar</x:EncodedType>
<x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy>
</x:PivotField>
<x:PivotField>
<x:Name>Opportunity</x:Name>
<x:SourceName>OpportunityName</x:SourceName>
<x:FilterCaption>OpportunityName</x:FilterCaption>
<x:PLDataOrientation/>
<x:PLPosition>4</x:PLPosition>
<x:EncodedType>adWChar</x:EncodedType>
<x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy>
</x:PivotField>
<x:PivotField>
<x:Name>No. Svc</x:Name>
<x:SourceName>NumberServices</x:SourceName>
<x:DataType>Integer</x:DataType>
<x:FilterCaption>NumberServices</x:FilterCaption>
<x:PLDataOrientation/>
<x:PLPosition>5</x:PLPosition>
<x:EncodedType>adSmallInt</x:EncodedType>
<x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy>
</x:PivotField>
<x:PivotField>
<x:Name>Partner</x:Name>
<x:SourceName>PartnerName</x:SourceName>
<x:FilterCaption>PartnerName</x:FilterCaption>
<x:PLDataOrientation/>
<x:PLPosition>6</x:PLPosition>
<x:EncodedType>adWChar</x:EncodedType>
<x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy>
</x:PivotField>
<x:PivotField>
<x:Name>Exp Close</x:Name>
<x:SourceName>ExpCloseDate</x:SourceName>
<x:DataType>Date</x:DataType>
<x:FilterCaption>ExpCloseDate</x:FilterCaption>
<x:EncodedType>adDate</x:EncodedType>
<x:NumberFormat>Short Date</x:NumberFormat>
<x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy>
</x:PivotField>
<x:PivotField>
<x:Name>Sale Prob (%)</x:Name>
<x:SourceName>SaleProbability</x:SourceName>
<x:DataType>Integer</x:DataType>
<x:FilterCaption>SaleProbability</x:FilterCaption>
<x:PLDataOrientation/>
<x:PLPosition>7</x:PLPosition>
<x:EncodedType>adSmallInt</x:EncodedType>
<x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy>
</x:PivotField>
<x:PivotField>
<x:Name>Exp GP ($)</x:Name>
<x:SourceName>ExpectedGP</x:SourceName>
<x:DataType>Integer</x:DataType>
<x:FilterCaption>ExpectedGP</x:FilterCaption>
<x:PLDataOrientation/>
<x:PLPosition>8</x:PLPosition>
<x:EncodedType>adSmallInt</x:EncodedType>
<x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy>
</x:PivotField>
<x:PivotField>
<x:Name>Prob GP ($)</x:Name>
<x:SourceName>ProbabilityGP</x:SourceName>
<x:DataType>Integer</x:DataType>
<x:FilterCaption>ProbabilityGP</x:FilterCaption>
<x:PLDataOrientation/>
<x:PLPosition>9</x:PLPosition>
<x:EncodedType>adSmallInt</x:EncodedType>
<x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy>
</x:PivotField>
<x:PivotField>
<x:Name>Data</x:Name>
<x:Orientation>Column</x:Orientation>
<x:Position>-1</x:Position>
<x:DataField/>
</x:PivotField>
<x:PLPivotField>
<x:Name>ExpCloseDate By Week</x:Name>
<x:SourceName>ExpCloseDate</x:SourceName>
<x:BoundField/>
<x:AutoDateType>ByWeek</x:AutoDateType>
<x:DataType>Date</x:DataType>
<x:NumberFormat>Short Date</x:NumberFormat>
<x:CompareOrderedMembersBy>Name</x:CompareOrderedMembersBy>
</x:PLPivotField>
<x:PLPivotField>
<x:Name>Exp Close1</x:Name>
<x:SourceName>ExpCloseDate</x:SourceName>
<x:DataType>Date</x:DataType>
<x:ParentField>Years</x:ParentField>
<x:GroupType>Seconds</x:GroupType>
<x:PLCaption>Seconds</x:PLCaption>
<x:FilterCaption>ExpCloseDate By Week</x:FilterCaption>
<x:EncodedType>adInteger</x:EncodedType>
<x:NumberFormat>ss</x:NumberFormat>
<x:CompareOrderedMembersBy>Name</x:CompareOrderedMembersBy>
</x:PLPivotField>
<x:PLPivotField>
<x:Name>Minutes</x:Name>
<x:BaseField>Exp Close1</x:BaseField>
<x:GroupType>Minutes</x:GroupType>
<x:EncodedType>adInteger</x:EncodedType>
<x:NumberFormat>mm:</x:NumberFormat>
<x:CompareOrderedMembersBy>Name</x:CompareOrderedMembersBy>
</x:PLPivotField>
<x:PLPivotField>
<x:Name>Hours</x:Name>
<x:BaseField>Exp Close1</x:BaseField>
<x:GroupType>Hours</x:GroupType>
<x:EncodedType>adInteger</x:EncodedType>
<x:NumberFormat>hh</x:NumberFormat>
<x:CompareOrderedMembersBy>Name</x:CompareOrderedMembersBy>
</x:PLPivotField>
<x:PLPivotField>
<x:Name>Days</x:Name>
<x:BaseField>Exp Close1</x:BaseField>
<x:GroupType>Days</x:GroupType>
<x:EncodedType>adInteger</x:EncodedType>
<x:NumberFormat>dddd</x:NumberFormat>
<x:CompareOrderedMembersBy>Name</x:CompareOrderedMembersBy>
</x:PLPivotField>
<x:PLPivotField>
<x:Name>Months</x:Name>
<x:BaseField>Exp Close1</x:BaseField>
<x:GroupType>Months</x:GroupType>
<x:PLGroupType>Weeks</x:PLGroupType>
<x:PLCaption>Weeks</x:PLCaption>
<x:EncodedType>adInteger</x:EncodedType>
<x:CompareOrderedMembersBy>Name</x:CompareOrderedMembersBy>
</x:PLPivotField>
<x:PLPivotField>
<x:Name>Years</x:Name>
<x:BaseField>Exp Close1</x:BaseField>
<x:GroupType>Years</x:GroupType>
<x:EncodedType>adInteger</x:EncodedType>
<x:NumberFormat>yyyy</x:NumberFormat>
<x:CompareOrderedMembersBy>Name</x:CompareOrderedMembersBy>
</x:PLPivotField>
<x:PLPivotField>
<x:Name>ExpCloseDate By Month</x:Name>
<x:SourceName>ExpCloseDate</x:SourceName>
<x:BoundField/>
<x:AutoDateType>ByMonth</x:AutoDateType>
<x:DataType>Date</x:DataType>
<x:NumberFormat>Short Date</x:NumberFormat>
<x:CompareOrderedMembersBy>Name</x:CompareOrderedMembersBy>
</x:PLPivotField>
<x:PLPivotField>
<x:Name>Exp Close2</x:Name>
<x:SourceName>ExpCloseDate</x:SourceName>
<x:DataType>Date</x:DataType>
<x:ParentField>Years1</x:ParentField>
<x:GroupType>Seconds</x:GroupType>
<x:PLCaption>Seconds</x:PLCaption>
<x:FilterCaption>ExpCloseDate By Month</x:FilterCaption>
<x:EncodedType>adInteger</x:EncodedType>
<x:NumberFormat>ss</x:NumberFormat>
<x:CompareOrderedMembersBy>Name</x:CompareOrderedMembersBy>
</x:PLPivotField>
<x:PLPivotField>
<x:Name>Minutes1</x:Name>
<x:BaseField>Exp Close2</x:BaseField>
<x:GroupType>Minutes</x:GroupType>
<x:PLCaption>Minutes</x:PLCaption>
<x:EncodedType>adInteger</x:EncodedType>
<x:NumberFormat>mm:</x:NumberFormat>
<x:CompareOrderedMembersBy>Name</x:CompareOrderedMembersBy>
</x:PLPivotField>
<x:PLPivotField>
<x:Name>Hours1</x:Name>
<x:BaseField>Exp Close2</x:BaseField>
<x:GroupType>Hours</x:GroupType>
<x:PLCaption>Hours</x:PLCaption>
<x:EncodedType>adInteger</x:EncodedType>
<x:NumberFormat>hh</x:NumberFormat>
<x:CompareOrderedMembersBy>Name</x:CompareOrderedMembersBy>
</x:PLPivotField>
<x:PLPivotField>
<x:Name>Days1</x:Name>
<x:BaseField>Exp Close2</x:BaseField>
<x:GroupType>Days</x:GroupType>
<x:PLCaption>Days</x:PLCaption>
<x:EncodedType>adInteger</x:EncodedType>
<x:NumberFormat>dd-mmm</x:NumberFormat>
<x:CompareOrderedMembersBy>Name</x:CompareOrderedMembersBy>
</x:PLPivotField>
<x:PLPivotField>
<x:Name>Months1</x:Name>
<x:BaseField>Exp Close2</x:BaseField>
<x:GroupType>Months</x:GroupType>
<x:PLCaption>Months</x:PLCaption>
<x:EncodedType>adInteger</x:EncodedType>
<x:NumberFormat>mmm</x:NumberFormat>
<x:CompareOrderedMembersBy>Name</x:CompareOrderedMembersBy>
</x:PLPivotField>
<x:PLPivotField>
<x:Name>Quarters</x:Name>
<x:BaseField>Exp Close2</x:BaseField>
<x:GroupType>Quarters</x:GroupType>
<x:EncodedType>adInteger</x:EncodedType>
<x:NumberFormat>"Qtr"#</x:NumberFormat>
<x:CompareOrderedMembersBy>Name</x:CompareOrderedMembersBy>
</x:PLPivotField>
<x:PLPivotField>
<x:Name>Years1</x:Name>
<x:BaseField>Exp Close2</x:BaseField>
<x:GroupType>Years</x:GroupType>
<x:PLCaption>Years</x:PLCaption>
<x:EncodedType>adInteger</x:EncodedType>
<x:NumberFormat>yyyy</x:NumberFormat>
<x:CompareOrderedMembersBy>Name</x:CompareOrderedMembersBy>
</x:PLPivotField>
<x:PivotData>
<x:Top>0</x:Top>
<x:TopOffset>0</x:TopOffset>
<x:Left>0</x:Left>
<x:LeftOffset>0</x:LeftOffset>
<x:SeqNum>10</x:SeqNum>
<x:Expanded/>
</x:PivotData>
<x:PivotView>
<x:Label Style='font-family:Arial;font-size:14pt;font-weight:700;font-style:
italic;text-underline-style:none;color:darkorange'>
<x:Caption>Corporate Customers</x:Caption>
</x:Label>
</x:PivotView>
<x:PivotAxis>
<x:Orientation>Filter</x:Orientation>
<x:Label>
<x:Caption>Drop Filter Fields Here</x:Caption>
<x:NotVisible/>
</x:Label>
</x:PivotAxis>
<x:PivotAxis>
<x:Orientation>Row</x:Orientation>
<x:Label>
<x:Caption>Drop Row Fields Here</x:Caption>
<x:NotVisible/>
</x:Label>
</x:PivotAxis>
<x:PivotAxis>
<x:Orientation>Column</x:Orientation>
<x:Label>
<x:Caption>Drop Column Fields Here</x:Caption>
<x:NotVisible/>
</x:Label>
</x:PivotAxis>
<x:PivotAxis>
<x:Orientation>Data</x:Orientation>
<x:Label>
<x:Caption>Drop Totals or Detail Fields Here</x:Caption>
<x:NotVisible/>
</x:Label>
</x:PivotAxis>
</x:PivotTable>
</xml>"></OBJECT></DIV></BODY></HTML>
| 