We want to create a report that lists all employees as grouped in their respective departments.
Select Firstname, Lastname, Departmentname
from person join Department
on person.uid_Department = department.uid_Department
where Department.XObjectKey = @UIDDepartment
Figure 38: Specifying the Grouping Condition
Figure 39: Creating a Group
Figure 40: Specify the Data Source
Figure 41: Organizing Control Elements on a Report Form
Figure 42: Report Preview
A report can contain several elements which require translating in order to display the report in more than one language:
Translate database columns with the Language Editor in the Designer.
The report's display name used when a report is created as ReportAlias. The display name is entered in the report properties dialog. Translate the given text using the button.
Translate the text elements directly in the Report Editor with the Globalization Editor.
To translate all text elements in a report
This opens the report form in the Report Designer.
- OR -
|
NOTE: You can only start the Globalization Editor from the Report Designer’s properties view if you have selected Professional. You can change the configuration type later in the edit view using the context menu in the property view. |
This means the report is generated in the current language.
To translate single captions
This opens the report form in the Report Designer.
In order to present a report in a One Identity Manager administration tool, such as Manager, you need to link in the report as a custom interface form. Create the interface form in the program Designer.
To create a user interface form
Select Form | Insert.
Take the following cases into account:
This form definition is configured for displaying in the graphical user interface and in web applications. You only need to set up one interface form for this. Which form template will be used to display the interface form is decided dynamically, depending on usage.
Syntax:
<DialogSheetDefinition FormatVersion="1.0">
<SpecialSheetData>Report name|Parameter1=value1|Parameter2=value2 ..
...
</SpecialSheetData>
</DialogSheetDefinition>
Example:
<DialogSheetDefinition FormatVersion="1.0">
<SpecialSheetData>CCC_Employee_by_Department|UIDDepartment=%UID_Department%</SpecialSheetData>
</DialogSheetDefinition>
You can create customer-specific processes to control the creation of reports and perform the export on a cyclical or event-controlled basis.
You can use the ReportComponent process component to create reports and export them to different file formats. The following formats are supported: HTML, PDF, RTF, TEXT, XLS, TIFF, XML, CSV, XPS, DOCX,and XLSX.
To exports reports in CSV format, you can also use the ScriptComponent process component with the CSVExport or CSVExportSingle process functions.
|
NOTE: Use the default report server as executing server in the processes. |
© 2021 One Identity LLC. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy