JP4786943B2 - テーブル、マトリクス、およびその混合によるデザインを含む柔軟なレポートデザインのためのシステムおよび方法 - Google Patents

テーブル、マトリクス、およびその混合によるデザインを含む柔軟なレポートデザインのためのシステムおよび方法 Download PDF

Info

Publication number
JP4786943B2
JP4786943B2 JP2005168770A JP2005168770A JP4786943B2 JP 4786943 B2 JP4786943 B2 JP 4786943B2 JP 2005168770 A JP2005168770 A JP 2005168770A JP 2005168770 A JP2005168770 A JP 2005168770A JP 4786943 B2 JP4786943 B2 JP 4786943B2
Authority
JP
Japan
Prior art keywords
report
word
column
data
design
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Expired - Fee Related
Application number
JP2005168770A
Other languages
English (en)
Japanese (ja)
Other versions
JP2006012145A5 (enExample
JP2006012145A (ja
Inventor
エー．ヘイズ クリストファー
ディー．カールソン ジェーソン
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Microsoft Corp
Original Assignee
Microsoft Corp
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Microsoft Corp filed Critical Microsoft Corp
Publication of JP2006012145A publication Critical patent/JP2006012145A/ja
Publication of JP2006012145A5 publication Critical patent/JP2006012145A5/ja
Application granted granted Critical
Publication of JP4786943B2 publication Critical patent/JP4786943B2/ja
Anticipated expiration legal-status Critical
Expired - Fee Related legal-status Critical Current

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/10—Office automation; Time management
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/248—Presentation of query results
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
    • G06Q50/10—Services

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • Computational Linguistics (AREA)
  • Strategic Management (AREA)
  • Data Mining & Analysis (AREA)
  • Human Resources & Organizations (AREA)
  • Health & Medical Sciences (AREA)
  • General Health & Medical Sciences (AREA)
  • Tourism & Hospitality (AREA)
  • General Business, Economics & Management (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Artificial Intelligence (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Databases & Information Systems (AREA)
  • Quality & Reliability (AREA)
  • Operations Research (AREA)
  • Primary Health Care (AREA)
  • Document Processing Apparatus (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Measurement And Recording Of Electrical Phenomena And Electrical Characteristics Of The Living Body (AREA)
  • Investigating, Analyzing Materials By Fluorescence Or Luminescence (AREA)
  • Adornments (AREA)
JP2005168770A 2004-06-23 2005-06-08 テーブル、マトリクス、およびその混合によるデザインを含む柔軟なレポートデザインのためのシステムおよび方法 Expired - Fee Related JP4786943B2 (ja)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US10/875,832 2004-06-23
US10/875,832 US7707490B2 (en) 2004-06-23 2004-06-23 Systems and methods for flexible report designs including table, matrix and hybrid designs

Publications (3)

Publication Number Publication Date
JP2006012145A JP2006012145A (ja) 2006-01-12
JP2006012145A5 JP2006012145A5 (enExample) 2008-07-24
JP4786943B2 true JP4786943B2 (ja) 2011-10-05

Family

ID=35063184

Family Applications (1)

Application Number Title Priority Date Filing Date
JP2005168770A Expired - Fee Related JP4786943B2 (ja) 2004-06-23 2005-06-08 テーブル、マトリクス、およびその混合によるデザインを含む柔軟なレポートデザインのためのシステムおよび方法

Country Status (5)

Country Link
US (1) US7707490B2 (enExample)
EP (1) EP1610231A3 (enExample)
JP (1) JP4786943B2 (enExample)
KR (1) KR101150114B1 (enExample)
CN (1) CN100454301C (enExample)

Families Citing this family (39)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8060817B2 (en) * 2004-11-09 2011-11-15 Oracle International Corporation Data viewer
US8402361B2 (en) * 2004-11-09 2013-03-19 Oracle International Corporation Methods and systems for implementing a dynamic hierarchical data viewer
US7685510B2 (en) * 2004-12-23 2010-03-23 Sap Ag System and method for grouping data
US8261181B2 (en) * 2006-03-30 2012-09-04 Microsoft Corporation Multidimensional metrics-based annotation
US8190992B2 (en) 2006-04-21 2012-05-29 Microsoft Corporation Grouping and display of logically defined reports
US8126750B2 (en) 2006-04-27 2012-02-28 Microsoft Corporation Consolidating data source queries for multidimensional scorecards
JP4256416B2 (ja) 2006-09-29 2009-04-22 株式会社東芝 データ構造変換システム及びプログラム
US20080172348A1 (en) * 2007-01-17 2008-07-17 Microsoft Corporation Statistical Determination of Multi-Dimensional Targets
US20080172287A1 (en) * 2007-01-17 2008-07-17 Ian Tien Automated Domain Determination in Business Logic Applications
US9058307B2 (en) 2007-01-26 2015-06-16 Microsoft Technology Licensing, Llc Presentation generation using scorecard elements
US8321805B2 (en) 2007-01-30 2012-11-27 Microsoft Corporation Service architecture based metric views
US8495663B2 (en) 2007-02-02 2013-07-23 Microsoft Corporation Real time collaboration using embedded data visualizations
US20090222760A1 (en) * 2008-02-29 2009-09-03 Halverson Steven G Method, System and Computer Program Product for Automating the Selection and Ordering of Column Data in a Table for a User
US8306971B2 (en) * 2008-06-20 2012-11-06 Tableau Software, Inc. Methods and systems of automatically geocoding a dataset for visual analysis
US8478786B2 (en) 2010-09-14 2013-07-02 Microsoft Corporation Automatic layout derivation and implementation
US8732212B2 (en) * 2011-07-12 2014-05-20 International Business Machines Corporation System for simplifying an XML-based schema
US20130238396A1 (en) * 2012-03-06 2013-09-12 Jukka SAPPINEN Method, system and apparatus for designing assessment report
USD690714S1 (en) 2012-06-13 2013-10-01 Microsoft Corporation Display screen with graphical user interface
USD705787S1 (en) 2012-06-13 2014-05-27 Microsoft Corporation Display screen with animated graphical user interface
USD711409S1 (en) 2012-06-13 2014-08-19 Microsoft Corporation Display screen with graphical user interface
USD691154S1 (en) * 2012-06-13 2013-10-08 Microsoft Corporation Display screen with graphical user interface
US9910894B2 (en) 2012-07-16 2018-03-06 Microsoft Technology Licensing, Llc Data scope origination within aggregation operations
US9390174B2 (en) * 2012-08-08 2016-07-12 Google Inc. Search result ranking and presentation
CN103678413B (zh) * 2012-09-25 2017-07-28 金蝶软件（中国）有限公司 报表动态列的展示方法及装置
USD722074S1 (en) * 2012-10-12 2015-02-03 Microsoft Corporation Display screen with graphical user interface
USD722073S1 (en) * 2012-10-12 2015-02-03 Microsoft Corporation Display screen with graphical user interface
USD733732S1 (en) * 2013-05-14 2015-07-07 Microsoft Corporation Display screen with graphical user interface
CN103631764B (zh) * 2013-12-18 2016-09-14 用友网络科技股份有限公司 基于扩展机制的报表设计方法
JP6372220B2 (ja) * 2014-07-24 2018-08-15 富士通株式会社 表生成方法、表生成プログラム及び表生成装置
USD763307S1 (en) * 2014-08-15 2016-08-09 Michael Shunock Display screen or portion thereof with animated graphical user interface
CN105427217A (zh) * 2014-12-17 2016-03-23 伊斯雷尔·巴肯 交互型图像电子医疗研究管理系统
US10262286B2 (en) 2015-03-06 2019-04-16 International Business Machines Corporation Data comparison and analysis based on data analysis reporting
US11526532B2 (en) * 2017-09-19 2022-12-13 Sap Se Dynamic data viewer
US10810192B2 (en) 2018-09-18 2020-10-20 Sigma Computing, Inc. Generating a database query to dynamically aggregate rows of a data set
US11455079B2 (en) 2018-11-05 2022-09-27 Sigma Computing, Inc. Nested pagination for presenting a data set in a graphical user interface
WO2020223580A1 (en) * 2019-05-01 2020-11-05 Sigma Computing, Inc. Dynamically normalizing intervals in a table
US11630848B2 (en) * 2019-09-20 2023-04-18 International Business Machines Corporation Managing hypercube data structures
US11605138B2 (en) * 2021-01-29 2023-03-14 Sehlke Consulting, LLC Data reconciliation for disparate databases by automatic generation of relevant action items
CN118734813B (zh) * 2024-06-24 2025-08-15 浪潮卓数大数据产业发展有限公司 一种基层治理的报表管理方法、装置、设备及介质

Family Cites Families (50)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5255356A (en) * 1989-05-31 1993-10-19 Microsoft Corporation Method for hiding and showing spreadsheet cells
WO1992004678A1 (en) * 1990-09-10 1992-03-19 Lotus Development Corporation Apparatus and method for reformattable spreadsheet
JPH0689307A (ja) * 1992-05-04 1994-03-29 Internatl Business Mach Corp <Ibm> データベース内の情報を表示する装置および方法
US5504885A (en) * 1993-06-29 1996-04-02 Texas Instruments Incorporated O-R gateway: a system for connecting object-oriented application programs and relational databases
US5603025A (en) * 1994-07-29 1997-02-11 Borland International, Inc. Methods for hypertext reporting in a relational database management system
US5809266A (en) 1994-07-29 1998-09-15 Oracle Corporation Method and apparatus for generating reports using declarative tools
US5832532A (en) * 1995-06-16 1998-11-03 I2 Technologies, Inc. Model-independent and interactive report generation system and method of operation
US6195653B1 (en) * 1997-10-14 2001-02-27 International Business Machines Corporation System and method for selectively preparing customized reports of query explain data
US6065012A (en) * 1998-02-27 2000-05-16 Microsoft Corporation System and method for displaying and manipulating user-relevant data
US6298342B1 (en) 1998-03-16 2001-10-02 Microsoft Corporation Electronic database operations for perspective transformations on relational tables using pivot and unpivot columns
US6054987A (en) * 1998-05-29 2000-04-25 Hewlett-Packard Company Method of dynamically creating nodal views of a managed network
US6442575B2 (en) 1998-06-17 2002-08-27 Microsoft Corporation Method and system for merging cells in a table and for adding an integrated header and a nested table to a table in an electronic document
US6463442B1 (en) * 1998-06-30 2002-10-08 Microsoft Corporation Container independent data binding system
US6714219B2 (en) 1998-12-31 2004-03-30 Microsoft Corporation Drag and drop creation and editing of a page incorporating scripts
US6549907B1 (en) * 1999-04-22 2003-04-15 Microsoft Corporation Multi-dimensional database and data cube compression for aggregate query support on numeric dimensions
US6920608B1 (en) * 1999-05-21 2005-07-19 E Numerate Solutions, Inc. Chart view for reusable data markup language
US6496836B1 (en) * 1999-12-20 2002-12-17 Belron Systems, Inc. Symbol-based memory language system and method
CA2399156A1 (en) * 2000-02-11 2001-08-16 Sridhar Gantimahapatruni Nested relational data model
US6687873B1 (en) * 2000-03-09 2004-02-03 Electronic Data Systems Corporation Method and system for reporting XML data from a legacy computer system
US7114147B2 (en) 2000-03-09 2006-09-26 Electronic Data Systems Corporation Method and system for reporting XML data based on precomputed context and a document object model
US20020091681A1 (en) * 2000-04-03 2002-07-11 Jean-Yves Cras Report then query capability for a multidimensional database model
US6633882B1 (en) * 2000-06-29 2003-10-14 Microsoft Corporation Multi-dimensional database record compression utilizing optimized cluster models
JP4465147B2 (ja) * 2000-07-13 2010-05-19 オラクル・インターナショナル・コーポレイション データベースシステムにおいてスプレッドシートの算出を行なう方法
TWI230858B (en) 2000-12-12 2005-04-11 Matsushita Electric Industrial Co Ltd File management method, content recording/playback apparatus and content recording program
US7082569B2 (en) * 2001-01-17 2006-07-25 Outlooksoft Corporation Systems and methods providing dynamic spreadsheet functionality
US20020154161A1 (en) * 2001-02-01 2002-10-24 Friedman Michael A. Method and system for providing universal remote control of computing devices
US20040230572A1 (en) 2001-06-22 2004-11-18 Nosa Omoigui System and method for semantic knowledge retrieval, management, capture, sharing, discovery, delivery and presentation
US20030115194A1 (en) 2001-08-01 2003-06-19 Pitts Theodore H. Method and apparatus for processing a query to a multi-dimensional data structure
CN1403982A (zh) * 2001-09-12 2003-03-19 英业达股份有限公司 多维生产管理报表伺服系统及方法
US7139766B2 (en) 2001-12-17 2006-11-21 Business Objects, S.A. Universal drill-down system for coordinated presentation of items in different databases
US20030149646A1 (en) * 2002-02-01 2003-08-07 Ubs Painewebber Inc. Method and system for providing an aggregated stock options report
US20030154277A1 (en) 2002-02-11 2003-08-14 Rabih Haddad Method and system for real-time generating, managing, and broadcasting multimedia events reports over communications networks
US20030208460A1 (en) 2002-05-06 2003-11-06 Ncr Corporation Methods, systems and data structures to generate and link reports
US6986123B2 (en) 2002-06-28 2006-01-10 Microsoft Corporation Extensible on-demand property system
US20040117731A1 (en) * 2002-09-27 2004-06-17 Sergey Blyashov Automated report building system
US7370271B2 (en) 2002-10-30 2008-05-06 Actuate Corporation Methods and apparatus for generating a spreadsheet report template
US7263517B2 (en) 2002-10-31 2007-08-28 Biomedical Objects, Inc. Structured natural language query and knowledge system
CN1745389A (zh) 2002-11-29 2006-03-08 百讯达集团有限公司 用于监管出版媒体中的项目的出版和用于准备出版物的自动校样的方法
US20040111666A1 (en) 2002-12-05 2004-06-10 Hollcraft James G. Software replicator functions for generating reports
TW200419407A (en) 2003-03-28 2004-10-01 Hon Hai Prec Ind Co Ltd EDI customs application system and method
CA2429335A1 (en) 2003-05-22 2004-11-22 Cognos Incorporated System and method of determining impact of reports based on metadata model changes
US20050166139A1 (en) 2003-06-10 2005-07-28 Pittman John S. System and method for managing legal documents
US7620958B2 (en) 2003-06-30 2009-11-17 Microsoft Corporation Transaction interoperability using host-initiated processing
US7814093B2 (en) * 2003-07-25 2010-10-12 Microsoft Corporation Method and system for building a report for execution against a data store
US7146333B2 (en) 2003-08-14 2006-12-05 Hamer Patricia A Report generator for allowing a financial entity to monitor securities class action lawsuits and potential monetary claims resulting therefrom
US7302444B1 (en) * 2003-08-15 2007-11-27 Microsoft Corporation System for designating grid-based database reports
US7500186B2 (en) 2004-08-30 2009-03-03 Microsoft Corporation Systems and methods for efficiently generating table layouts using moveable items
US20080104091A1 (en) 2004-11-26 2008-05-01 Chin Philip K Method of displaying data in a table
US20070050697A1 (en) 2005-08-23 2007-03-01 International Business Machines Corporation Integrated spreadsheet expanding table with collapsable columns
US20080046861A1 (en) 2006-08-15 2008-02-21 Grieser Maria A Method and interface for creating a workbook to implement a business process

Also Published As

Publication number Publication date
KR101150114B1 (ko) 2012-06-08
US7707490B2 (en) 2010-04-27
KR20060045925A (ko) 2006-05-17
JP2006012145A (ja) 2006-01-12
CN1713181A (zh) 2005-12-28
CN100454301C (zh) 2009-01-21
EP1610231A2 (en) 2005-12-28
EP1610231A3 (en) 2008-02-13
US20050289455A1 (en) 2005-12-29

Similar Documents

Publication Publication Date Title
JP2006012145A (ja) テーブル、マトリクス、およびその混合によるデザインを含む柔軟なレポートデザインのためのシステムおよび方法
US7559023B2 (en) Systems and methods for declaratively controlling the visual state of items in a report
US7302444B1 (en) System for designating grid-based database reports
US7880749B2 (en) Apparatus and method for data charting with an extensible visualization library
CN101297268B (zh) 用于设计自动业务过程应用程序的集成系统、工具和方法
US6801926B1 (en) Platform-independent programmable batch processing engine
US7925719B2 (en) Object oriented based, business class methodology for generating quasi-static web pages at periodic intervals
US7181694B2 (en) Software customization objects for programming extensions associated with a computer system
US8209355B2 (en) Automatic user interface generation for entity interaction
US20110154253A1 (en) Process field extensibility for business objects
KR20120002579A (ko) 컴퓨팅 장치, 비즈니스 데이터의 획득 방법 및 컴퓨터 판독 가능 저장 매체
US20040049739A1 (en) Project structure
JP2017138746A (ja) 文書作成システム、文書作成方法、及びプログラム
CN106155988A (zh) 基于excel的数据图表绘制方法及相关装置
US10366350B2 (en) Enterprise compensation application supporting a large number of employees
US8904344B2 (en) Managing characteristics variation within software solution packages
US20090171931A1 (en) Obtaining Information From an Object
US20060026498A1 (en) Systems and methods for controlling report properties based on aggregate scope
US20230385745A1 (en) Computer methods and software for processing sap erp tasks
US9053149B2 (en) Method and system to provide composite view of components
US20210334094A1 (en) Interactive documentation pages for software products and features
US20090178024A1 (en) Method, computer program product, and system for merging multiple same class instance states
US9280260B2 (en) Provision of a graphical layout of semi-structured data based on properties of the semi-structured data and user input
US20080201652A1 (en) Techniques for viewing and managing work items and their relationships
Babaian et al. Mapping data associations in enterprise systems

Legal Events

Date Code Title Description
A521 Written amendment

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20080606

A621 Written request for application examination

Free format text: JAPANESE INTERMEDIATE CODE: A621

Effective date: 20080606

A977 Report on retrieval

Free format text: JAPANESE INTERMEDIATE CODE: A971007

Effective date: 20100625

A131 Notification of reasons for refusal

Free format text: JAPANESE INTERMEDIATE CODE: A131

Effective date: 20100702

A521 Written amendment

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20100930

A131 Notification of reasons for refusal

Free format text: JAPANESE INTERMEDIATE CODE: A131

Effective date: 20110104

RD13 Notification of appointment of power of sub attorney

Free format text: JAPANESE INTERMEDIATE CODE: A7433

Effective date: 20110308

A521 Written amendment

Free format text: JAPANESE INTERMEDIATE CODE: A821

Effective date: 20110308

A521 Written amendment

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20110401

TRDD Decision of grant or rejection written
A01 Written decision to grant a patent or to grant a registration (utility model)

Free format text: JAPANESE INTERMEDIATE CODE: A01

Effective date: 20110708

A01 Written decision to grant a patent or to grant a registration (utility model)

Free format text: JAPANESE INTERMEDIATE CODE: A01

A61 First payment of annual fees (during grant procedure)

Free format text: JAPANESE INTERMEDIATE CODE: A61

Effective date: 20110714

R150 Certificate of patent or registration of utility model

Free format text: JAPANESE INTERMEDIATE CODE: R150

Ref document number: 4786943

Country of ref document: JP

Free format text: JAPANESE INTERMEDIATE CODE: R150

FPAY Renewal fee payment (event date is renewal date of database)

Free format text: PAYMENT UNTIL: 20140722

Year of fee payment: 3

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

S111 Request for change of ownership or part of ownership

Free format text: JAPANESE INTERMEDIATE CODE: R313113

R350 Written notification of registration of transfer

Free format text: JAPANESE INTERMEDIATE CODE: R350

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

LAPS Cancellation because of no payment of annual fees