PERSISTING INSTANCE-LEVEL REPORT CUSTOMIZATIONS
Various technologies and techniques are disclosed for persisting instance-level report customizations. Input is received from a user to run an original report. An original query associated with the original report is executed against a data store. The original report is displayed to the user. At least one instance-level customization is received from the user to customize an instance of the original report. The instance-level customizations that the user makes to the customized report are tracked in a manner that allows a history of changes from the original report to the customized report to be determined. The customized report is generated in subsequent executions of the report. The instance-level changes the user made to the report can be audited to allow users to see the changes made to the original report.
Latest Microsoft Patents:
- ULTRA DENSE PROCESSORS WITH EMBEDDED MICROFLUIDIC COOLING
- Automatic Binary Code Understanding
- Personalized Branding with Prompt Adaptation in Large Language Models and Visual Language Models
- CODING ACTIVITY TASK (CAT) EVALUATION FOR SOURCE CODE GENERATORS
- ARTIFICIAL INTELLIGENCE INFERENCING VIA DELTA MODELS
This application is a continuation of allowed U.S. application Ser. No. 11/413,227, filed on Apr. 28, 2006, which is incorporated by reference herein in its entirety.
BACKGROUNDWhen creating a report, it is common in certain scenarios for the user to desire to customize the actual instance data returned by the report. These customizations include renaming items/editing values, re-ordering items, creating ad-hoc groupings of items, and collapsing multiple items into a single item. While making such changes manually is fairly straightforward in a spreadsheet or similar application, such an approach can be difficult to repeat, reverse, and audit. With some reporting applications, the user is also able to make such changes to the data, but the changes cannot be audited and are lost the next time the report is run.
SUMMARYVarious technologies and techniques are disclosed for persisting instance-level report customizations. Input is received from a user to run an original report. An original query associated with the original report is executed against a data store. The original report is displayed to the user. At least one instance-level customization is received from the user to customize the instance data of the original report. The instance-level customizations that the user makes to the customized report are tracked in a manner that allows a history of changes from the original report to the customized report to be determined. The customized report is generated in subsequent executions of the report. The instance-level changes the user made to the report can be audited to allow users to see the changes made to the original report.
This Summary was provided to introduce a selection of concepts in a simplified form that are further described below in the Detailed Description. This Summary is not intended to identify key features or essential features of the claimed subject matter, nor is it intended to be used as an aid in determining the scope of the claimed subject matter.
For the purposes of promoting an understanding of the principles of the invention, reference will now be made to the embodiments illustrated in the drawings and specific language will be used to describe the same. It will nevertheless be understood that no limitation of the scope is thereby intended. Any alterations and further modifications in the described embodiments, and any further applications of the principles as described herein are contemplated as would normally occur to one skilled in the art.
The system may be described in the general context as a report builder application, but the system also serves other purposes in addition to these. In one implementation, one or more of the techniques described herein can be implemented as features within a program such as MICROSOFT® SQL Server Report Builder, or from any other type of program or service that allows a user to create and/or manipulate reports.
As shown in
Additionally, device 100 may also have additional features/functionality. For example, device 100 may also include additional storage (removable and/or non-removable) including, but not limited to, magnetic or optical disks or tape. Such additional storage is illustrated in
Computing device 100 includes one or more communication connections 114 that allow computing device 100 to communicate with other computers/applications 115. Device 100 may also have input device(s) 112 such as keyboard, mouse, pen, voice input device, touch input device, etc. Output device(s) 111 such as a display, speakers, printer, etc. may also be included. These devices are well known in the art and need not be discussed at length here. In one implementation, computing device 100 includes report builder application 200. Report builder application 200 will be described in further detail in
Turning now to
Report builder application 200 includes program logic 204, which is responsible for carrying out some or all of the techniques described herein. Program logic 204 includes logic for allowing a user to create and execute a report 206; logic for displaying a report to the user in an original format 208; logic for allowing a user to make instance-level customizations to a report 210; logic for tracking instance-level customizations a user makes to the report (e.g. by modifying and annotating the original query or by creating a wrapper query) 212; logic for generating the report in the modified format in subsequent executions of the report 214; logic for displaying a report to the user in the modified format 216; logic for allowing a user to audit the report to see the original version and/or the customizations 218; and other logic for operating the application 220. In one implementation, program logic 204 is operable to be called programmatically from another program, such as using a single call to a procedure in program logic 204.
Turning now to
The procedure begins at start point 240 with the user creating an original report designed to answer a particular question (without customizations) and selecting an option to run the report (stage 242). The system receives the user input, executes the original query against data store, and generates report (stage 244). The system displays the report to the user (stage 246). The user customizes the report and the system receives the user customizations (stage 248). The system tracks changes the user makes to the report so the report with the customizations can be recreated and the series of changes can be audited (stage 250). The system creates a modified query for the changes (e.g. persists the modifications) (stage 251). The user (same or different user) selects an option to run the report again (stage 252). The system generates the report in the modified format (stage 254). The modified report is displayed to the user (stage 255). The process ends at end point 256.
Let's take a look at a non-limiting hypothetical example of how this could work. Given an instance Q immediately following the new position of ZYX Corp., the new sort field has a custom formula that returns one of three values:
-
- 1=the instance is not ZYX Corp. and would normally be sorted before Q (based on the remaining sort fields).
- 2=the instance is ZYX Corp.
- 3=the instance is not ZYX Corp. and would normally be sorted at or after Q.
The modified query is used to generate subsequent versions of the report that includes the changes to the sort order of the instance groups (stage 326). The process ends at end point 328.
-
- SWITCH(IN(<InstanceRef>, {Key1, Key2, Key3}), “Group1”, IN(<InstanceRef>, {Key4,Key5}, “Group2”, . . . )
The modified query is used to generate subsequent versions of the report that includes the ad-hoc groupings of the items (stage 346). The process ends at end point 348.
Turning now to
Although the subject matter has been described in language specific to structural features and/or methodological acts, it is to be understood that the subject matter defined in the appended claims is not necessarily limited to the specific features or acts described above. Rather, the specific features and acts described above are disclosed as example forms of implementing the claims. All equivalents, changes, and modifications that come within the spirit of the implementations as described herein and/or by the following claims are desired to be protected.
For example, a person of ordinary skill in the computer software art will recognize that the client and/or server arrangements, user interface screen content, and/or data layouts as described in the examples discussed herein could be organized differently on one or more computers to include fewer or additional options or features than as portrayed in the examples.
In an embodiment, a method for persisting instance-level report customizations comprises the steps of: receiving input from a user to run an original report; executing an original query associated with the original report against a data store; displaying the original report to the user; receiving at least one instance-level customization from the user to customize an instance of original data displayed in the original report; tracking the at least one instance-level customization that the user makes to the customized report in a manner that allows a history of changes from the original report to the customized report to be determined; and generating the customized report in a subsequent run of the original report.
In the method, the tracking step may comprise: revising the original query to implement the at least one instance-level customization; and annotating the original query so the at least one instance-level customization made to the original query can be audited.
In the method, the tracking step may comprise: generating a wrapper query that can be executed after the original query to take the original data from the original query and further manipulate the original data to achieve the at least one instance-level customization.
In the method, the at least one instance-level customization may include changing a value of a particular field for a particular one or more instances in the original report.
In the method, the customization may be persisted using a custom formula that returns the changed value for the particular field for the particular one or more instances and returns an original value for the particular field for all remaining records.
In the method, the at least one instance-level customization may include changing a position of an instance within a group of instances sorted by one or more fields.
In the method, the customization may be persisted using a new sort field that has a custom formula that produces the changed position of the instance.
In the method, the at least one instance-level customization may include creating an ad-hoc grouping of items.
In the method, the ad-hoc grouping of items may be achieved by inserting a new group whose grouping expression is a formula.
In the method, the at least one instance-level customization may include collapsing multiple instances into a single instance.
In the method, the customization may be persisted by wrapping a grouping expression of an affected group into a custom formula that returns a new value for each value in the affected group being combined and an original value for all other values in the affected group.
In an embodiment, a computer-readable medium has computer-executable instructions for causing a computer to perform the steps of the method.
In an embodiment, a computer-readable medium has computer-executable instructions for causing a computer to perform steps comprising: provide a user with an ability to make one or more instance-level customizations in a report; track the one or more instance-level customizations the user makes to the report; generate the report in a modified format that includes the one or more instance-level customizations on subsequent runs of the report; and provide a feature to allow the user to audit the report to see how an original version of the report was modified by the one or more instance-level customizations.
According to the computer-readable medium, the one or more instance-level customizations may be tracked by updating an original query for the report with the one or more instance-level changes and a corresponding one or more annotations to describe what changed.
According to the computer-readable medium, the one or more instance-level customizations may be tracked by creating a wrapper query for the report to further filter an original query result set to achieve the one or more instance-level customizations.
In an embodiment, a method for auditing changes made to an instance of a report comprises the steps of: tracking one or more instance-level changes a user makes to a report; receiving a request from a user to audit the report to see what changes were made to the report from an original version of the report; and displaying at least a portion of the one or more instance-level changes to the user.
In the method, the displaying step may comprise: displaying a modified query with annotations describing the one or more instance-level changes.
In the method, the displaying step may comprise: displaying a wrapper query that was used to generate the report with the one or more instance-level customizations.
In the method, the displaying step may comprise: displaying a visual indicator near a particular field in a user interface of a reporting application to indicate visually that the particular field was changed.
In an embodiment, a computer-readable medium has computer-executable instructions for causing a computer to perform the steps recited in the method.
Claims
1. A method for persisting report customizations comprising:
- receiving at least one customization to customize an instance of original data of an original report that was generated by executing a first query against a data store, the at least one customization including a change to a value of a field in the original report;
- tracking the at least one customization in a manner that allows a history of changes from the original report to be determined; and
- generating at least one query configured to achieve the at least one customization in a customized report that is a customized version of the original report.
2. The method of claim 1, further comprising:
- maintaining the at least one query for subsequent execution against the data store to generate the customized report.
3. The method of claim 1, further comprising:
- enabling the user to audit changes made to the original report due to the at least one customization at least by displaying the changes made to the original report with annotations describing the changes.
4. The method of claim 1, wherein said generating comprises:
- modifying the first query to implement the at least one customization.
5. The method of claim 1, wherein said generating comprises:
- generating a second query that can be executed after the first query to take the original data from the first query and further manipulate the original data to achieve the at least one customization.
6. The method of claim 1, said receiving comprises:
- receiving a changed value of a particular field for a particular one or more instances of the field in the original report;
- receiving a change to a position of an instance of original data within a group of instances of original data sorted by one or more fields;
- receiving an ad-hoc grouping of items; or
- receiving a collapsing of multiple instances of original data into a single instance.
7. The method of claim 6, wherein the customization is persisted using a new sort field that has a custom formula that produces the changed position of the instance.
8. The method of claim 6, wherein the ad-hoc grouping of items is achieved by inserting a new group whose grouping expression is a formula.
9. The method of claim 6, wherein the customization is persisted by wrapping a grouping expression of an affected group into a custom formula that returns a new value for each value in the affected group being combined and an original value for all other values in the affected group.
10. The method of claim 1, further comprising:
- displaying the at least one customization in a user interface.
11. The method of claim 1, further comprising:
- displaying the generated at least one query in a user interface.
12. The method of claim 1, further comprising:
- displaying the history of changes in a user interface.
13. The method of claim 1, wherein said displaying comprises:
- displaying a visual indicator in association with a particular field in a user interface of a reporting application to indicate that the particular field was changed.
14. A computing device, comprising:
- at least one processing unit; and
- memory that stores computer readable instructions, the at least one processing unit configured to execute the computer readable instructions to enable the computing device to: enable a user to make one or more customizations in a report generated by executing an original query on a data store; track the at least one customization; generate at least one query configured to achieve the at least one customization in a customized report that is a customized version of the original report; and maintain the at least one query for subsequent execution against the data store to generate the customized report.
15. The computing device of claim 14, wherein the at least one processing unit is configured to execute the computer readable instructions to enable the computing device to:
- enable the user to audit changes made to the original report due to the at least one customization at least by displaying the changes made to the original report with annotations describing the changes.
16. The computing device of claim 14, wherein to generate the at least one query, the at least one processing unit is configured to execute the computer readable instructions to enable the computing device to:
- modify the original query to implement the at least one customization.
17. The computing device of claim 14, wherein to generate the at least one query, the at least one processing unit is configured to execute the computer readable instructions to enable the computing device to:
- generate a second query that can be executed after the original query to take original data from the original query and further manipulate the original data to achieve the at least one customization.
18. The computing device of claim 14, wherein to enable a user to make one or more customizations in the report, the at least one processing unit is configured to execute the computer readable instructions to enable the computing device to:
- receive a changed value of a particular field for a particular one or more instances of the field in the original report;
- receive a change to a position of an instance of original data within a group of instances of original data sorted by one or more fields;
- receive an ad-hoc grouping of items; or
- receive a collapsing of multiple instances of original data into a single instance.
19. The computing device of claim 14, wherein the at least one processing unit is configured to execute the computer readable instructions to enable the computing device to:
- display the at least one customization in a user interface.
20. The computing device of claim 14, wherein to display the at least one customization in a user interface, the at least one processing unit is configured to execute the computer readable instructions to enable the computing device to:
- display a visual indicator in association with a particular field in a user interface of a reporting application to indicate that the particular field was changed.
21. The computing device of claim 14, wherein the generated at least one query is displayed in a user interface.
22. The computing device of claim 14, wherein a history of tracked customizations is displayed in a user interface.
23. The computing device of claim 14, wherein the at least one customization includes a change to a value of a field in the original report.
24. A computer storage medium that stores computer-executable instructions for causing a computer to perform acts, comprising:
- enabling a user to make one or more customizations in a report generated by executing an original query on a data store;
- tracking the at least one customization;
- generating at least one query configured to achieve the at least one customization in a customized report that is a customized version of the original report; and
- maintaining the at least one query for subsequent execution against the data store to generate the customized report.
25. The computer storage medium of claim 24, wherein said generating comprises:
- modifying the original query to implement the at least one customization.
26. The computer storage medium of claim 24, wherein said generating comprises:
- generating a second query that can be executed after the original query to take original data from the original query and further manipulate the original data to achieve the at least one customization.
27. The computer storage medium of claim 24, the acts further comprising:
- displaying the at least one customization in a user interface.
28. The computer storage medium of claim 24, the acts further comprising:
- displaying the generated at least one query in a user interface.
29. The computer storage medium of claim 24, the acts further comprising:
- displaying a history of tracked customizations in a user interface.
30. The computer storage medium of claim 24, wherein said displaying comprises:
- displaying a visual indicator in association with a particular field in a user interface of a reporting application to indicate that the particular field was changed.
31. The computer storage medium of claim 24, wherein the at least one customization includes a change to a value of a field in the original report.
32. The computer storage medium of claim 24, the acts further comprising:
- enabling the user to audit changes made to the original report due to the at least one customization at least by displaying the changes made to the original report with annotations describing the changes.
Type: Application
Filed: Feb 17, 2014
Publication Date: Jun 12, 2014
Applicant: Microsoft Corporation (Redmond, WA)
Inventor: Robert A. Meyers (Redmond, WA)
Application Number: 14/182,133
International Classification: G06F 17/30 (20060101);