Create Query Dialog Help

Using this dialog you can create a source query for the report. There are three tab-panels which help you to design a query: Query, Parameters and Test.

On this panel, you can define the basic query properties.

• Name – The name of the report.
• Datasourse – The drop-down list of report databases.
• Create New Datasource... – Opens the dialog to create new datasource for the report.
• Query Text – The text of the query.

• Insert Parameter… – Shows the dialog with the list of query parameters. You can select one of them to insert $P(param_name) macro into the query text. For some parameter types (String, Date, DateTime and Choice) the values are automatically enclosed in quotes and escaped.
• Insert Placeholder… – Shows the dialog with the list of query parameters. You can select one of them to insert $P!(param_name) macro into the query text. Unlike the $P macro, values are not quoted and pasted as-is.

On this panel you can create custom parameters for the query.

• Name – The name of the parameter.
• Default Value – The default value of the parameter.
• Description – The comment for the parameter.

• Add – Adds a new parameter.
• Delete – Deletes the selected parameter.

On this panel you can see a result of query execution.