IP Library Granted Patent US 9,146,958
Granted Patent B2
US 9,146,958 · App. 13/949,446 · Granted Sep 29, 2015

System and method for report to report generation

View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 9,146,958
App. No.
13/949,446
Granted
Sep 29, 2015
Kind
B2
Abstract

In an example embodiment a sender report containing multiple rows and/or columns of information drawn from a data table may be displayed to a user of a machine. A user may select a portion of the displayed information. A sender adaptor may extract report-to-report selection criteria from the selected information. A receiver adaptor may identify other data tables where information related to the report-to-report selection criteria resides. If such information resides in multiple data tables, the receiver adaptor may join the multiple data tables into one or more data tables. The receiver adaptor may convert the report-to-report selection criteria into selection criteria for the identified data table(s) or joined data table(s). The selection criteria may be passed to a generic receiver report adapted to retrieve any information from any data table(s). The generic receiver report may retrieve information according to the selection criteria and display the information to the user.

Claims (39)

1. A method comprising:

receiving from a sender report, using a processor of a machine, a selection of some or all information from the sender report, the sender report generated from a first data table and displayed on a display device of the machine;

creating, based on the selection, a selection criteria that identifies at least one additional data table where information related to the selection resides;

sending the selection criteria to a receiver report adapted to receive selection criteria and adapted to select information from a data table; and

selecting information from the at least one additional data table based on the selection criteria.

2. The method of claim 1 wherein the at least one additional data table resides in a database separate from the first data table.

3. The method of claim 1 wherein the selection comprises a plurality of information contained in rows and/or columns of the sender report and wherein the creating operation produces information to identify the information contained in the rows and/or columns of the sender report.

4. The method of claim 3 , further comprising creating database operations to join multiple additional data tables before selecting information based on the selection criteria.

5. The method of claim 4 , wherein the multiple additional data tables reside in a database separate from the first data table.

6. The method of claim 3 , wherein the selection criteria comprises multiple selection criteria.

7. The method of claim 1 wherein creating the selection criteria comprises:

identifying data fields, data values, or combinations thereof contained in rows, or columns, or combinations thereof, of the selection from the sender report; and

placing the identified data fields, data values, or combinations thereof in a format for sending to the receiver report.

8. A system comprising:

memory;

a computer processor coupled to the memory;

instructions stored in the memory and executable by the processor, the instructions comprising:

a sender report to display report results produced in accordance with the sender report and to receive a selection of some or all of the displayed report results;

a sender adaptor to receive the selection from the sender report, and to extract a report-to-report selection criteria from the selection;

a receiver adaptor to obtain the report-to-report selection criteria, to identify a target data table where information resides relating to the report-to-report selection criteria, and to create a selection criteria for the target data table from the report-to-report selection criteria; and

a receiver report to receive the selection criteria for the target data table and to execute the selection criteria for the target data table.

9. The system of claim 8 , wherein the instructions further comprise a report-to-report adaptor to receive the report-to-report selection criteria and to provide the report-to-report selection criteria to the receiver adaptor.

10. The system of claim 9 , wherein the report-to-report adaptor is further configured to store the report-to-report selection criteria.

11. The system of claim 8 , wherein the receiver adaptor is further configured:

to identify multiple target data tables where information relating to the report-to-report selection criteria resides; and

to create database operations to join the multiple target data tables.

12. The system of claim 11 , wherein the selection criteria operates on joined multiple target data tables.

13. The system of claim 8 , wherein the sender report is further configured to extract displayed information from a sender data table and wherein the sender data table and the target data table reside in different databases.

14. The system of claim 8 , wherein the selection comprises multiple displayed information and wherein the report-to-report selection criteria includes criteria for the multiple displayed information.

15. A non-transitory machine-readable storage medium comprising instructions that, when executed by at least one processor of a machine, perform operations comprising:

receive a selection of information from a report generated from a first data table and displayed on a display device of the machine;

create a selection criteria based on the selection;

send the selection criteria to a generic report, the generic report adapted to select information from any data table where data relevant to the selection criteria reside; and

select information based on the selection criteria.

16. The non-transitory machine-readable storage medium of claim 15 , wherein the data relevant to the selection criteria reside in data table in a database separate from a database where the first data table resides.

17. The non-transitory machine-readable storage medium of claim 15 , wherein the selection comprises a plurality of information and wherein the selection criteria selects data from multiple additional data tables.

18. The non-transitory machine-readable storage medium of claim 17 , wherein the multiple additional data tables reside in a database separate from the first data table.

19. The non-transitory machine-readable storage medium of claim 17 , wherein the instructions further configure the machine to create database operations to join the multiple additional data tables before selecting information based on the selection criteria.

20. The non-transitory machine-readable storage medium of claim 19 , wherein the instructions further configure the machine to modify the selection criteria to extract information from the joined multiple additional data tables.

Assignments (2)
CHANGE OF NAME Recorded Aug 26, 2014
From: SAP AG
To: SAP SE
Reel/Frame 033625/0223 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jul 24, 2013
From: VALENTIN, MARCO; GAERTNER, CHRISTIAN
To: SAP AG
Reel/Frame 030865/0012 →