© Tillypad, 2008-2015
The Query panel in the report editor window is used to enter a query text in the Transact SQL language. This query gathers the data required to generate reports.
The Query panel displays the Data sets field, which contains the names of the data sets received from the SQL query. This is a required field.
The names of the data sets are listed with semicolons between them. For each of these data sets, the window displays a separate panel with a data set model.
The panel contains a multiline text field with the text of the query. The context menu of the field contains the following commands:
– runs the query.
– undoes changes made to the query text.
This command is available if the query text contains unsaved changes.
– cuts the selection to the clipboard.
– copies the selection to the clipboard.
– pastes the selection from the clipboard to the specified location.
– deletes the selection.
– selects the entire text.
(Ctrl+F) – contextual search and replacement.
If the report is created based on another report (i.e. is inherited from an original report), the Data sets field and the query text become read-only.
