Systems and methods for controlling report properties based on aggregate scope

• US 20060026498A1
• Filed: 07/30/2004
• Published: 02/02/2006
• Est. Priority Date: 07/30/2004
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Wang, Fang, Hays, Christopher Alan, Carlson, Jason D.
• Application Number:
  US10/903,306
• Publication Number:
  US 20060026498A1
• Time in Patent Office: Days
• US Class Current: 715/234
• CPC Class Codes: G06F 16/248 Presentation of query results

Abstract

A plurality of scope declarations can be provided to delineate various portions of any data structure, such as a matrix, a table, or a chart. Some scope declarations may correspond to portions of a horizontal axis, or columns, while other scope declarations may correspond to portions of a vertical axis, or rows. Thus, the aggregate scope at any given location within a data structure may vary, depending on which scope declarations overlap at the given location. Properties can be set for a location of a data structure based on this aggregate scope, thereby providing increased control flexibility.

Claims

1. A computer readable medium bearing instructions for generating a report, comprising:

instructions for retrieving data specified in a report definition file from a data source;

instructions for formatting said data into a plurality of columns;

instructions for associating a first identifier with at least one column;

instructions for associating a second identifier with said at least one column;

instructions for determining an aggregate scope for a location within said at least one column, wherein the aggregate scope comprises a sum of identifiers associated with said column; and

instructions for identifying at least one property corresponding to the aggregate scope.

2. The computer readable medium of claim 1, wherein the at least one property comprises an evaluation region for a function that returns a value for display in the location.

3. The computer readable medium of claim 2, wherein the evaluation region is described using said first identifier.

4. The computer readable medium of claim 1, further comprising instructions for storing the aggregate scope in a scope log to avoid repeating said instructions for determining an aggregate scope.

5. The computer readable medium of claim 1, wherein the at least one property comprises a function that returns a value for display in the location.

6. The computer readable medium of claim 1, wherein the at least one property comprises a drillthrough property.

7. The computer readable medium of claim 1, wherein the at least one property comprises one or more of a text formatting property, a color formatting property, and a shading formatting property.

8. The computer readable medium of claim 1, wherein the format is a matrix format.

9. The computer readable medium of claim 1, wherein the format is a format for a region of a report.

10. A method for generating a report, comprising:

reading a report definition file that specifies a format for a plurality of columns, and data to be placed in the columns;

associating a first identifier at least one column;

associating a second identifier with said at least one column;

determining an aggregate scope for a location within the at least one column, wherein the aggregate scope comprises a sum of identifiers associated with said column.

11. The method of claim 10, further comprising identifying at least one property corresponding to the aggregate scope.

12. The method of claim 11, wherein the at least one property comprises one or more of a text formatting property, a color formatting property, and a shading formatting property.

13. The method of claim 11, wherein the at least one property comprises an evaluation region for a function that returns a value for display in the location.

14. The method of claim 13, wherein the evaluation region is described using one of said first and said second identifier.

15. The method of claim 11, wherein the at least one property comprises a function that returns a value for display in the location.

16. The method of claim 11, wherein the at least one property comprises a drillthrough property.

17. The method of claim 10, further comprising providing the at least one property to the location within said columns and rows.

18. The method of claim 10, wherein the format is a matrix format.

19. The method of claim 10, wherein the format is a format for a region of a report.

20. The method of claim 10, wherein report definition file comprises an Extensible Markup Language (XML) file.

21. The method of claim 10, further comprising storing the aggregate scope in a scope log to avoid repeating said determining an aggregate scope.

22. A means for generating a report, comprising:

means for reading a report definition filethat specifies a format for a plurality of columns, and data to be placed in the columns;

means for associating a first identifier at least one column;

means for associating a second identifier with said at least one column;

means for determining an aggregate scope for a location within the at least one column, wherein the aggregate scope comprises a sum of identifiers associated with said column.

23. The means for generating a report of claim 22, further comprising identifying at least one property corresponding to the aggregate scope.

24. The means for generating a report of claim 23, wherein the at least one property comprises one or more of a text formatting property, a color formatting property, and a shading formatting property.

25. The means for generating a report of claim 23, wherein the at least one property comprises an evaluation region for a function that returns a value for display in the location.

26. The means for generating a report of claim 23, wherein the at least one property comprises a function that returns a value for display in the location.

27. The means for generating a report of claim 23, wherein the at least one property comprises a drillthrough property.

28. The means for generating a report of claim 22, further comprising providing the at least one property to the location within said columns and rows.

29. The means for generating a report of claim 22, wherein the format is a matrix format.

30. The means for generating a report of claim 22, wherein the format is a format for a region of a report.

31. A computer readable medium bearing instructions for deriving at least one property of a data structure, comprising:

instructions for generating a data structure with a plurality of axes, including a first axis and a second axis;

instructions for processing a plurality of identifiers corresponding to at least one portion of at least one of said plurality of axes, wherein said at least one portion corresponds to at least one location of said data structure, and wherein said instructions for processing comprise instructions for correlating said plurality of scope declarations with said at least one location to calculate a a collection of overlapping identifiers associated with said at least one location.