DATABASE FORM AND REPORT CREATION AND REUSE

• US 20090248740A1
• Filed: 04/02/2009
• Published: 10/01/2009
• Est. Priority Date: 11/20/2007
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: McMinn, Ryan, Gardner, Scott T., Coggins, Robert E., Bould, Jason A., McCormack, Michael J., Miller, Andrew R., Chauhan, Sumit, Conger, David J.
• Application Number:
  US12/417,508
• Publication Number:
  US 20090248740A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases

Abstract

Embodiments are provided for creating and reusing database forms and reports. A selection of an object may be received from a database by a database software application executing on a computer system. The object may include a form or a report. The application may further receive an input to initiate saving the selected object as a new form template or a new report template. In response to receiving the input, the application may be configured to generate a dialog for receiving the selected object and save the selected object as a new form template or a new report template. Any controls, sub-forms, sub-reports, properties, macros, code, and object model references which may be included in the selected object are persisted in the newly created templates for reuse.

Claims

1. A computer-implemented method for creating and reusing database forms and reports, comprising:

receiving, by the computer, a selection of an object from a database, the object comprising at least one of a form and a report, the at least one of a form and a report comprising at least one of a plurality of properties associated with the at least one of a form and a report and at least one of a macro, code, and an object model reference associated with the at least one of a form and a report;

receiving an input to save the selected object as at least one of a new form template and a new report template;

in response to receiving the input, generating a dialog for receiving the selected object; and

saving the selected object as the at least one of a new form template and a new report template, wherein the plurality of form controls and the plurality of report objects from the selected object are persisted in the at least one of a new form template and a new report template for reuse.

2. The method of claim 1, wherein saving the selected object as the at least one of a new form template and a new report template comprises saving at least one of a sub-form and a sub-report associated with the at least one of a form and a report.

3. The method of claim 1, wherein saving the selected object as the at least one of a new form template and a new report template comprises saving a plurality of properties associated with the at least one of a form and a report.

4. The method of claim 1, wherein saving the selected object as the at least one of a new form template and a new report template comprises saving at least one of a macro, code, and an object model reference associated with the at least one of a form and a report.

5. The method of claim 1, wherein saving the selected object as the at least one of a new form template and a new report template comprises:

receiving a selection of at least one of a default form template and a report template; and

opening the at least one of an default form template and a report template.

6. The method of claim 5, wherein saving the selected object as the at least one of a new form template and a new report template further comprises binding the selected object to a plurality of existing fields in the at least one of a default form template and a report template to save the selected object as the at least one of a new form template and a new report template.

7. The method of claim 5, wherein saving the selected object as the at least one of a new form template and a new report template further comprises determining whether the selected object comprises a tag property having a NoInsert string and, if not, then inserting and binding a plurality of fields in the selected object to the at least one of a default form template and a report template to save the selected object as the at least one of a new form template and a new report template.

8. The method of claim 7, wherein binding a plurality of fields in the selected object to the at least one of a template form and a template report to save the selected object as the at least one of a new form template and a new report template comprises mapping table ID and field ID pairs for each of the plurality of fields to bind the selected object to the at least one of an default form template and a report.

9. A computer system for creating and reusing database forms and reports, comprising:

a memory for storing executable program code; and

a processor, functionally coupled to the memory, the processor being responsive to computer-executable instructions contained in the program code and operative to;

receive a selection of an object from a database, the object comprising at least one of a form and a report, the at least one of a form and a report comprising at least one of a plurality of properties associated with the at least one of a form and a report and at least one of a macro, code, and an object model reference associated with the at least one of a form and a report;

receive an input to save the selected object as at least one of a new form template and a new report template;

in response to receiving the input, generate a dialog for receiving the selected object; and

save the selected object as the at least one of a new form template and a new report template, wherein the plurality of form controls and the plurality of report objects from the selected object are persisted in the at least one of a new form template and a new report template for reuse.

10. The system of claim 9, wherein the processor in saving the selected object as the at least one of a new form template and a new report template, is operative to save at least one of a sub-form and a sub-report associated with the at least one of a form and a report.

11. The system of claim 9, wherein the processor in saving the selected object as the at least one of a new form template and a new report template, is operative to save the plurality of properties associated with the at least one of a form and a report.

12. The system of claim 9, wherein the processor in saving the selected object as the at least one of a new form template and a new report template, is operative to save the at least one of a macro, code, and an object model reference associated with the at least one of a form and a report.

13. The system of claim 9, wherein the processor in saving the selected object as the at least one of a new form template and a new report template, is operative to:

receive a selection of at least one of an default form template and a report template; and

open the at least one of an default form template and a report template.

14. The system of claim 13, wherein the processor in saving the selected object as the at least one of a new form template and a new report template is further to bind the selected object to a plurality of existing fields in the at least one of a default form template and a report template to save the selected object as the at least one of a new form template and a new report template.

15. The system of claim 13, wherein the processor in saving the selected object as the at least one of a new form template and a new report template is further operative to determine whether the selected object comprises a tag property has a NoInsert string and, if not, then the processor is operative to insert and bind a plurality of fields in the selected object to the at least one of a default form template and a report template to save the selected object as the at least one of a new form template and a new report template.

16. The system of claim 15, wherein the processor in binding a plurality of fields in the selected object to the at least one of a template form and a template report to save the selected object as the at least one of a new form template and a new report template, is further operative to map table ID and field ID pairs for each of the plurality of fields to bind the selected object to the at least one of an default form template and a report.

17. A computer-readable storage medium containing computer executable instructions which, when executed on a computer, will cause the computer to perform a method for creating and reusing database forms and reports, comprising:

receiving a selection of an object from a database, the object comprising at least one of a form and a report, the at least one of a form and a report comprising at least one of a sub-form and a sub-report associated with the at least one of a form and a report, a plurality of properties associated with the at least one of a form and a report and at least one of a macro, code, and an object model reference associated with the at least one of a form and a report;

receiving an input to save the selected object as at least one of a new form template and a new report template;

in response to receiving the input, generating a dialog for receiving the selected object; and

saving the selected object as the at least one of a new form template and a new report template, wherein the plurality of form controls and the plurality of report objects from the selected object are persisted in the at least one of a new form template and a new report template for reuse, and wherein saving the selected object as the at least one of a new form template and a new report template comprises;

receiving a selection of at least one of an default form template and a report template; and

opening the at least one of an default form template and a report template.

18. The computer-readable storage medium of claim 17, wherein saving the selected object as the at least one of a new form template and a new report template further comprises binding the selected object to a plurality of existing fields in the at least one of a default form template and a report template to save the selected object as the at least one of a new form template and a new report template.

19. The computer-readable storage medium of claim 17, wherein saving the selected object as the at least one of a new form template and a new report template further comprises:

determining whether the selected object comprises a tag property having a NoInsert string; and

if not, then inserting and binding a plurality of fields in the selected object to the at least one of a default form template and a report template to save the selected object as the at least one of a new form template and a new report template.

20. The computer-readable storage medium of claim 17, wherein binding a plurality of fields in the selected object to the at least one of a template form and a template report to save the selected object as the at least one of a new form template and a new report template comprises mapping table ID and field ID pairs for each of the plurality of fields to bind the selected object to the at least one of an default form template and a report.