RAPID SOFTWARE REPORT DEVELOPMENT TOOL WITH AUTO DATABASE HANDLING AND MENU TOOL-BAR PLUG-IN FOR APPLICATION REPORT ACCESS

• US 20100229084A1
• Filed: 03/06/2009
• Published: 09/09/2010
• Est. Priority Date: 03/06/2009
• Status: Active Grant

• Current Assignee: Ecava Sdn. Bhd.
• Original Assignee: Ecava Sdn. Bhd.
• Inventors: WONG, Kin Hoon, LEE, Kok Peng, LEE, Kwee Hui, WONG, Foot Yow
• Granted Patent: US 8,453,053 B2
• Time in Patent Office: Days
• US Class Current: 715/249
• CPC Class Codes: G06Q 10/10 Office automation; Time management

Abstract

A method is provided for generating reports for a computer monitored or aided environment that has a server-side module, a client-side module and a database, the server-side module, client-side module and database being interconnected, The method includes creating a report layout, the report layout containing a predefined number of dynamic fields at predetermined positions; associating, at the server-side, each dynamic field with a data source; collecting, at the server-side, information for each dynamic field according to the associated data source; storing the information in the database; and displaying the information for each dynamic field on a display according to the report layout. The report layout is shared universally for the generation of a displayed report and a printed report.

Claims

1. A method for generating reports for a computer monitored or aided environment that comprises a server-side module, a client-side module and a database, the server-side module, client-side module and database being interconnected,

the method comprising

creating a report layout, the report layout containing a predefined number of dynamic fields at predetermined positions;

associating, at the server-side, each dynamic field with a data source;

collecting, at the server-side, information for each dynamic field according to the associated data source;

storing the information in the database; and

displaying the information for each dynamic field on a display according to the report layout;

wherein said report layout is shared universally for the generation of a displayed report and a printed report.

2. A method for generating reports for a computer monitored or aided environment according to claim 1, wherein the server-side module parses the report layout, extracts the dynamic field and collects the information for each dynamic field for the report, and stores the information in the database with a time stamp according to a timer.

3. A method for generating reports for a computer monitored or aided environment according to claim 1, wherein the server-side module parses the report layout, extracts the dynamic field and collects the information for each dynamic field for the report, and stores the information in the database upon the user'"'"'s command.

4. A method for generating reports for a computer monitored or aided environment according to claim 2, wherein the server-side module assigns storage address to the information for each dynamic field before storing the information into the database.

5. A method for generating reports for a computer monitored or aided environment according to claim 4, wherein said storage address comprises database name, table name and column name.

6. A method for generating reports for a computer monitored or aided environment according to claim 4, wherein the storage address is predetermined by the report layout.

7. A method for generating reports for a computer monitored or aided environment according to claim 6, wherein said storage address comprises database name, table name and column name.

8. A method for generating reports for a computer monitored or aided environment according to claim 1, wherein the client-side module displays a tool-bar like graphic user interface comprising interactive buttons on the display for report handling.

9. A method for generating reports for a computer monitored or aided environment according to claim 2, wherein the client-side module polls the collected information for each dynamic field within the database and provides the user with the option to

a) save a displayed report,

b) open a saved report from said database,

c) close a report on the display,

d) view a real-time dynamic report,

e) print the displayed report,

f) delete a saved report from said database, or

g) export the displayed report to Comma Separated Values (CSV), HTML or XML file formats.

10. A method for generating reports for a computer monitored or aided environment according to claim 2, the method further comprising:

generating said displayed report.

11. A method for generating reports for a computer monitored or aided environment according to claim 2, the method further comprising:

generating said printed report.

12. A method for generating reports for a computer monitored or aided environment according to claim 9, wherein a format of said printed report is in correspondence to a format of said displayed report.

16. A method for generating reports for a computer monitored or aided environment according to claim 3, wherein the server-side module assigns storage address to the information for each dynamic field before storing the information into the database.

17. A method for generating reports for a computer monitored or aided environment according to claim 16, wherein said storage address comprises database name, table name and column name.

18. A method for generating reports for a computer monitored or aided environment according to claim 16, wherein the storage address is predetermined by the report layout.

19. A method for generating reports for a computer monitored or aided environment according to claim 18, wherein said storage address comprises database name, table name and column name.

20. A method for generating reports for a computer monitored or aided environment according to claim 3, wherein the client-side module polls the collected information for each dynamic field within the database and provides the user with the option to

a) save a displayed report,

b) open a saved report from said database,

c) close a report on the display,

d) view a real-time dynamic report,

e) print the displayed report,

f) delete a saved report from said database, or

g) export the displayed report to Comma Separated Values (CSV), HTML or XML file formats.

13. A system for generating reports for a computer monitored or aided environment that comprises a server-side module, a client-side module, and a database, the server-side module, client-side module and database being interconnected, the system comprising:

a tool for creating a report layout, the report layout containing a predefined number of dynamic fields at predetermined positions;

a storage device containing computer code to associate each dynamic field with a data source; and

a logger in the server-side module for collecting information for each dynamic field according to the associated data source;

wherein said report layout is shared universally for the generation of a displayed report and a printed report, using a graphical user interface in the client-side module.

14. A method for generating reports for a computer monitored or aided environment according to claim 13, wherein the server-side module parses the report layout, extracts the dynamic field and collects the information for each dynamic field for the report, and stores the information in the database with a time stamp according to a timer.

15. A method for generating reports for a computer monitored or aided environment according to claim 13, wherein the server-side module parses the report layout, extracts the dynamic field and collects the information for each dynamic field for the report, and stores the information in the database upon the user'"'"'s command.