Dynamically Generating a Plurality of Interfaces Using Structure Control Files

A computer system comprising:

• a) a processor;
• b) network communications with a computerized database having a plurality of database tables, with each database table having a plurality of database fields;
• and
• c) programming instructions stored on a machine-readable memory device, the programming instructions executed by the processor to perform the following instructions:
• i) receive user instructions defining report elements for a report that uses data on the computerized database;
• ii) based on the user instructions, generate and store a main file that is structured into separate elements using document tags, the main file comprising:
• (1) a plurality of table elements, each table element defining a structure for a particular table in the computerized database,
• (2) a plurality of field elements for each table element, each field element defining field parameters for fields in the particular table, the field parameters comprising a datatype attribute and a GUI control attribute;
• iii) generate and store a mapper file that is structured into separate elements using document tags and that is separate from the main file, the mapper file comprising a plurality of join elements identifying join operations between the database tables for a particular view of the data in the computerized database;
• iv) use the main file and the mapper file to submit data queries to the computerized database;
• v) receive responsive data from the computerized database in response to the data queries;
• and
• vi) use the datatype attribute and the GUI control attribute found the field elements of the main file to format the responsive data within a graphical user interface.

A method comprising:

• a) receiving user instructions defining report elements for a report that uses data on a computerized database, the computerized database having a plurality of database tables, with each database table having a plurality of database fields;
• b) based on the user instructions, generating and storing a main file that is structured into separate elements using document tags, the main file comprising:
• i) a plurality of table elements, each table element defining a structure for a particular table in the computerized database,
• ii) a plurality of field elements for each table element, each field element defining field parameters for fields in the particular table, the field parameters comprising a datatype attribute and a GUI control attribute;
• c) generating and storing a mapper file that is structured into separate elements using document tags and that is separate from the main file, the mapper file comprising a plurality of join elements identifying join operations between the database tables;
• d) submitting data queries to the computerized database using the main file and the mapper file;
• e) receiving responsive data from the computerized database in response to the data queries;
• f) using the datatype attribute and the GUI control attribute found the field elements of the main file to format the responsive data within a graphical user interface;
• and
• g) receiving data input via the GUI control attributes through the graphical user interface.