Report windows
Entry window
The
window is used to create a new report.The window is opened by the
command from the directory context menu.The window contains the panels Filter, Query, , Print formats, Functions, Clipboard, Report information and .
The Properties panel of the entry window is used to enter main attributes of the report.
Properties panel fields:
-
Report group — name of the group that the report belongs to. By default displays the name of the group selected in the report groups window. Selection is made in the Select report group.
-
Name — name of the report.
-
Description — brief description of the report.
-
На основании — report that was used to create the new report.
Clicking
will add the report to the directory and close the window. The menu displays the panel of the added report. Clicking will add the report to the directory without closing the window. Clicking will close the window without adding the report.The editor window allows one or more reports to be edited.
The window is opened by the Edit command from the context menu in the data grid when one or more reports are selected.
Editor window
If one report is selected, the Report editor window will open.
The fields and panels are the same as in the window.
Multiple editor window
When two or more reports are selected for editing, the multiple editor window will open. It has a panel displaying a list of the selected reports. The title in the window header is
.
When multiple reports are selected for editing, any changes that are saved will be applied to all of the selected reports.
Filter panel in the Report window
The Filter panel displays panels with the filter parameters specified for the filter steps in the Filter settings panel. These panels are populated with the parameters selected on completion of the filter steps.
Query panel in the Report window
The Query panel in the Report editor window contains a multi-line text field for entering the database query (written in Transact SQL) that returns the data used to generate the report.
The Data sets field in the Query panel is used to enter the names of data sets generated on execution of the SQL query. This is a required field.
Data set names are separated by semicolons. For each data set a separate panel with a data set model is added to the window.
The panel context menu contains the window.
command, which is used to test the SQL query. Test results are displayed in theIf the report is based on another report, the Data sets field and the query field are read-only.
Filter settings panel in the Report window
The Filter settings panel is used to select the filter parameters that are used to retrieve data for generating the report.
Data grid columns:
-
Name — name of the filter step.
-
Form class — class of the form to which the filter step corresponds.
-
Input parameters — parameters passed to the filter before moving on to the next step.
-
Output parameters — parameters received on completion of the filter step.
-
Caption — caption text displayed in the filter window.
-
Caption header — header displayed above the caption text in the filter window.
-
Header — filter parameter panel header.
-
Required — whether the filter step is required.
-
Index — order in which the filter steps are carried out.
-
Multi-select — whether multiple selection is allowed in the filter step.
-
Required selection — whether at least one option must be selected.
-
Empty values — whether empty values can be selected.
Context menu commands:
-
— add new filter step.
-
— edit selected filter step.
This command is only available when one filter step is selected.
-
— permanently delete selected filter steps.
-
— print out.
- — contains additional commands for
The entry window is used to add a new filter step to the Filter settings panel. The window is used for editing.
The permanent delete confirmation prompt is used when deleting filter steps from the Filter settings panel.
Print formats panel in the Report window
The Print panel is used to view and edit the report print layout.
Note
Each report uses only one print layout, but if several print layouts need to be generated simultaneously, the print layout can be designed on multiple pages.
Print panel fields:
-
Based on — name of the print layout that the current print layout is based on.
The panel contains a field for previewing the print layout. It has a context menu containing the
command, which opens the print layout editor.Functions panel in the Report window
The Functions panel is used for working with functions in the context menus of data grids in panels displayed in report viewer windows.
Functions in the context menus of data grids in panels displayed in report viewer windows allow the user to open viewer windows of operational reports and editor windows of directory and document list elements.
Functions panel fields:
-
Name — user-defined name of the function included in the context menu of the panel of the report viewer window.
-
Function — name of the function used by default.
-
Visibility condition — condition that defines when the function is visible in the context menu.
-
Accessibility condition — condition that defines when the function is accessible in the context menu.
-
Parameters — parameters passed to the function.
-
Required parameters — parameters that are required for execution of the function.
-
Index — order in which the functions are displayed in the context menu.
-
Data set — name of the panel whose context menu the function is included in.
Context menu commands:
-
— add a function to the report specification.
-
— edit selected functions.
-
— permanently delete selected functions from the report specification.
-
— print out.
- — contains additional commands for
Functions are added using the
window. The window is used for editing.The permanent delete confirmation prompt is used when deleting functions from the report specification.
Clipboard panel in the Report window
Information contained in data grids in data stream panels in the report viewer window can be copied to the clipboard and pasted into other document lists or directories. The Clipboard panel lists the types of objects that can be copied to the clipboard.
Only the objects specified in the Clipboard panel can be copied to the clipboard. If no copiable objects are specified in the panel, no objects can be copied from the report to the clipboard.
Clipboard panel fields:
-
Clipboard item type — type of copiable object.
-
Data set — data set from which data will be copied to the clipboard.
-
Index — indicates the order in which data are selected when copying information to the clipboard.
-
Field name lookup list — list of correlations between names of fields returned in data sets and names of fields in directories or document lists.
-
Accessibility condition — whether the field is accessible.
-
Help — additional information about the purpose and peculiarities of using the clipboard item type.
Context menu commands:
-
— add a new clipboard item type.
-
— edit selected clipboard item types.
-
— permanently delete selected clipboard item types from the report specification.
-
— print out.
- — contains additional commands for
Clipboard item types are added using the
window. The window is used for editing.The permanent delete confirmation prompt is used when deleting clipboard item types from the report specification.
Report information panel in the Report window
The Report information panel of the report entry window is used to enter arbitrary information about the report.
Print from software modules panel in the Report window
The Print from software modules panel is used to manage the list of software modules from which the report can be printed.
Data grid columns:
-
Report — name of the report.
-
Software module — name of the software module from which the report can be printed.
Context menu commands:
-
— add a software module to the list.
-
— edit selected software modules.
-
— permanently delete selected software modules from the list.
-
— print out.
- — contains additional commands for
Software modules are added using the
window. The and windows are used for editing.The permanent delete confirmation prompt is used when deleting software modules.