CA2456339C - Declarative sequenced report parameterization - Google Patents

Declarative sequenced report parameterization Download PDF

Info

Publication number
CA2456339C
CA2456339C CA2456339A CA2456339A CA2456339C CA 2456339 C CA2456339 C CA 2456339C CA 2456339 A CA2456339 A CA 2456339A CA 2456339 A CA2456339 A CA 2456339A CA 2456339 C CA2456339 C CA 2456339C
Authority
CA
Canada
Prior art keywords
parameters
report
values
value
parameter
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
CA2456339A
Other languages
English (en)
French (fr)
Other versions
CA2456339A1 (en
Inventor
Brian Welcker
Christopher Hays
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
Microsoft Technology Licensing LLC
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, Microsoft Technology Licensing LLC filed Critical Microsoft Corp
Publication of CA2456339A1 publication Critical patent/CA2456339A1/en
Application granted granted Critical
Publication of CA2456339C publication Critical patent/CA2456339C/en
Anticipated expiration legal-status Critical
Expired - Fee Related legal-status Critical Current

Links

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/242—Query formulation
    • G06F16/2428—Query predicate definition using graphical user interfaces, including menus and forms
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99941—Database schema or data structure
    • Y10S707/99943—Generating database or data structure, e.g. via user interface

Landscapes

  • Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Data Mining & Analysis (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Human Resources & Organizations (AREA)
  • Strategic Management (AREA)
  • General Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • Mathematical Physics (AREA)
  • Quality & Reliability (AREA)
  • Operations Research (AREA)
  • Marketing (AREA)
  • Economics (AREA)
  • Human Computer Interaction (AREA)
  • Tourism & Hospitality (AREA)
  • Computational Linguistics (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Computer And Data Communications (AREA)
  • Stored Programmes (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
CA2456339A 2003-02-12 2004-01-28 Declarative sequenced report parameterization Expired - Fee Related CA2456339C (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US10/365,304 2003-02-12
US10/365,304 US7657552B2 (en) 2003-02-12 2003-02-12 Declarative sequenced report parameterization

Publications (2)

Publication Number Publication Date
CA2456339A1 CA2456339A1 (en) 2004-08-12
CA2456339C true CA2456339C (en) 2012-02-14

Family

ID=32681708

Family Applications (1)

Application Number Title Priority Date Filing Date
CA2456339A Expired - Fee Related CA2456339C (en) 2003-02-12 2004-01-28 Declarative sequenced report parameterization

Country Status (10)

Country Link
US (1) US7657552B2 (https=)
EP (1) EP1447757A3 (https=)
JP (1) JP5192634B2 (https=)
KR (1) KR101201019B1 (https=)
CN (1) CN1525359A (https=)
AU (1) AU2004200472B2 (https=)
BR (1) BRPI0400182A (https=)
CA (1) CA2456339C (https=)
MX (1) MXPA04001295A (https=)
RU (1) RU2340937C2 (https=)

Families Citing this family (24)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7657552B2 (en) * 2003-02-12 2010-02-02 Microsoft Corporation Declarative sequenced report parameterization
US7979841B2 (en) * 2003-07-28 2011-07-12 National Instruments Corporation Programmatically determining calling information of a graphical program
KR100697155B1 (ko) * 2004-12-03 2007-03-21 (주)엠투소프트 웹 서비스를 이용한 보고서 작성 시스템 및 그 방법
US8601383B2 (en) 2005-09-09 2013-12-03 Microsoft Corporation User interface for creating a spreadsheet data summary table
US8095866B2 (en) 2005-09-09 2012-01-10 Microsoft Corporation Filtering user interface for a data summary table
US7627812B2 (en) 2005-10-27 2009-12-01 Microsoft Corporation Variable formatting of cells
US7770100B2 (en) * 2006-02-27 2010-08-03 Microsoft Corporation Dynamic thresholds for conditional formats
US8712965B2 (en) 2006-06-29 2014-04-29 International Business Machines Corporation Dynamic report mapping apparatus to physical data source when creating report definitions for information technology service management reporting for peruse of report definition transparency and reuse
US9251222B2 (en) 2006-06-29 2016-02-02 International Business Machines Corporation Abstracted dynamic report definition generation for use within information technology infrastructure
US20080086400A1 (en) * 2006-09-15 2008-04-10 Carrie Ardelean Computerized credit services information management system
US8447771B2 (en) 2006-11-20 2013-05-21 Oracle International Corporation Query generation
CN101903887B (zh) * 2007-12-21 2014-06-11 皇家飞利浦电子股份有限公司 对临床决策支持系统的连续版本的半自动验证
US8572510B2 (en) * 2008-09-30 2013-10-29 Sap Ag Handling multiple dynamically-linked dropdowns in online applications
US9047338B2 (en) 2008-12-17 2015-06-02 International Business Machines Corporation Managing drill-through targets
CA2706741C (en) 2010-06-29 2011-12-13 Ibm Canada Limited - Ibm Canada Limitee Managing parameters in filter expressions
FR2989808B1 (fr) * 2012-04-24 2014-06-06 Thales Sa Systeme de gestion d'alertes et de procedures electroniques entierement parametrable destine a un aeronef
JP2014204316A (ja) * 2013-04-05 2014-10-27 日本放送協会 音響信号再生装置、音響信号作成装置
US9384236B2 (en) * 2013-06-14 2016-07-05 Sap Se Method and system for operating on database queries
US9208200B1 (en) * 2014-11-01 2015-12-08 Veeva Systems Inc. System and method for reporting multiple objects in enterprise content management
AU2017243870B2 (en) * 2016-03-31 2022-04-07 WiseTech Global (Licensing) Pty Ltd "Methods and systems for database optimisation"
CN109002427A (zh) 2017-06-06 2018-12-14 珠海金山办公软件有限公司 在电子表格中提示函数参数的方法、装置及电子设备
US11475008B2 (en) * 2020-04-28 2022-10-18 Capital One Services, Llc Systems and methods for monitoring user-defined metrics
US11836444B2 (en) 2020-06-26 2023-12-05 Adaptam Inc. Methods and systems for constructing a complex formula in a spreadsheet cell
US11977835B2 (en) 2021-05-24 2024-05-07 Adaptam Inc. Method and system for spreadsheet error identification and avoidance

Family Cites Families (28)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5261093A (en) * 1990-11-05 1993-11-09 David Saroff Research Center, Inc. Interactive relational database analysis with successive refinement steps in selection of ouput data from underlying database
RU2006647C1 (ru) 1991-01-28 1994-01-30 Алтайский политехнический институт им.И.И.Ползунова Система питания карбюраторного двигателя внутреннего сгорания
US5630069A (en) * 1993-01-15 1997-05-13 Action Technologies, Inc. Method and apparatus for creating workflow maps of business processes
US5787417A (en) * 1993-01-28 1998-07-28 Microsoft Corporation Method and system for selection of hierarchically related information using a content-variable list
GB9303873D0 (en) * 1993-02-25 1993-04-14 Massachusetts Inst Technology A computerized handbook of and tool for inventing organizational processes
US5603025A (en) * 1994-07-29 1997-02-11 Borland International, Inc. Methods for hypertext reporting in a relational database management system
US6160549A (en) * 1994-07-29 2000-12-12 Oracle Corporation Method and apparatus for generating reports using declarative tools
JP3670318B2 (ja) * 1994-08-30 2005-07-13 富士通株式会社 データ入力装置及びデータ入力方法
US5715444A (en) 1994-10-14 1998-02-03 Danish; Mohamed Sherif Method and system for executing a guided parametric search
ATE150562T1 (de) 1995-09-14 1997-04-15 Citibank Ag Computersystem zur datenverwaltung und verfahren zum betreiben dieses systems
US6625617B2 (en) * 1996-01-02 2003-09-23 Timeline, Inc. Modularized data retrieval method and apparatus with multiple source capability
EP0847019A1 (en) * 1996-12-04 1998-06-10 Koninklijke Philips Electronics N.V. Method and system for selecting an information item in an information processing system, and local station in such a system
US5852818A (en) * 1996-12-23 1998-12-22 Oracle Corporation Non-recursive method for parameter evaluation within an information management system
US5978787A (en) * 1997-02-28 1999-11-02 Oracle Corporation Report server caching
US6131098A (en) * 1997-03-04 2000-10-10 Zellweger; Paul Method and apparatus for a database management system content menu
US6236987B1 (en) * 1998-04-03 2001-05-22 Damon Horowitz Dynamic content organization in information retrieval systems
US6233583B1 (en) * 1998-09-10 2001-05-15 International Business Machines Corporation Report generator for use within a lotus notes database system
RU2186423C2 (ru) 1998-12-15 2002-07-27 Закрытое акционерное общество "Агентство "Гуманитарные технологии" Система тестирования "телетестинг"
US6460031B1 (en) * 1999-06-28 2002-10-01 Sap Aktiengesellschaft System and method for creating and titling reports using an integrated title bar and navigator
US7185279B2 (en) * 2000-01-07 2007-02-27 Master Mine Software, Inc. Data mining and reporting
JP2002041948A (ja) 2000-07-25 2002-02-08 Nec Corp 緊急情報配信システム
JP4752099B2 (ja) * 2000-09-29 2011-08-17 ソニー株式会社 情報提供装置及び情報提供方法並びにデータ記録媒体
AU2002223101A1 (en) 2000-12-01 2002-06-11 Mark Hopkins Product selection apparatus and method
JP2003016085A (ja) 2001-06-29 2003-01-17 Nippon Telegraph & Telephone West Corp コンテンツ検索システム、コンテンツ検索方法、コンテンツ検索プログラムおよび記録媒体
US7584425B2 (en) * 2001-07-31 2009-09-01 Verizon Business Global Llc Systems and methods for generating reports
US7657552B2 (en) * 2003-02-12 2010-02-02 Microsoft Corporation Declarative sequenced report parameterization
US20040193644A1 (en) * 2003-03-31 2004-09-30 Baker William P. Exposing a report as a schematized queryable data source
WO2005050476A1 (en) * 2003-10-29 2005-06-02 Sap Ag Sytems and methods for searching and displaying reports

Also Published As

Publication number Publication date
CA2456339A1 (en) 2004-08-12
BRPI0400182A (pt) 2004-12-28
RU2340937C2 (ru) 2008-12-10
RU2004104017A (ru) 2005-07-27
JP5192634B2 (ja) 2013-05-08
KR20040073343A (ko) 2004-08-19
AU2004200472A1 (en) 2004-09-02
AU2004200472B2 (en) 2009-08-06
MXPA04001295A (es) 2005-06-17
KR101201019B1 (ko) 2012-11-14
EP1447757A3 (en) 2006-04-19
US7657552B2 (en) 2010-02-02
EP1447757A2 (en) 2004-08-18
US20040158557A1 (en) 2004-08-12
JP2004246897A (ja) 2004-09-02
CN1525359A (zh) 2004-09-01

Similar Documents

Publication Publication Date Title
CA2456339C (en) Declarative sequenced report parameterization
US7013306B1 (en) XML input definition table for transforming XML data to internal format
US20060155692A1 (en) Dealing with composite data through data model entities
US7779050B2 (en) Method, apparatus, and system for data modeling and processing
US5886693A (en) Method and apparatus for processing data across a computer network
US7158969B2 (en) Iterative data analysis process via query result augmentation and result data feedback
US20050210000A1 (en) Semantic web portal graphic interface
EP1189148A1 (en) Document search and analysing method and apparatus
EP1367506A1 (en) System for providing information converted in response to search request
US20040158567A1 (en) Constraint driven schema association
EP2369480A2 (en) Mashup infrastructure with learning mechanism
KR20090005097A (ko) 웹 커뮤니티 및 웹 애플리케이션에 대해 데이터를 변환하는시스템 및 방법
WO2001033435A1 (en) Method and apparatus for automatically updating website content
US12602373B2 (en) System and method for generating database queries based on natural language input
US7158967B1 (en) XML output definition table for transferring internal data into XML document
US7007229B2 (en) Computer-implemented system and method for web-based data access
US8788929B2 (en) Script generation
US20080172601A1 (en) Tool for configuring available functions of an application
KR20010104871A (ko) 검색결과의 자동분류 기능을 갖는 인터넷 사이트 검색서비스 시스템
US7124135B1 (en) Step to access native script in a legacy database management system using XML message
US7143104B1 (en) Converter for XML document type definition to internal XML element mapping tree
US7315868B1 (en) XML element to source mapping tree
US7191167B1 (en) Step to save current table for later use
CN113407598A (zh) 需求文档的生成方法、装置、存储介质及电子设备
CA2510661A1 (en) Filter manager system and method of managing filter expressions

Legal Events

Date Code Title Description
EEER Examination request
MKLA Lapsed

Effective date: 20190128