|
<< Click to Display Table of Contents >> Navigation: General Functions > Reporting > Designer > Designer Step 2 - SQL |
This step allows defining the SQL SELECT statement that will be used to query the database for the data that will be used for the report. All report types require an associated SQL statement.
The following settings are available:
SQL |
Choose an existing existing SQL statement or choose to -Add New-. |
Description |
This is a descriptive name for the SQL statement. NOTE: For CSV type reports that require a corresponding Export job, the words "EXPORT ONLY: " will be inserted by the wizard. Those words should be retained as the export job will be visible to end users. |
SQL (actual statement) |
This is the actual SQL statement. The statement supports tags. It should be tested in Microsoft's Query Analyzer (or similar utility) before being entered here. |
NOTE: Only SELECT statements are allowed. Any other SQL statement will result in an error and the statement will not be saved.
Changes are saved automatically when moving between wizard steps.