SQL Statements

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 RMB option in the navigator. For information on how to develop SQL Statement Quick Reports please see the Quick Reports Development Guide.

Often, the user then wants to copy the result in to an Excel Document using the Output Channels functionality. However, the Output Channels has not been designed for exporting large amounts of data, so this not a suitable process when more than 1000 rows are to be exported. In such cases you are recommended to use the "Export to Excel" option instead. This option is available as an RMB context menu on most forms where you access Quick Reports as well as from the navigator itself. You can read more about this functionality in the End-User documentation.