Utilizing database tables for dashboard management

A computer program product comprising:

• a computer-readable storage device;
• and
• a computer-readable program code stored in the computer-readable storage device, the computer readable program code containing instructions executable by a processor of a computer system to implement a method to populate a customized pull down menu with table driven sort options in a graphical user interface for displaying a data report, the computer program product comprising:
• building a table of sortable fields for a dashboard report;
• displaying in said dashboard report filters in said table that apply to said sortable fields;
• receiving from a user a selection of at least one sortable field from said sortable fields from a pull down menu;
• setting at least one sort option for inclusion in the dashboard report, said at least one set sort option defining a sort order for an element of said data report;
• modifying a generated SQL statement to sort said element according to said at least one set sort option;
• and
• sorting said element according to a modified SQL statement.

A computer system, comprising:

• a processor;
• a memory coupled to said processor;
• and
• a computer readable storage device coupled to the processor, the storage device containing instructions executable by the processor via the memory to implement a method to populate a customized pull down menu with table driven sort options in a graphical user interface for displaying a data report, the computer system comprising the steps of:
• building a table of sortable fields for a dashboard report;
• displaying in said dashboard report filters in said table that apply to said sortable fields;
• receiving from a user a selection of at least one sortable field from said sortable fields from a pull down menu;
• setting at least one sort option for inclusion in the dashboard report, said at least one set sort option defining a sort order for an element of said data report;
• modifying a generated SQL to sort said element according to said at least one set sort option;
• and
• sorting said element according to a modified SQL statement.