Actuate Corporation

Informix Software, Inc.

Brian D Jackson

Jason Boehle

Kevin B Mayfield

Christopher W Maloney

Brian Killen

Kaleb C Axon

Kent A Tracy

Mark A Mills

Methods and apparatus for generating a report template for generation of a spreadsheet report are disclosed. First, a grid including a plurality of cells is displayed. One or more database fields for which data is to be obtained from a database are identified, where each of the database fields is associated with a separate group with which one or more rows in the grid can be associated. One or more groups as defined by the one or more database fields are then associated with a corresponding set of one or more rows in the grid, thereby associating cells within the set of rows with the corresponding group. A user may then enter information within one or more of the plurality of cells of the displayed grid, where the received information indicates at least one of a format of the spreadsheet report to be created and information to be displayed in one or more cells of the spreadsheet report. The report template is then generated from the received information such that the groups are associated with the received information corresponding to placement of the received information within the grid. The received information may, for instance, include a formula or formatting commands.

Methods and apparatus for generating a spreadsheet report template

Logical schemas are used to allow an end user the ability to access and manipulate relational database data without knowledge of the structure of the relational database. A logical schema is first created specifying which tables are available to an end user, and the relationships between columns of those tables. The logical schema defines a structure for the data fields having a master level and a plurality of detail levels. An end user may manipulate the logical schema using a graphical interface to build customized forms, reports, and queries. An end user is not required to be familiar with a database query language, such as SQL, or the structure of the relational database.

Logical schema to allow access to a relational database without using

Growing community of inventors

Belton, MO, United States of America

Brian D Jackson