Steps to insert an existing prompt in a Freeform SQL statement

You can select an existing prompt to include in the SQL statement for your Freeform SQL report. As with new prompts, only value prompts and attribute element list prompts can be used for Freeform SQL reports.

To insert a prompt in a Freeform SQL statement

1. Access the Freeform SQL Editor. (How?)

2. Select a prompt in Object Browser pane and drag and drop it into the SQL statement pane where you want the prompt-generated SQL to be placed.

The syntax around a prompt added to your Freeform SQL report depends on the type of prompt you include and where it is included in the SQL statement. While it is more common to modify the syntax around a prompt after the prompt has been inserted in the SQL statement, it is important to know these standards prior to adding the prompt. For more information on correct syntax with prompts, see How prompts are included within SQL statements.

Related Topics

• Adding a new prompt to the SQL statement

• Setting prompt-dependent SQL for optional prompts

• Saving a prompted report