Use database query logging in the Report Editor to look for errors and to optimize the report during the design phase. The execution time and the command that was run are recorded.
|Starts logging database queries.|
|Stops database query logging.|
|Copies recorded data to the clipboard.|
|Save logged data in a file.|
|Deletes the recorded data.|
|Displays the recorded data in an editor.|
Create and edit reports with the Report Editor program. Reports are stored in the database table DialogReport. The following steps are required to create a report:
Predefined reports supplied with the One Identity Manager by default, automatically customized during schema installation. If you need to make changes to a default report:
When you add or copy a report, the property dialog box opens first, which you use to enter the general data for the report, the data source required and an parameters for the report definition. Then a new report form is created in the edit view with the Report Designer. This forms the basis of the report design. Using the Report Designer’s toolbar, you can place the controls you want on the report form.
NOTE: Use the online help from Stimulsoft StimulReport.Net (www.stimulsoft.com) as a basis for the report design.
To create a new report
To copy a report
This creates a new report and the property dialog box opens. The properties in the new report are take from the original.
To edit a report
This opens the report form in the Report Designer.
To edit the report properties with loading the report in the Report Designer
This opens the property dialog.
NOTE: After you have customized a report, you can mark it by setting change labels. Change labels are offered in the program "Database Transporter" as export criteria when a customer transport package is created.
To edit general report properties
|Name||Report name Label custom reports with the prefix "CCC_".|
Display name of the report. The display name is available when the report is created as ReportAlias and can, for example, be used to compose the title of the report or the file name when a report is exported to a web front-end. Translate the given text using the button.
The report display name can contain variables, permitted are system variables such as report parameters. The variables are passed using a percent character.
Name of report %variable%
|Description||Report description. Translate the given text using the button.|
|Filter criteria||Filter criteria for displaying the report in the web front-end.|
Basis table for the report.
|Category||Category for classifying reports. Permitted values are the categories "Common", "Mail" and "Attestation".|
|Preprocessor condition||Preprocessor conditions can be added to reports. In this case, a report is only available if the preprocessor condition is fulfilled.|
Enter additional company specific information. Enter display names, formats and templates for the input fields (by default Spare field no. 01 to spare field no. 10) with the Designer to meet your requirements.
|Extended properties||An extended property is the UID under which the report is stored in the database.|
For each report you need to create a data source from which to read the report data to be displayed. Normally one data source is sufficient for one report. However, you can define several data sources for each report.
To edit a data source
- OR -
This creates a new data source.
To delete a data source
You can test the results while processing a data source.
To test a data query
The result of a data source is shown in a separate dialog.
NOTE: When a data query is copied to the clipboard, a database query is generated in SQL syntax that you can run on the database with an appropriate query tool. To copy the data query, use the button next to Query module.