Switch to: V10V9V8V7V6V5

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.

Create Query Dialog - Query

  • 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.

Create Query Dialog - Parameters

  • 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.

Test

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

Create Query Dialog - Test