Table of Contents
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.
Query
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.
Parameters
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.