US6613099B2 — Process and system for providing a table view of …

Claim 1

Independent Claim 185 words

A method of creating a report format suitable for displaying data associated with one or more of a plurality of database records, the method comprising: obtaining a first layout, the first layout including a plurality of database fields having associated formatting information, the first layout being a first report format adapted for displaying data associated with one or more database records; creating a second layout from the first layout such that the second layout includes one or more of the plurality of database fields, the second layout being a report format adapted for displaying data associated with the plurality of database records such that data values associated with the same database field are displayed adjacent to one another; and associating at least a portion of the formatting information of the first layout with the one or more of the plurality of database fields in the second layout such that the second layout includes the at least a portion of the formatting information from the first layout, the second layout being a second report format adapted for displaying data associated with one or more database records.

Claim 2

Independent Claim 185 words

A method of creating a report format suitable for displaying data associated with one or more of a plurality of database records, the method comprising: obtaining a first layout, the first layout including a plurality of database fields having associated formatting information, the first layout being a first report format adapted for displaying data associated with one or more database records; creating a second layout from the first layout such that the second layout includes one or more of the plurality of database fields, the second layout being a report format adapted for displaying data associated with the plurality of database records such that data values associated with the same database field are displayed adjacent to one another; and associating at least a portion of the formatting information of the first layout with the one or more of the plurality of database fields in the second layout such that the second layout includes the at least a portion of the formatting information from the first layout, the second layout being a second report format adapted for displaying data associated with one or more database records.

Claim 3

Dependent Claim 30 words

The method as recited in claim 1 , further comprising: providing the second layout using the formatting information associated with the one or more of the plurality of database fields.

Claim 4

Dependent Claim 33 words

The method as recited in claim 1 , wherein the first layout is adapted for at least one of obtaining and displaying data for a single one of the plurality of database records.

Claim 5

Dependent Claim 21 words

The method as recited in claim 1 , wherein the formatting information identifies the order of the plurality of database fields.

Claim 6

Dependent Claim 21 words

The method as recited in claim 1 , wherein the plurality of database records are stored in one or more databases.

Claim 7

Dependent Claim 24 words

The method as recited in claim 1 , wherein the first layout is a form layout and the second layout is a table layout.

Claim 8

Independent Claim 210 words

A method of creating a report format suitable for displaying data associated with one or more of a plurality of database records, the method comprising: obtaining a first layout, the first layout including a body defining a plurality of database fields having a specified order and associated attributes, each of the associated attributes having a corresponding attribute value, the first layout being a first report format adapted for displaying data associated with one or more database records; creating a second layout from the first layout such that the second layout includes selected ones of the plurality of database fields, the second layout being a report format adapted for displaying a plurality of database records such that data values associated with the same database field of the plurality of database records are displayed adjacent to one another; and copying attribute values corresponding to at least some of the attributes associated with the plurality of database fields from the first layout to the second layout such that the second layout includes the attribute values corresponding to at least some of the attributes associated with the plurality of database fields from the first layout, the second layout being a second report format adapted for displaying data associated with one or more database records.

Claim 9

Independent Claim 210 words

A method of creating a report format suitable for displaying data associated with one or more of a plurality of database records, the method comprising: obtaining a first layout, the first layout including a body defining a plurality of database fields having a specified order and associated attributes, each of the associated attributes having a corresponding attribute value, the first layout being a first report format adapted for displaying data associated with one or more database records; creating a second layout from the first layout such that the second layout includes selected ones of the plurality of database fields, the second layout being a report format adapted for displaying a plurality of database records such that data values associated with the same database field of the plurality of database records are displayed adjacent to one another; and copying attribute values corresponding to at least some of the attributes associated with the plurality of database fields from the first layout to the second layout such that the second layout includes the attribute values corresponding to at least some of the attributes associated with the plurality of database fields from the first layout, the second layout being a second report format adapted for displaying data associated with one or more database records.

Claim 10

Dependent Claim 41 words

The method as recited in claim 7 , the first layout being adapted for displaying a plurality of records such that values associated with the same database field of the plurality of database records are not displayed adjacent to one another.

Claim 11

Dependent Claim 24 words

The method as recited in claim 7 , wherein the first layout is a form layout and the second layout is a table layout.

Claim 12

Independent Claim 245 words

A method of displaying data associated with one or more of a plurality of database records, the method comprising: obtaining a first layout, the first layout including a body defining a plurality of fields having a specified order and associated attributes, each of the associated attributes having a corresponding attribute value, the first layout being adapted for displaying one or more records such that database fields associated with a single one of the database records are displayed in multiple rows or columns, the first layout being a first report format adapted for displaying data associated with one or more database records; creating a second layout from the first layout such that the second layout includes selected ones of the plurality of fields, the second layout being adapted for displaying a plurality of database records such that values associated with the same database field of the plurality of database records are displayed in a single row or column; copying attribute values corresponding to at least some of the attributes associated with the plurality of database fields from the first layout to the second layout such that the second layout includes the attribute values corresponding to the at least some of the attributes associated with the plurality of database fields from the first layout, the second layout being a second report format adapted for displaying data associated with one or more database records; and displaying data associated with the plurality of database records in the second layout.

Claim 13

Independent Claim 245 words

A method of displaying data associated with one or more of a plurality of database records, the method comprising: obtaining a first layout, the first layout including a body defining a plurality of fields having a specified order and associated attributes, each of the associated attributes having a corresponding attribute value, the first layout being adapted for displaying one or more records such that database fields associated with a single one of the database records are displayed in multiple rows or columns, the first layout being a first report format adapted for displaying data associated with one or more database records; creating a second layout from the first layout such that the second layout includes selected ones of the plurality of fields, the second layout being adapted for displaying a plurality of database records such that values associated with the same database field of the plurality of database records are displayed in a single row or column; copying attribute values corresponding to at least some of the attributes associated with the plurality of database fields from the first layout to the second layout such that the second layout includes the attribute values corresponding to the at least some of the attributes associated with the plurality of database fields from the first layout, the second layout being a second report format adapted for displaying data associated with one or more database records; and displaying data associated with the plurality of database records in the second layout.

Claim 14

Dependent Claim 18 words

The method as recited in claim 10 , wherein displaying the second layout comprises printing the second layout.

Claim 15

Dependent Claim 47 words

The method as recited in claim 10 , wherein said creating of the second layout comprises: creating one or more columns in the second layout; and identifying each of the selected ones of the plurality of database fields with one of the columns in the second layout.

Claim 16

Dependent Claim 46 words

The method as recited in claim 12 , wherein said creating of the second layout further comprises creating a column header for each one of the columns in the second layout, each column header identifying one of the selected ones of the plurality of database fields.

Claim 17

Dependent Claim 216 words

A computer readable medium including computer code for providing a table layout suitable for use in displaying data associated with one or more of a plurality of database records, comprising: computer code for displaying a form layout, the form layout including a body defining a plurality of database fields having a specified order and associated attributes, each of the associated attributes having a corresponding attribute value, the form layout being a first report format adapted for displaying data associated with one or more database records; computer code for creating a table layout from the form layout such that the table layout includes the plurality of database fields, the table layout being adapted for displaying a plurality of database records such that values associated with the same database field of the plurality of records are displayed adjacent to one another; and computer code for transferring attribute values corresponding to at least some of the attributes associated with the plurality of database fields from the form layout to the table layout such that the table layout includes the attribute values corresponding to at least some of the attributes associated with the plurality of database fields from the form layout, the table layout being a second report format adapted for displaying data associated with one or more database records.

Claim 18

Dependent Claim 216 words

A computer readable medium including computer code for providing a table layout suitable for use in displaying data associated with one or more of a plurality of database records, comprising: computer code for displaying a form layout, the form layout including a body defining a plurality of database fields having a specified order and associated attributes, each of the associated attributes having a corresponding attribute value, the form layout being a first report format adapted for displaying data associated with one or more database records; computer code for creating a table layout from the form layout such that the table layout includes the plurality of database fields, the table layout being adapted for displaying a plurality of database records such that values associated with the same database field of the plurality of records are displayed adjacent to one another; and computer code for transferring attribute values corresponding to at least some of the attributes associated with the plurality of database fields from the form layout to the table layout such that the table layout includes the attribute values corresponding to at least some of the attributes associated with the plurality of database fields from the form layout, the table layout being a second report format adapted for displaying data associated with one or more database records.

Claim 19

Dependent Claim 29 words

The computer readable medium as recited in claim 14 , further comprising: computer code for assigning default attribute values to selected ones of the attributes in the table layout.

Claim 20

Dependent Claim 47 words

The computer readable medium as recited in claim 14 , further comprising: computer code for making modifications to selected ones of the plurality of database fields of the form layout; and computer code for modifying the table layout to include the modifications made to the form layout.

Claim 21

Dependent Claim 45 words

The computer readable medium as recited in claim 14 , further comprising: computer code for making modifications to selected ones of the attribute values of the form layout; and computer code for modifying the table layout to include the modifications made to the form layout.

Claim 22

Dependent Claim 71 words

The computer readable medium as recited in claim 14 , further comprising: computer code for deleting one of the plurality of database fields from the form layout; computer code for deleting the one of the plurality of database fields from the table layout; and computer code for copying attribute values from the form layout to the table layout for each of the plurality of database fields that have not been deleted.

Claim 23

Dependent Claim 45 words

The computer readable medium as recited in claim 14 , further comprising: computer code for reordering selected ones of the plurality of database fields in the table layout such that the order of the plurality of the database fields in the form layout remains unchanged.

Claim 24

Dependent Claim 100 words

The computer readable medium as recited in claim 14 , wherein said computer code for creating the table layout comprises: computer code for identifying selected ones of the plurality of database fields in the form layout that have an associated order; computer code for determining whether one or more of the plurality of database fields in the table layout have been reordered; and computer code for copying the selected ones of the plurality of database fields from the form layout to the table layout when it is determined that the database fields in the table layout have not been reordered.

Claim 25

Independent Claim 180 words

A method of providing a first format suitable for use in displaying data associated with one or more of a plurality of records, the first format being obtained at least in part from a second format, the method comprising: obtaining the second format, the second format including a body defining a plurality of database fields having a specified order and associated attributes, each of the associated attributes having a corresponding attribute value; providing the first format such that the first format includes the plurality of database fields, the first format being a first report format adapted for displaying data associated with one or more database records; and copying attribute values corresponding to at least some of the attributes associated with the plurality of database fields from the second format to the first format such that the first format includes the attribute values corresponding to at least some of the attributes associated with the plurality of database fields from the second format, the second format being a second report format adapted for displaying data associated with one or more database records.

Claim 26

Independent Claim 180 words

A method of providing a first format suitable for use in displaying data associated with one or more of a plurality of records, the first format being obtained at least in part from a second format, the method comprising: obtaining the second format, the second format including a body defining a plurality of database fields having a specified order and associated attributes, each of the associated attributes having a corresponding attribute value; providing the first format such that the first format includes the plurality of database fields, the first format being a first report format adapted for displaying data associated with one or more database records; and copying attribute values corresponding to at least some of the attributes associated with the plurality of database fields from the second format to the first format such that the first format includes the attribute values corresponding to at least some of the attributes associated with the plurality of database fields from the second format, the second format being a second report format adapted for displaying data associated with one or more database records.

Claim 27

Dependent Claim 23 words

The method as recited in claim 21 , further comprising displaying data associated with the plurality of database records in the first format.

Claim 28

Dependent Claim 38 words

The method as recited in claim 21 , wherein database fields of the second format are defined by rows of the second format and database fields of the first format are defined by columns of the first format.

Claim 29

Dependent Claim 23 words

The method as recited in claim 23 , further comprising at least one of reordering and resizing one or more of the columns.

Claim 30

Dependent Claim 18 words

The method as recited in claim 23 , further including sorting data associated with one of the columns.

Claim 31

Dependent Claim 44 words

The method as recited in claim 21 , wherein the first format is a table format adapted for displaying a plurality of records such that values associated with the same database field of the plurality of database records are displayed adjacent to one another.

Claim 32

Dependent Claim 43 words

The method as recited in claim 21 , further comprising: associating attribute values with selected attributes of the plurality of database fields of the first format such that the attribute values associated with the selected attributes override attribute values of the second format.

Claim 33

Dependent Claim 28 words

The method as recited in claim 21 , wherein the attributes and associated attribute values together identify at least one of color, degree of rotation, and font size.

Claim 34

Dependent Claim 46 words

The method as recited in claim 21 , further comprising: modifying selected ones of the plurality of database fields of the second format; and modifying the first format to incorporate the modifications to the selected ones of the plurality of database fields of the second format.

Claim 35

Dependent Claim 37 words

The method as recited in claim 29 , wherein modifying selected ones of the plurality of database fields of the second format includes deleting the selected ones of the plurality of database fields of the second format.

Claim 36

Dependent Claim 88 words

The method as recited in claim 29 , wherein the first format has a first modification count and the second format has a second modification count, the method further comprising: determining whether the first modification count and the second modification count are equal; and when it is determined that the first modification count and the second modification count are not equal, modifying the first format to incorporate the modifications to the selected ones of the plurality of fields of the second format and updating the first modification count.

Claim 37

Dependent Claim 54 words

The method as recited in claim 21 , further comprising: modifying attribute values associated with attributes corresponding to selected ones of the plurality of database fields of the second format; and modifying the first format to incorporate the modifications to the attribute values associated with the selected ones of the plurality of database fields.

Claim 38

Dependent Claim 90 words

The method as recited in claim 32 , wherein the first format has a first modification count and the second format has a second modification count, the method further comprising: determining whether the first modification count and the second modification count are equal; and when it is determined that the first modification count and the second modification count are not equal, modifying the first format to incorporate the modifications to the attribute values associated with the selected ones of the plurality of database fields and updating the first modification count.

Claim 39

Dependent Claim 45 words

The method as recited in claim 21 , wherein the second format further includes at least one of a header and a footer, the method further comprising: copying at least one of the header and the footer from the second format to the first format.

Claim 40

Dependent Claim 80 words

The method as recited in claim 21 , wherein providing the first format comprises: adding a first set of the plurality of fields to the first format while maintaining the specified order, each one of the first set of the plurality of fields having a position associated with the specified order; and adding a second set of the plurality of fields to the first format, wherein the second set of the plurality of fields is unrelated to the specified order.

Claim 41

Dependent Claim 29 words

The method as recited in claim 35 , wherein adding the first set and the second set of the plurality of fields comprises using a set of default attributes.

Claim 42

Dependent Claim 59 words

The method as recited in claim 35 , further comprising: ascertaining a maximum height of all added fields, the added fields including the first set of the plurality of fields and the second set of the plurality of fields; and resizing the plurality of fields for the first format in accordance with the maximum height of the added fields.

Claim 43

Dependent Claim 25 words

The method as recited in claim 37 , wherein resizing further comprises determining the maximum height based upon a font associated with the added fields.

Claim 44

Dependent Claim 22 words

The method as recited in claim 37 , wherein resizing further comprises determining a width of each of the plurality of fields.

Claim 45

Dependent Claim 36 words

The method as recited in claim 39 , wherein determining the width of each of the plurality of fields comprises determining a data type and number of cells associated with each of the plurality of fields.

Claim 46

Dependent Claim 68 words

The method as recited in claim 35 , wherein adding the first set of the plurality of fields comprises: determining whether the plurality of fields in the first format have been reordered; and copying the first set of the plurality of fields to the first format while maintaining the specified order when it is determined that the plurality of fields in the first format have not been reordered.

Claim 47

Dependent Claim 42 words

The method as recited in claim 35 , wherein adding the second set of the plurality of fields comprises: copying non-related fields from the second format to the first format; and copying related fields from the second format to the first format.

Claim 48

Dependent Claim 25 words

The method as recited in claim 21 , wherein the specified order is set by at least one of user input and a default order.

Claim 49

Dependent Claim 38 words

The method as recited in claim 21 , wherein providing the first format comprises modifying the first format while maintaining the specified order of the plurality of database fields that have not been reordered in the first format.

Claim 50

Dependent Claim 46 words

The method as recited in claim 21 , wherein providing the first format comprises modifying the first format such that the specified order of the plurality of database fields is maintained when none of the plurality of database fields have been reordered in the first format.

Claim 51

Independent Claim 160 words

A method of providing a table layout of a form layout including a body defining a plurality of database fields having a specified order and associated attributes, each of the associated attributes having a corresponding attribute value, the method comprising: including the plurality of database fields in the table layout, the table layout being a first report format adapted for displaying data associated with one or more database records; deleting one of the plurality of database fields from the form layout, the form layout being a second report format adapted for displaying data associated with one or more database records; marking for deletion the deleted one of the plurality of database fields in the table layout; and copying attribute values for each unmarked one of the plurality of database fields from the form layout to the table layout such that the table layout includes the attribute values for each unmarked one of the plurality of fields from the form layout.

Claim 52

Independent Claim 160 words

A method of providing a table layout of a form layout including a body defining a plurality of database fields having a specified order and associated attributes, each of the associated attributes having a corresponding attribute value, the method comprising: including the plurality of database fields in the table layout, the table layout being a first report format adapted for displaying data associated with one or more database records; deleting one of the plurality of database fields from the form layout, the form layout being a second report format adapted for displaying data associated with one or more database records; marking for deletion the deleted one of the plurality of database fields in the table layout; and copying attribute values for each unmarked one of the plurality of database fields from the form layout to the table layout such that the table layout includes the attribute values for each unmarked one of the plurality of fields from the form layout.

Claim 53

Dependent Claim 24 words

The method as recited in claim 46 , further including deleting each of the plurality of database fields that have been marked for deletion.

Claim 54

Dependent Claim 38 words

The method as recited in claim 46 , wherein the form layout further includes non-body fields including at least one of a header and a footer, the method further comprising: deleting the non-body fields from the table layout.

Claim 55

Dependent Claim 17 words

The method as recited in claim 46 , further comprising identifying the unmarked fields as body fields.

Annuity Stage	Window Opens	Payment Deadline	Surcharge Period Until	Estimated Fee	Status
3.5 Years (Year 4)	2006-09-01	2007-03-03	2007-09-02	$2000.00	Window Closed / Lapsed
7.5 Years (Year 8)	2010-09-01	2011-03-03	2011-09-02	$3760.00	Window Closed / Lapsed
11.5 Years (Year 12)	2014-09-01	2015-03-03	2015-09-02	$7700.00	Window Closed / Lapsed

Process and system for providing a table view of a form layout for a database

Abstract

Inventors

Bibliographic Details

Claims Analysis

References Cited (Backward Citations)

USPTO Annuity & Maintenance Windows

Assigned Categories & Tags

Assign Category Tag