Patent ID: 7840600

Claim:
A reporting system with a dynamically created user interface for interactively creating, customizing, and executing reports over the Internet, comprising: a network interface configured to connect to a user through a web browser and to a database comprising one of a plurality of database types; and a processor coupled to the network interface, wherein the processor is configured to execute computer-executable instructions configured to: connect to the database over the Internet responsive to a connection string supplied by the user; enforce existing application level security for the user based upon the application level security in the connection string, wherein the application level security comprises a dynamic security model wherein changes to security levels are incorporated in previously saved reports; retrieve data sources from the database; present a dynamically created user interface to the user, wherein the user interface comprises capabilities responsive the one of a plurality of database type thereby preventing the user from designing a custom report which the database cannot execute, and wherein the capabilities comprise fields, functions, descriptions, formats, filters, operators, and combinations thereof; receive input from the user through the user interface; and generate the custom report responsive to the received input and the retrieved data sources, wherein the custom report is generated without requiring additional configuration items comprising any of catalogs, models or secondary schemas.