Creating cross-tabular reports

摘要

Cross-tabular reports may be automatically created by a computer from received source data. After receiving the source data, the computer may determine different information types associated with fields contained in the source data. The computer may then score each field based on the information types. A score describes a suitable placement of each field as a cross-tabular report row, a cross-tabular report column or a cross-tabular report value field. The computer may then select the fields having the highest score for placement as cross-tabular report rows, cross-tabular report columns or cross-tabular report value fields in a cross-tabular report. Finally, the computer may build the cross-tabular report with the selected fields.

主权项

1. A computer-implemented method of creating cross-tabular reports, comprising:
receiving, by the computer, source data comprising a plurality of fields; determining, by the computer, a plurality of different information types associated with each of the plurality of fields; scoring, by the computer, each of the plurality of fields based on the plurality of different information types, for a suitable placement of each of the plurality of fields as at least one of a cross-tabular report row, a cross-tabular report column and a cross-tabular report value field in a cross-tabular report; selecting, by the computer, from among the plurality of fields, one or more fields having the highest score for placement as the at least one of the cross-tabular report row, the cross-tabular report column and the cross-tabular report value field in the cross-tabular report; and building, by the computer, the cross-tabular report with the selected one or more fields having the highest score.