Method and system for a flexible-data column user interface
In embodiments there are provided techniques for flexibly displaying information into one or more columns. One technique includes the user interface (UI) receiving from an end user a selection of display criteria configured by an administrative user. Data from a dataset may be selected and/or ordered for displaying according to the criterion selected by the end user. Alternative embodiments may provide displaying positive and negative data, sorting, and fixed locations.
1. A method of generating data for display by a user system, comprising:
receiving a request for a report from a data source;
generating data for display assembled from the data source responsive to the received request, wherein
the data for display in the report includes a plurality of fixed-data columns retrieved from the data source, at least one flexible-data column, and a control for the flexible-data column retrieved from the data source,
the fixed data columns are part of the report and data fields of the fixed data columns are not user customizable, and
the flexible-data column is user customizable by using the control to select one from a set of enumerated data fields that can alternatively be displayed in the flexible-data column, including at least two data fields having distinct data formats, including a textual format and a graphical format; wherein each of the data fields in the set of enumerated data fields corresponds to a different characteristic of an object represented by a row of the report;
responsive to selection of one of the enumerated data fields of a distinct data format, causing retrieval of data corresponding to a characteristic of the distinct data format specific to each row of the report and display of the retrieved characteristic in
the flexible-data column for each row; and
sending the generated data for display to the user system.
2. The method of claim 1 , wherein generating data for display further includes:
the data for display modifies a data display format of the flexible-data column responsive to a data format of the selected data field.
3. The method of claim 1 , wherein the control responds to hovering over one from the set of enumerated data fields by enabling display of selected data field values in the flexible-data column.
4. The method of claim 1 , wherein the control responds to hovering over one from the set of enumerated data fields by enabling display of a graphical representation of selected data field values in the flexible-data column.
5. The method of claim 1 , wherein generating data for display further includes two or more flexible-data columns visible with the fixed-data columns on a single display page.
6. A system that generates data for display by a user system, comprising:
a processor, memory coupled to the processor, and program instructions loaded into the memory that, when executed on the processor, make the system capable of:
receiving a request for a report from a data source;
generating data for display assembled from the data source responsive to the received request, wherein
the data for display in the report includes a plurality of fixed-data columns retrieved from the data source, at least one flexible-data column, and a control for the flexible-data column retrieved from the data source,
the fixed data columns are part of the report and data fields of the fixed data columns are not user customizable, and
the flexible-data column is user customizable by using the control to select one from a set of enumerated data fields that can alternatively be displayed in the flexible-data column, including at least two data fields having distinct data formats, including a textual format and a graphical format; wherein each of the data fields in the set of enumerated data fields corresponds to a different characteristic of an object represented by a row of the report;
responsive to selection of one of the enumerated data fields of a distinct data format, causing retrieval of data corresponding to a characteristic of the distinct data format specific to each row of the report and display of the retrieved characteristic in the flexible-data column for each row; and
sending the generated data for display to the user system.
7. The system of claim 6 , wherein generating data for display further includes:
the data for display modifies a data display format of the flexible-data column responsive to a data format of the selected data field.
8. The system of claim 6 , wherein the control responds to hovering over one from the set of enumerated data fields by enabling display of selected data field values in the flexible-data column.
9. The system of claim 6 , wherein the control responds to hovering over one from the set of enumerated data fields by enabling display of a graphical representation of selected data field values in the flexible-data column.
10. The system of claim 6 , wherein generating data for display further includes two or more flexible-data columns visible with the fixed-data columns on a single display page.
11. A method of accessing data for display by a user system, comprising:
transmitting a request for a report from a data source;
receiving, in response to the request, data for display assembled from the data source, wherein
the data for display in the report includes a plurality of fixed-data columns retrieved from the data source, at least one flexible-data column, and a control for the flexible-data column retrieved from the data source,
the fixed data columns are part of the report and are not user customizable, and
the flexible-data column is user customizable by using the control to select one from a set of enumerated data fields that can alternatively be displayed in the flexible-data column, including at least two data fields having distinct data formats, including a textual format and a graphical format; wherein each of the data fields in the set of enumerated data fields corresponds to a different characteristic of an object represented by a row of the report; and
receiving data representing a user selection of one of the enumerated data fields using the control;
responsive to selection of one of the enumerated data fields of a distinct data format, accessing data corresponding to a characteristic of the distinct data format specific to each row of the report; and
using the accessed data to cause a user system to render a graphical display of the characteristic in the flexible-data column for each row.
12. The method of claim 11 , wherein the data for display modifies a data display format of the flexible-data column responsive to a data format of the selected data field.
13. The method of claim 11 , wherein the control responds to hovering over one from the set of enumerated data fields by enabling display of selected data field values in the flexible-data column.
14. The method of claim 11 , wherein the control responds to hovering over one from the set of enumerated data fields by enabling display of a graphical representation of selected data field values in the flexible-data column.
15. The method of claim 11 , wherein generating data for display further includes two or more flexible-data columns visible with the fixed-data columns on a single display page.
16. A non-transitory computer readable media storing program instructions that, when executed on a processor of a user system, make the user system capable of:
transmitting a request for a report;
receiving, in response to the request, data for display assembled from a data source, wherein
the data for display in the report includes a plurality of fixed-data columns, at least one flexible-data column, and a control for the flexible-data column,
the fixed data columns are part of the report and are not user customizable, and
the flexible-data column is user customizable by using the control to select one from a set of enumerated data fields that can alternatively be displayed in the flexible-data column, including at least two data fields having distinct data formats, including a textual format and a graphical format; wherein each of the data fields in the set of enumerated data fields corresponds to a different characteristic of an object represented by a row of the report; and
receiving data representing a user selection of one of the enumerated data fields using the control;
responsive to selection of one of the enumerated data fields of a distinct data format, accessing data corresponding to a characteristic of the distinct data format specific to each row of the report; and
using the accessed data to cause a user system to render a graphical display of the characteristic in the flexible-data column for each row.
17. The non-transitory computer readable media of claim 16 , wherein the data for display modifies a data display format of the flexible-data column responsive to a data format of the selected data field.
18. The non-transitory computer readable media of claim 16 , wherein the control responds to hovering over one from the set of enumerated data fields by enabling display of selected data field values in the flexible-data column.
19. The non-transitory computer readable media of claim 16 , wherein the control responds to hovering over one from the set of enumerated data fields by enabling display of a graphical representation of selected data field values in the flexible-data column.
20. The non-transitory computer readable media of claim 16 , wherein generating data for display further includes two or more flexible-data columns visible with the fixed-data columns on a single display page.
21. The method of claim 5 , wherein at least one fixed-data column is visible between the two or more flexible-data columns visible on a single display page.
22. The method of claim 1 , wherein the control is positioned proximate to a heading of the flexible-data column.
23. The method of claim 1 , further including sorting the displayed content of the flexible-data column.
24. The method of claim 23 , wherein sorting includes arranging textual format data according to alphabetical or reverse alphabetical order.
25. The method of claim 1 , further including changing appearance of data in the flexible-data column when the flexible-data column is selected.
26. The method of claim 1 , wherein at least two of the enumerated data fields are not computationally related to one another.