📄 accountreports.jsp
字号:
<%@ page import="org.ofbiz.entity.*" %>
<%@ page import="org.ofbiz.entity.model.*" %>
<%@ page import="java.lang.reflect.Method" %>
<%@ page import="java.util.*" %>
<%@ page import="org.ofbiz.entity.util.SequenceUtil" %>
<%@ include file="/includes/header.jsp" %>
<%@ include file="/includes/leftcolumn-account.jsp" %>
<!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"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-1252">
<META content=FrontPage.Editor.Document name=ProgId>
<META content="MSHTML 5.50.4611.1300" name=GENERATOR><LINK
href="./Page_files/filelist.xml" rel=File-List></HEAD>
<BODY><!--[if !excel]> <![endif]--> <!--The following information was generated by Microsoft Excel's Publish as Web
Page wizard.--><!--If the same item is republished from Excel, all information between the DIV
tags will be replaced.--><!-----------------------------><!--START OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD --><!----------------------------->
<DIV id=Book2_26444 align=center x:publishsource="Excel">
<OBJECT id=Book2_26444_DSC codeBase=file:E:\msowc.cab
classid=CLSID:0002E530-0000-0000-C000-000000000046><PARAM NAME="XMLData" VALUE='<!--[if gte mso 9]><xml xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel"> <x:PTSource> <x:DataMember>Sales</x:DataMember> <x:CacheIndex>1</x:CacheIndex> <x:RefreshName>Steve Fowler</x:RefreshName> <x:RefreshDate>2001-10-25T11:42:24</x:RefreshDate> <x:NoSaveData/> <x:CubeSource/> <x:QuerySource> <x:QueryType>OLEDB</x:QueryType> <x:CommandText>Sales</x:CommandText> <x:CommandType>Cube</x:CommandType> <x:Maintain/> <x:Connection>Provider=MSOLAP.2;Data Source=sfowler;Initial Catalog=FoodMart 2000;Client Cache Size=25;Auto Synch Period=10000</x:Connection> </x:QuerySource> </x:PTSource> <x:ElementExtension> <x:ElementID>Book2_26444_PivotList</x:ElementID> <x:ConsumesRecordset/> </x:ElementExtension> </xml><![endif]-->'></OBJECT>
<OBJECT id=Book2_26444_PivotList codeBase=file:E:\msowc.cab
classid=CLSID:0002E520-0000-0000-C000-000000000046><PARAM NAME="XMLData" VALUE='<!--[if gte mso 9]><xml xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel"> <x:WorksheetOptions> <x:Zoom>0</x:Zoom> <x:Selected/> <x:Panes> <x:Pane> <x:Number>3</x:Number> <x:ActiveRow>2</x:ActiveRow> <x:RangeSelection>A1:D25</x:RangeSelection> </x:Pane> </x:Panes> <x:ProtectContents>False</x:ProtectContents> <x:ProtectObjects>False</x:ProtectObjects> <x:ProtectScenarios>False</x:ProtectScenarios> </x:WorksheetOptions> <x:PivotTable> <x:Name>PivotTable1</x:Name> <x:DataMember>Sales</x:DataMember> <x:SubtotalHiddenPageItems/> <x:Location>$A$1:$D$25</x:Location> <x:PivotField> <x:Name>Product Family</x:Name> <x:SourceName>[Product].[Product Family]</x:SourceName> <x:Orientation>Row</x:Orientation> <x:NoDragToData/> <x:DrilledLevel/> <x:ServerSortOrder/> <x:Position>1</x:Position> <x:SourceHierarchy>[Product]</x:SourceHierarchy> <x:PivotItem> <x:Name>Drink</x:Name> <x:SourceName>[Product].[All Products].[Drink]</x:SourceName> </x:PivotItem> <x:PivotItem> <x:Name>Food</x:Name> <x:SourceName>[Product].[All Products].[Food]</x:SourceName> </x:PivotItem> <x:PivotItem> <x:Name>Non-Consumable</x:Name> <x:SourceName>[Product].[All Products].[Non-Consumable]</x:SourceName> </x:PivotItem> </x:PivotField> <x:PivotField> <x:Name>Country</x:Name> <x:SourceName>[Customers].[Country]</x:SourceName> <x:Orientation>Row</x:Orientation> <x:NoDragToData/> <x:DrilledLevel/> <x:ServerSortOrder/> <x:Position>2</x:Position> <x:SourceHierarchy>[Customers]</x:SourceHierarchy> <x:PivotItem> <x:Name>Canada</x:Name> <x:SourceName>[Customers].[All Customers].[Canada]</x:SourceName> </x:PivotItem> <x:PivotItem> <x:Name>Mexico</x:Name> <x:SourceName>[Customers].[All Customers].[Mexico]</x:SourceName> </x:PivotItem> <x:PivotItem> <x:Name>USA</x:Name> <x:SourceName>[Customers].[All Customers].[USA]</x:SourceName> </x:PivotItem> </x:PivotField> <x:PivotField> <x:Name>Year</x:Name> <x:SourceName>[Time].[Year]</x:SourceName> <x:Orientation>Column</x:Orientation> <x:NoDragToData/> <x:DrilledLevel/> <x:ServerSortOrder/> <x:Position>1</x:Position> <x:SourceHierarchy>[Time]</x:SourceHierarchy> <x:PivotItem> <x:Name>1997</x:Name> <x:SourceName>[Time].[1997]</x:SourceName> </x:PivotItem> <x:PivotItem> <x:Name>1998</x:Name> <x:SourceName>[Time].[1998]</x:SourceName> </x:PivotItem> </x:PivotField> <x:PivotField> <x:Name>Store Cost</x:Name> <x:SourceName>[Measures].[Store Cost]</x:SourceName> <x:NoDragToRow/> <x:NoDragToColumn/> <x:NoDragToPage/> <x:DataType>Number</x:DataType> <x:SourceHierarchy>[Measures].[Store Cost]</x:SourceHierarchy> </x:PivotField> <x:PivotField> <x:Name>Store Sales</x:Name> <x:SourceName>[Measures].[Store Sales]</x:SourceName> <x:NoDragToRow/> <x:NoDragToColumn/> <x:NoDragToPage/> <x:DataType>Number</x:DataType> <x:SourceHierarchy>[Measures].[Store Sales]</x:SourceHierarchy> </x:PivotField> <x:PivotField> <x:Name>Profit</x:Name> <x:SourceName>[Measures].[Profit]</x:SourceName> <x:NoDragToRow/> <x:NoDragToColumn/> <x:NoDragToPage/> <x:DataType>Number</x:DataType> <x:SourceHierarchy>[Measures].[Profit]</x:SourceHierarchy> </x:PivotField> <x:PivotField> <x:Name>Store</x:Name> <x:SourceName>[Store]</x:SourceName> <x:Orientation>Page</x:Orientation> <x:NoDragToData/> <x:ServerSortOrder/> <x:CurrentPage>[Store].[All Stores]</x:CurrentPage> <x:Caption>All Stores</x:Caption> <x:Position>1</x:Position> <x:SourceHierarchy>[Store]</x:SourceHierarchy> </x:PivotField> <x:PivotField> <x:DataField/> <x:Name>Data</x:Name> <x:Orientation>Row</x:Orientation> <x:Position>3</x:Position> </x:PivotField> <x:PivotField> <x:Name>Profit</x:Name> <x:ParentField>[Measures].[Profit]</x:ParentField> <x:Orientation>Data</x:Orientation> <x:Position>1</x:Position> </x:PivotField> <x:PivotField> <x:Name>Store Cost</x:Name> <x:ParentField>[Measures].[Store Cost]</x:ParentField> <x:Orientation>Data</x:Orientation> <x:Position>2</x:Position> </x:PivotField> <x:PivotField> <x:Name>Store Sales</x:Name> <x:ParentField>[Measures].[Store Sales]</x:ParentField> <x:Orientation>Data</x:Orientation> <x:Position>3</x:Position> </x:PivotField> <x:CubeField> <x:UniqueName>[Customers]</x:UniqueName> <x:Caption>Customers</x:Caption> <x:DefaultItem>[Customers].[All Customers]</x:DefaultItem> <x:AllItemName>[Customers].[All Customers]</x:AllItemName> <x:Dimension>[Customers]</x:Dimension> <x:Orientation>Row</x:Orientation> </x:CubeField> <x:CubeField> <x:UniqueName>[Education Level]</x:UniqueName> <x:Caption>Education Level</x:Caption> <x:DefaultItem>[Education Level].[All Education Level]</x:DefaultItem> <x:AllItemName>[Education Level].[All Education Level]</x:AllItemName> <x:Dimension>[Education Level]</x:Dimension> </x:CubeField> <x:CubeField> <x:UniqueName>[Gender]</x:UniqueName> <x:Caption>Gender</x:Caption> <x:DefaultItem>[Gender].[All Gender]</x:DefaultItem> <x:AllItemName>[Gender].[All Gender]</x:AllItemName> <x:Dimension>[Gender]</x:Dimension> </x:CubeField> <x:CubeField> <x:UniqueName>[Marital Status]</x:UniqueName> <x:Caption>Marital Status</x:Caption> <x:DefaultItem>[Marital Status].[All Marital Status]</x:DefaultItem> <x:AllItemName>[Marital Status].[All Marital Status]</x:AllItemName> <x:Dimension>[Marital Status]</x:Dimension> </x:CubeField> <x:CubeField> <x:UniqueName>[Product]</x:UniqueName> <x:Caption>Product</x:Caption> <x:DefaultItem>[Product].[All Products]</x:DefaultItem> <x:AllItemName>[Product].[All Products]</x:AllItemName> <x:Dimension>[Product]</x:Dimension> <x:Orientation>Row</x:Orientation> </x:CubeField> <x:CubeField> <x:UniqueName>[Promotion Media]</x:UniqueName> <x:Caption>Promotion Media</x:Caption> <x:DefaultItem>[Promotion Media].[All Media]</x:DefaultItem> <x:AllItemName>[Promotion Media].[All Media]</x:AllItemName> <x:Dimension>[Promotion Media]</x:Dimension> </x:CubeField> <x:CubeField> <x:UniqueName>[Promotions]</x:UniqueName> <x:Caption>Promotions</x:Caption> <x:DefaultItem>[Promotions].[All Promotions]</x:DefaultItem> <x:AllItemName>[Promotions].[All Promotions]</x:AllItemName> <x:Dimension>[Promotions]</x:Dimension> </x:CubeField> <x:CubeField> <x:UniqueName>[Store]</x:UniqueName> <x:Caption>Store</x:Caption> <x:DefaultItem>[Store].[All Stores]</x:DefaultItem> <x:AllItemName>[Store].[All Stores]</x:AllItemName> <x:Dimension>[Store]</x:Dimension> <x:Orientation>Page</x:Orientation> </x:CubeField> <x:CubeField> <x:UniqueName>[Store Size in SQFT]</x:UniqueName> <x:Caption>Store Size in SQFT</x:Caption> <x:DefaultItem>[Store Size in SQFT].[All Store Size in SQFT]</x:DefaultItem> <x:AllItemName>[Store Size in SQFT].[All Store Size in SQFT]</x:AllItemName> <x:Dimension>[Store Size in SQFT]</x:Dimension> </x:CubeField> <x:CubeField> <x:UniqueName>[Store Type]</x:UniqueName> <x:Caption>Store Type</x:Caption> <x:DefaultItem>[Store Type].[All Store Type]</x:DefaultItem> <x:AllItemName>[Store Type].[All Store Type]</x:AllItemName> <x:Dimension>[Store Type]</x:Dimension> </x:CubeField> <x:CubeField> <x:UniqueName>[Time]</x:UniqueName> <x:Caption>Time</x:Caption> <x:DefaultItem>[Time].[1997]</x:DefaultItem> <x:Dimension>[Time]</x:Dimension> <x:Orientation>Column</x:Orientation> </x:CubeField> <x:CubeField> <x:UniqueName>[Yearly Income]</x:UniqueName> <x:Caption>Yearly Income</x:Caption> <x:DefaultItem>[Yearly Income].[All Yearly Income]</x:DefaultItem> <x:AllItemName>[Yearly Income].[All Yearly Income]</x:AllItemName> <x:Dimension>[Yearly Income]</x:Dimension> </x:CubeField> <x:CubeField> <x:UniqueName>[Measures].[Profit]</x:UniqueName> <x:Caption>Profit</x:Caption> <x:Measure/> <x:Orientation>Data</x:Orientation> </x:CubeField> <x:CubeField> <x:UniqueName>[Measures].[Sales Average]</x:UniqueName> <x:Caption>Sales Average</x:Caption> <x:Measure/> </x:CubeField> <x:CubeField> <x:UniqueName>[Measures].[Sales Count]</x:UniqueName> <x:Caption>Sales Count</x:Caption> <x:Measure/> </x:CubeField> <x:CubeField> <x:UniqueName>[Measures].[Store Cost]</x:UniqueName> <x:Caption>Store Cost</x:Caption> <x:Measure/> <x:Orientation>Data</x:Orientation> </x:CubeField> <x:CubeField> <x:UniqueName>[Measures].[Store Sales]</x:UniqueName> <x:Caption>Store Sales</x:Caption> <x:Measure/> <x:Orientation>Data</x:Orientation> </x:CubeField> <x:CubeField> <x:UniqueName>[Measures].[Store Sales Net]</x:UniqueName> <x:Caption>Store Sales Net</x:Caption> <x:Measure/> </x:CubeField> <x:CubeField> <x:UniqueName>[Measures].[Unit Sales]</x:UniqueName> <x:Caption>Unit Sales</x:Caption> <x:Measure/> </x:CubeField> </x:PivotTable> </xml><![endif]-->'>
<p style='margin-top:100;font-family:Arial;font-size:8.0pt'>To use this Web
page interactively, you must have Microsoft⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -