Method, system, and software for automated generation of graphs from report data

• US 7,009,609 B2
• Filed: 03/29/2001
• Issued: 03/07/2006
• Est. Priority Date: 12/22/2000
• Status: Expired due to Term

• Current Assignee: UNIRITA, Inc.
• Original Assignee: BSP (Shanghai), Inc. (UNIRITA, Inc.)
• Inventors: Miyadai, Isao
• Primary Examiner(s): Bella, Matthew C.
• Assistant Examiner(s): TRAN, TAM D
• Application Number:
  US09/819,820
• Publication Number:
  US 20020140699A1
• Time in Patent Office: 1,804 Days
• Field of Search: 345/440, 345/440.1, 345/440.2, 345/441
• US Class Current: 345/440
• CPC Class Codes: G06F 16/9017 using directory or table look-up use of a directory or look-up table in file systems G06F16/13
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: G06T 11/206 Drawing of charts or graphs

Abstract

A computer implemented method, software, and system for automatically generating a graph from report data includes identifying a report format as having at least one first group at a first level having at least one detail line with at least two data fields in each of the detail lines. The first group further includes either a vertical total for each of a plurality of the respective data fields in the first group or a horizontal total for each of a plurality of the respective detail lines, with each particular vertical total totaling with each particular horizontal total totaling each of the data fields for that particular detail line. A user input is indicative of one of the totals, and a graph is automatically generated using a predefined rule corresponding to the one of the totals indicated by the user input.

Claims

1. A computer implemented method of automatically generating, in an application, a graph from report data derived from a previous report created by a different application, the method comprising the steps of:

identifying a report format as comprising at least one first group at a first level having at least one detail line with at least two data fields in each of the detail lines, wherein the first group further includes either a vertical total for each of a plurality of the respective data fields in the first group or a horizontal total for each of a plurality of the respective detail lines, with each particular vertical total totaling a corresponding data field for each detail line and with each particular horizontal total totaling each of the data fields for that particular detail line;

receiving a user input indicative of one of the totals; and

generating a graph using a predefined rule corresponding to the one of the totals indicated by the user input,

wherein the report format is hierarchical and further comprises a second group at a second level, each second group comprising one or more first groups, the second group including second group vertical totals, each second group vertical total aggregating all vertical totals for that data field for each first group in the second group, and

wherein report data comprises data from the previous report created by the different application and the report data does not include any previous data used to create the previous report, and wherein the predefined rule for generating a graph is derived from the identified report format of the previous report created by the different application.

2. The computer implemented method according to claim 1, wherein the predefined rule corresponding to a particular one of the vertical totals includes using each different value that formed that particular vertical total to form a different feature in said graph.

3. The computer implemented method according to claim 1, wherein the predefined rule corresponding to particular one of the horizontal totals includes using each different value that formed that particular detail line total to form a different feature in said graph.

4. The computer implemented method according to claim 2, wherein each different feature is a separate display component in said graph displayed on a graphical display.

5. The computer implemented method according to claim 3, wherein each different feature is a separate display component in said graph displayed on a graphical display.

6. The computer implemented method according to claim 1, wherein both vertical totals and horizontal totals are included in the previous report.

7. The computer implemented method according to claim 6, wherein the report format further comprises a cross total field that equals either the sum of the vertical totals or the sum of the horizontal totals.

8. The computer implemented method according to claim 7, further comprising:

receiving a user input indicative of one cross total field; and

generating a graph using a predefined rule corresponding to that one cross total field.

9. The computer implemented method according to claim 8, wherein the predefined rule corresponding to that one cross total field includes forming a different feature in said graph corresponding to either each vertical total or each horizontal total that formed said cross total field.

10. The computer implemented method as defined in claim 9, wherein the predefined rule corresponding to that one cross total field includes forming a first and a second graphs, with a different feature in said first graph corresponding to each vertical total that formed said cross total field and with a different feature in said second graph corresponding to each horizontal total that formed said cross total field.

11. The computer implemented method according to claim 1, wherein the second group vertical totals are formed in a line.

12. The computer implemented method according to claim 1, further comprising:

receiving a user input indicative of one of the second group vertical totals; and

generating a graph using a predefined rule corresponding to that one of the second group vertical totals.

13. The computer implemented method according to claim 12, wherein the predefined rule corresponding to a particular one of the second group vertical totals includes using each different first group vertical total that formed that second group vertical total to form a separate feature on said graph.

14. The computer implemented method according to claim 1, wherein each second group comprises at least two first groups.

15. The computer implemented method according to claim 1, wherein the hierarchical report format further comprises a third group at a third level, each third group comprising one or more second groups, the third group including respective third group vertical totals, each third group vertical total aggregating all second group totals for that data field for each second group in the third group.

16. The computer implemented method according to claim 15, wherein the third group vertical totals are formed in a line, and further comprising:

receiving a user input indicative of one of the third group vertical totals; and

generating a graph using a predefined rule corresponding to that one of the third group vertical totals.

17. The computer implemented method according to claim 15, wherein the predefined rule corresponding to a particular one of the third group vertical totals includes using each second group vertical total that formed that third group vertical total to form a separate feature on said graph.

18. The computer implemented method according to claim 1, wherein the received user input comprises clicking on a total.

19. The computer implemented method according to in claim 1, wherein the received user input comprises clicking on a total area that is of a different color than other areas.

25. The computer implemented method according to claim 2, wherein when a feature in said graph is designated, a report page number containing the value used to form the designated feature is displayed.

26. The computer implemented method according to claim 1, wherein the column location of vertical totals determines the column location of the data fields of all detail lines.

27. The computer implemented method according to claim 15, wherein predetermined control break characters define the location of the first and any other subsequent hierarchical groups.

59. The computer implemented method according to claim 1, further comprising:

highlighting or changing in color the one of the totals indicated by the user input; and

highlighting or changing in color data components that comprise the one of the totals indicated by the user input.

20. A computer implemented method of automatically generating, in an application, a graph from report data derived from a previous report created by a different application, the method comprising the steps of:

identifying a report format as comprising at least one first group at a first level having at least one detail line with at least two data fields in each of the detail lines, wherein the first group further includes either a vertical total for each of a plurality of the respective data fields in the first group or a horizontal total for each of a plurality of the respective detail lines, with each particular vertical total totaling a corresponding data field for each detail line and with each particular horizontal total totaling each of the data fields for that particular detail line;

receiving a user input indicative of one of the totals; and

generating a graph using a predefined rule corresponding to the one of the totals indicated by the user input,

wherein the predefined rule corresponding to a particular one of the vertical totals includes using each different value that formed that particular vertical total to form a different feature in said graph, and

wherein each of a plurality of the different features in said graph is linked to the corresponding different value used to form that feature, and wherein clicking on a feature displays the linked corresponding different value, and

wherein report data comprises data from previous report created by the different application and the report data does not include any previous data used to create the previous report, and wherein the predefined rule for generating a graph is derived from the identified report format of the previous report created by the different application.

22. The computer implemented method according to claim 20, wherein when a feature designation is received from a user, the report page containing the different value used to form that feature is displayed, and

wherein the step of generating a graph comprises using the identified report format to automatically identify the underlying report data corresponding to the one of the totals indicated by the user and using the automatically identified underlying report data to generate the graph.

23. The computer implemented method according to claim 22, wherein when the report page is displayed after receiving a designation of a feature, at least one value used to form the feature is displayed in a different manner relative to the other values on the report page.

24. The computer implemented method according to claim 20, wherein when the report page is displayed after receiving a designation of a feature, links to other pages used to form the feature are included in the display.

21. The A computer implemented method of automatically generating, in an application, a graph from report data derived from a previous report created by a different application, the method comprising the steps of:

identifying a report format as comprising at least one first group at a first level having at least one detail line with at least two data fields in each of the detail lines, wherein the first group further includes either a vertical total for each of a plurality of the respective data fields in the first group or a horizontal total for each of a plurality of the respective detail lines, with each particular vertical total totaling a corresponding data field for each detail line and with each particular horizontal total totaling each of the data fields for that particular detail line;

receiving a user input indicative of one of the totals; and

generating a graph using a predefined rule corresponding to the one of the totals indicated by the user input,

wherein the predefined rule corresponding to particular one of the horizontal totals includes using each different value that formed that particular detail line total to form a different feature in said graph, and

wherein each of a plurality of the different features in said graph is linked to the corresponding different value used to form that feature, and wherein clicking on a feature displays the linked corresponding different value, and

wherein report data comprises data from the previous report created by the different application and the report data does not include any previous data used to create the previous report, and wherein the predefined rule for generating a graph is derived from the identified report format of the previous report created by the different application.

28. In a computer display system that displays a graph, in an application, corresponding to report data derived from a previous report created by a different application, a method of displaying graph components comprising the steps of:

generating graph components corresponding to an identified report format comprising a first group at a first level having plural detail lines each having plural data fields and having either respective vertical total fields for each data field that totals that data field'"'"'s values in each of the detail lines or respective horizontal total fields for each detail line that totals all the data fields in one detail line;

highlighting either the vertical total fields or the horizontal total fields;

accepting user input only in the highlighted vertical total fields or the horizontal total fields; and

generating a graph based on user input in one of the highlighted vertical total fields or the horizontal total fields,

wherein the report format is hierarchical and further comprises a second group at a second level, each second group comprising one or more first groups, the second group including second group vertical totals, each second group vertical total aggregating all vertical totals for that data field for each first group in the second group, and

wherein report data comprises data from the previous report created by the different application and the report data does not include any previous data used to create the previous report, and wherein a predefined rule for generating a graph is derived from the identified report format of the previous report created by the different application.

29. A computer readable data storage medium having program code recorded thereon, that when executed, causes a computing system to automatically generate, in an application, a graph from report data derived from a previous report created by a different application, the program code comprising:

a first program code that identifies a report format as comprising at least one first group at a first level having at least one detail line with at least two data fields in each of the detail lines, wherein the first group further includes either a vertical total line for each of a plurality of the respective data fields in the first group or a horizontal total for each of the plurality of the detail lines, with each particular horizontal total totaling each of the data fields for that particular detail line;

a second program code that receives user input indicative of one of the totals; and

a third program code that generates a graph using a predetermined rule corresponding to the one of the totals indicated by the user input,

wherein the report format is hierarchical and further comprises a second group at a second level, each second group comprising one or more first groups, the second group including second group vertical totals, each second group vertical total aggregating all vertical totals for that data field for each first group in the second group, and

wherein report data comprises data from the previous report created by the different application and the report data does not include any previous data used to create the previous report, and wherein the predefined rule for generating a graph is derived from the identified report format of the previous report created by the different application.

30. The computer readable data storage medium according to claim 29, wherein the vertical totals are formed in a vertical total line.

31. The computer readable data storage medium according to claim 29, wherein the predefined rule corresponding to a particular one of the vertical totals includes using each different value that formed that particular vertical total to form a different feature in said graph.

32. The computer readable data storage medium according to claim 29, wherein the predefined rule corresponding to a particular one of the horizontal totals includes using each different value that formed that particular detail line total to form a different feature in said graph.

33. The computer readable data storage medium according to claim 31, wherein each different feature is a separate display component in said graph displayed on a graphical display.

34. The computer readable data storage medium according to claim 32, wherein each different feature is a separate display component in said graph displayed on a graphical display.

35. The computer readable data storage medium according to claim 29, wherein both vertical and horizontal totals are included in the previous report.

36. The computer readable data storage medium according to claim 35, wherein the report format further comprises a cross total field that equals either the sum of the vertical totals or the sum of the horizontal totals.

37. The computer readable data storage medium according to claim 36, wherein the second program code receives a user input indicative of one cross total field, and

wherein said third program code generates a graph using a predefined rule corresponding to that one cross total field.

38. The computer readable data storage medium according to claim 37, wherein the predefined rule corresponding to that one cross total field includes forming a different feature in said graph corresponding to either each vertical total or each horizontal total that formed said cross total field.

39. The computer readable data storage medium according to claim 38, wherein the predefined rule corresponding to that one cross total field includes forming a first and second graphs, with a different feature in said first graph corresponding to each vertical total that formed said cross total field and with a different feature in said second graph corresponding to each horizontal total that formed said cross total field.

40. The computer readable data storage medium according to claim 29, wherein the second group vertical totals are formed in a line.

41. The computer readable data storage medium according to claims 29, wherein the second program code is programmed to receive a user input indicative of one of the second group vertical totals, and the third program code is programmed to generate a graph using a predefined rule corresponding to that one of the second group vertical totals.

42. The computer readable data storage medium according to claim 41, wherein the predefined rule corresponding to a particular one of the second group vertical totals includes using each different first group vertical total that formed that second group vertical total to form a separate feature on said graph.

43. The computer readable data storage medium according to claim 29, wherein each second group comprises at least two first groups.

44. The computer readable data storage medium according to claim 29, wherein the hierarchical report format further comprises a third group at a third level, each third group comprising one or more second groups, the third group including respective third group vertical totals, each third group vertical total aggregating all second group totals for that data field for each second group in the third group.

45. The computer readable data storage medium according to claim 44, wherein the third group vertical totals are formed in a line, and wherein the second program code is programmed to receive a user input indicative of one of the third group vertical totals;

and the third program code generates a graph using a predefined rule corresponding to that one of the third group vertical totals.

46. The computer readable data storage medium according to claim 44, wherein the predefined rule corresponding to a particular one of the third group vertical totals includes using each second group vertical total that formed that third group vertical total to form a separate feature on said graph.

47. The computer readable data storage medium according to claim 29, wherein the received user input comprises clicking on a total.

48. The computer readable data storage medium according to claim 29, wherein the received user input comprises clicking on a total area that if of different color that other areas.

54. The computer readable data storage medium according to claim 31, wherein when a feature in said graph is designated, a report page number containing the value used to form the designated feature is displayed.

55. The computer readable data storage medium according to claim 29, wherein the column location of vertical totals determines the column location of the data fields of all detail lines.

56. The computer readable data storage medium according to claim 29, wherein predetermined control break characters define the location of the first and any subsequent hierarchical groups.

49. A computer readable data storage medium having program code recorded thereon for automatically generating, in an application, a graph from report data derived from a previous report created by a different application, the program code comprising:

a first program code that identifies a report format as comprising at least one first group at a first level having at least one detail line with at least two data fields in each of the detail lines, wherein the first group further includes either a vertical total line for each of a plurality of the respective data fields in the first group or a horizontal total for each of the plurality of the detail lines, with each particular horizontal total totaling each of the data fields for that particular detail line;

a second program code that receives user input indicative of one of the totals; and

a third program code that generates a graph using a predefined rule corresponding to the one of the totals indicated by the user input,

wherein the predefined rule corresponding to a particular one of the vertical totals includes using each different value that formed that particular vertical total to form a different feature in said graph,

wherein each of a plurality of the different features in said graph is linked to the corresponding different value used to form that feature, and wherein clicking on a feature displays the linked corresponding different value, and

wherein report data comprises data from the previous report created by the different application and the report data does not include any previous data used to create the previous report, and wherein the predefined rule for generating a graph is derived from the identified report format of the previous report created by the different application.

51. The computer readable data storage medium according to claim 49, wherein when a feature designation is received from a user, the report page containing the different value used to form that feature is displayed.

52. The computer readable data storage medium according to claim 51, wherein when the report page is displayed after receiving a designation of a feature, at least one value used to form the feature is displayed in a different manner relative to other values on the report page.

53. The computer readable data storage medium according to claim 49, wherein when the report page is displayed after receiving a designation of a feature, links to other pages used to form the feature are included in the display.

50. A computer readable data storage medium having program code recorded thereon for automatically generating, in an application, a graph from report data derived from a previous report created by a different application, the program code comprising:

a first program code that identifies a report format as comprising at least one first group at a first level having at least one detail line with at least two data fields in each of the detail lines, wherein the first group further includes either a vertical total line for each of a plurality of the respective data fields in the first group or a horizontal total for each of the plurality of the detail lines, with each particular horizontal total totaling each of the data fields for that particular detail line;

a second program code that receives user input indicative of one of the totals; and

a third program code that generates a graph using a predefined rule corresponding to the one of the totals indicated by the user input,

wherein the predefined rule corresponding to a particular one of the horizontal totals includes using each different value that formed that particular detail line total to form a different feature in said graph,

wherein each of a plurality of the different features in said graph is linked to the corresponding different value used to form that feature, and wherein clicking on a feature displays the linked corresponding different value, and

wherein report data comprises data from the previous report created by the different application and the report data does not include any previous data used to create the previous report, and wherein the predefined rule for generating a graph is derived from the identified report format of the previous report created by the different application.

57. A system for automatically generating, in an application, a graph from report data derived from a previous report created by a different application, the system comprising:

means for identifying and normalizing a report format as comprising at least one first group at a first level having at least one detail line with at least two data fields in each of the detail lines, wherein the first group further includes either a vertical total line for each of a plurality of the respective data fields in the first group or a horizontal total for each of the plurality of the detail lines, with each particular horizontal total totaling each of the data fields for that particular detail line;

user interaction means for receives a user input indicative of one of the total; and

a graph generator means for generating a graph by using a predefined rule corresponding to one of the totals indicated by the user input,

wherein the report format is hierarchical and further comprises a second group at a second level, each second group comprising one or more first groups, the second group including second group vertical totals, each second group vertical total aggregating all vertical totals for that data field for each first group in the second group, and

wherein report data comprises data from the previous report created by the different application and the report data does not include any previous data used to create the previous report, and wherein the predefined rule for generating a graph is derived from the identified report format of the previous report created by the different application.

58. A system for automatically generating a graph, in an application, from report data derived from a previous report created by a different application, the system comprising:

a report unit that identifies a report format as comprising at least one first group at a first level having at least one detail line with at least two data fields in each of the detail lines, wherein the first group further includes either a vertical total line for each of a plurality of the respective data fields in the first group or a horizontal total for each of the plurality of the detail lines, with each particular horizontal total totaling each of the data fields for that particular detail line;

a user interaction unit that receives a user input indicative of one of the total; and

a graph generator that generates a graph by using a predefined rule corresponding to one of the totals indicated by the user input,

wherein the report format is hierarchical and further comprises a second group at a second level, each second group comprising one or more first groups, the second group including second group vertical totals, each second group vertical total aggregating all vertical totals for that data field for each first group in the second group,

wherein report data comprises data from the previous report created by the different application and the report data does not include any previous data used to create the previous report, and wherein the predefined rule for generating a graph is derived from the identified report format of the previous report created by the different application.

60. The computer implemented method of automatically generating, in an application, a graph from report data derived from a previous report created by a different application, the method comprising the steps of:

identifying a report format as comprising at least one first group at a first level having at least one detail line with at least two data fields in each of the detail lines, wherein the first group further includes either a vertical total for each of a plurality of the respective data fields in the first group or a horizontal total for each of a plurality of the respective detail lines, with each particular vertical total totaling a corresponding data field for each detail line and with each particular horizontal total totaling each of the data fields for that particular detail line;

receiving a user input indicative of one of the totals; and

generating a graph using a predefined rule corresponding to the one of the totals indicated by the user input,

wherein the step of generating a graph comprises;

extracting corresponding data for the one of the totals from a series of reports; and

generating a graph displaying a different feature for each of the extracted corresponding data, and

wherein report data comprises data from the previous report created by the different application and the report data does not include any previous data used to create the previous report, and wherein the predefined rule for generating a graph is derived from the identified report format of the previous report created by the different application.

61. The computer implemented method according to claim 60, wherein the series of reports represents a time series of a particular report.