Development of Quick Reports¶
The most simple Quick Reports are the SQL Statements. With them users can design data queries that will help analyze data by simply showing it listed in a table. A user with the permission set FND_QUICK_REPORTS will be able to design these reports using SQL syntax and publish them to groups of users. An SQL Statement report can be executed from the Quick Report form or from a option in the navigator. For information on how to develop SQL Statement Quick Reports please see the Quick Reports Development Guide.
In order to support a simplified set of reports which are limited in functionality but on the other side very simple to create, the concept of Quick Report's may be used.
Quick Report's are simply a SELECT statement, that is stored in the database, and which can be accessed by the end user. The result may be browsed in a special table window, viewed using 'View Report' option, exported to Excel format.
The development of the SELECT statement may be performed with any SQL-Editing Tool, and then packaged as a Quick Report. This statement should not contain any tables, since the end-users do not have access to tables.