It's PivotControl . I also use an .htm from access for another easy
try and go like this.
I try it with OWC.10.0.0.5605 (best fit) .... But the results was the
same !!!
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="
http://www.w3.org/TR/REC-html40" xmlns
=
"urn:schemas-microsoft-com
ffice
ffice" xmlns:x =
"urn:schemas-microsoft-com
ffice:excel" xmlns:a =
"urn:schemas-microsoft-com
ffice:access" xmlns:dt =
"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"><HEAD><TITLE>Sales</
TITLE><LINK
href="Sales_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-1253">
<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
ffice:access">
<a
ataSourceControl>
<a:OWCVersion>10.0.0.5605 </a:OWCVersion>
<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
atamodel a:version="0816">
</a
atamodel>
</a
ataSourceControl>
</xml>'></
OBJECT>
<META content="MSHTML 6.00.2900.3020" 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
ocumentProperties>
<o:Author>project_manager</o:Author>
<o:LastAuthor>project_manager</o:LastAuthor>
<o:Revision>9</o:Revision>
<o:TotalTime>19</o:TotalTime>
<o:Created>2007-02-06T09:40:25Z</o:Created>
<o:LastSaved>2007-02-07T13:24:55Z</o:LastSaved>
<o:Company>Sprider</o:Company>
<o:Version>11.5606</o:Version>
</o
ocumentProperties>
</xml><![endif]--></HEAD>
<BODY style="OVERFLOW: auto" vLink=#800080 link=#0000ff>
<CENTER>
<H1 class=MsoTitle id=HeadingText> </H1></CENTER>
<P>
<OBJECT id=PivotTable2
style="Z-INDEX: 1; LEFT: 10px; WIDTH: 502px; TOP: 73px; HEIGHT:
333px"
tabIndex=1 height=333 width=502
classid=CLSID:0002E552-0000-0000-C000-000000000046><PARAM
NAME="XMLData" VALUE="<xml xmlns:x="urn:schemas-microsoft-
com
ffice:excel">
<x
ivotTable>
<x:OWCVersion>10.0.0.5605 </x:OWCVersion>
<x:CubeProvider>msolap.2</x:CubeProvider>
<x
isplayFieldList/>
<x:FieldListTop>283</
x:FieldListTop>
<x:FieldListLeft>585</
x:FieldListLeft>
<x:FieldListBottom>654</
x:FieldListBottom>
<x:FieldListRight>785</
x:FieldListRight>
<x:CacheDetails/>
<x:ConnectionString>Provider=MSOLAP.2;Integrated Security=SSPI;Persist
Security Info=True;Data Source=angelo;Initial Catalog=Sales2007;Client
Cache Size=25;Auto Synch Period=10000</x:ConnectionString>
<x
ataMember>Sales2007</x
ataMember>
<x:Name>Πωλήσεις vs
Budget</x:Name>
<x
ivotField>
<x:Name>Store</
x:Name>
<x:SourceName>[Store].[Store]</
x:SourceName>
<x:Orientation>Page</
x:Orientation>
<x:CompareOrderedMembersBy>UniqueName</
x:CompareOrderedMembersBy>
</x
ivotField>
<x
ivotField>
<x:Name>Εβδομάδα</x:Name>
<x:SourceName>[Εβδομάδα].[Εβδομάδα]</x:SourceName>
<x:CompareOrderedMembersBy>UniqueName</
x:CompareOrderedMembersBy>
</x
ivotField>
<x
ivotField>
<x:Name>ΗμÎÏα</x:Name>
<x:SourceName>[ΗμÎÏα].[ΗμÎÏα]</x:SourceName>
<x:CompareOrderedMembersBy>UniqueName</
x:CompareOrderedMembersBy>
</x
ivotField>
<x
ivotField>
<x:Name>ΗμεÏομηνία</x:Name>
<x:SourceName>[ΗμεÏομηνία].[ΗμεÏομηνία]</x:SourceName>
<x:CompareOrderedMembersBy>Name</x:CompareOrderedMembersBy>
</x
ivotField>
<x
ivotField>
<x:Name>Μήνας</
x:Name>
<x:SourceName>[Μήνας].[Μήνας]</
x:SourceName>
<x:FilterCaption>Μήνας</
x:FilterCaption>
<x:Orientation>Row</
x:Orientation>
<x:CompareOrderedMembersBy>UniqueName</
x:CompareOrderedMembersBy>
</x
ivotField>
<x
ivotField>
<x:Name>Εβδομάδα</x:Name>
<x:SourceName>[Μήνας].[Εβδομάδα]</x:SourceName>
<x:CompareOrderedMembersBy>UniqueName</
x:CompareOrderedMembersBy>
</x
ivotField>
<x
ivotField>
<x:Name>ΠαÏαστατικά</x:Name>
<x:SourceName>[ΠαÏαστατικά].[ΠαÏαστατικά]</x:SourceName>
<x:Orientation>Page</x:Orientation>
<x
osition>2</
x
osition>
<x:CompareOrderedMembersBy>UniqueName</
x:CompareOrderedMembersBy>
<x:AllIncludeExclude>Include</
x:AllIncludeExclude>
<x:ExcludedMember>
<x:Name>ΔΗΜΟΙ</x:Name>
<x:UniqueName>[ΠαÏαστατικά].[All
Way].[ΔΗΜΟΙ]</x:UniqueName>
</x:ExcludedMember>
</x
ivotField>
<x
ivotField>
<x:Name>Act
2007</x:Name>
<x:SourceName>[Measures].[Measure 2007]</
x:SourceName>
<x:SourceHierarchy>[Measures].[Measure
2007]</x:SourceHierarchy>
</x
ivotField>
<x
ivotField>
<x:Name>%Σ2007</x:Name>
<x:SourceName>[Measures].[%Σ2007]</x:SourceName>
<x:SourceHierarchy>[Measures].[%Σ2007]</x:SourceHierarchy>
</x
ivotField>
<x
ivotField>
<x:Name>%2006</
x:Name>
<x:SourceName>[Measures].[%2006]</
x:SourceName>
<x:SourceHierarchy>[Measures].[%2006]</
x:SourceHierarchy>
</x
ivotField>
<x
ivotField>
<x:Name>Σ2007</x:Name>
<x:SourceName>[Measures].[Σ2007]</x:SourceName>
<x:SourceHierarchy>[Measures].[Σ2007]</x:SourceHierarchy>
</
x
ivotField>
<x
ivotField>
<x:Name>Act 2006</
x:Name>
<x:SourceName>[Measures].[Measure 2006]</
x:SourceName>
<x:SourceHierarchy>[Measures].[Measure
2006]</x:SourceHierarchy>
</x
ivotField>
<x
ivotField>
<x:Name>Data</x:Name>
<x:Orientation>Column</x:Orientation>
<x
osition>-1</
x
osition>
<x
ataField/>
</
x
ivotField>
<x
ivotField>
<x:Name>%2006</
x:Name>
<x:TotalNumber>0</x:TotalNumber>
<x:Orientation>Data</x:Orientation>
<x
osition>3</
x
osition>
<x
arentField>[Measures].[%2006]</
x
arentField>
<x:NumberFormat>Percent</
x:NumberFormat>
</x
ivotField>
<x
ivotField>
<x:Name>%Σ2007</x:Name>
<x:TotalNumber>1</x:TotalNumber>
<x:Orientation>Data</
x:Orientation>
<x
osition>2</x
osition>
<x
arentField>[Measures].[%Σ2007]</x
arentField>
<x:NumberFormat>Percent</x:NumberFormat>
</
x
ivotField>
<x
ivotField>
<x:Name>Act 2006</
x:Name>
<x
LName>Measure 2006</x
LName>
<x:TotalNumber>2</x:TotalNumber>
<x:Orientation>Data</
x:Orientation>
<x
osition>5</x
osition>
<x
arentField>[Measures].[Measure 2006]</x
arentField>
<x:NumberFormat>#,##0.00 [$€-408];[red]-#,##0.00 [$€-408]</
x:NumberFormat>
</x
ivotField>
<x
ivotField>
<x:Name>Act 2007</x:Name>
<x
LName>Measure 2007</x
LName>
<x:TotalNumber>3</
x:TotalNumber>
<x:Orientation>Data</
x:Orientation>
<x
osition>1</x
osition>
<x
arentField>[Measures].[Measure 2007]</x
arentField>
<x:NumberFormat>#,##0.00 [$€-408];[red]-#,##0.00 [$€-408]</
x:NumberFormat>
</x
ivotField>
<x
ivotField>
<x:Name>Σ2007</x:Name>
<x:TotalNumber>4</x:TotalNumber>
<x:Orientation>Data</
x:Orientation>
<x
osition>4</x
osition>
<x
arentField>[Measures].[Σ2007]</x
arentField>
<x:NumberFormat>#,##0.00 [$€-408];[red]-#,##0.00 [$€-408]</
x:NumberFormat>
</x
ivotField>
<x
ivotData>
<x:Top>0.0</x:Top>
<x:TopOffset>0</x:TopOffset>
<x:Left>0</
x:Left>
<x:LeftOffset>0</x:LeftOffset>
</
x
ivotData>
<x
ivotView>
<x:TotalFormat
Style='font-family:Arial;font-size:10pt;background:mintcream'/
<x:Label>
<x:Caption>Πωλήσεις vs Budget</
x:Caption>
</x:Label>
<x:AllowEdits>false</
x:AllowEdits>
<x:AllowAdditions>false</
x:AllowAdditions>
<x:AllowDeletions>false</
x:AllowDeletions>
</x
ivotView>
</
x
ivotTable>
</xml>"></OBJECT></P>
<P> </P></BODY></HTML>