Chat now with support
Chat with Support

Identity Manager 9.2.1 - Configuration Guide

About this guide One Identity Manager software architecture Customizing the One Identity Manager default configuration Customizing the One Identity Manager base configuration One Identity Manager schema basics
Overview of the One Identity Manager schema Table types and default columns in the One Identity Manager data model Notes on editing table definitions and column definitions Table definitions Column definitions Table relations Dynamic foreign key Supporting file groups
Editing the user interface
Object definitions for the user interface User interface navigation Forms for the user interface Statistics in One Identity Manager Extending the Launchpad Task definitions for the user interface Applications for configuring the user interface Icons and images for configuring the user interface Using predefined database queries
Localization in One Identity Manager Process orchestration in One Identity Manager
Mapping processes in One Identity Manager Setting up Job servers
The One Identity Manager Service functionality Tracking changes with process monitoring Conditional compilation using preprocessor conditions Scripts in One Identity Manager
Visual Basic .NET scripts usage Notes on message output Notes on using date values Tips for using PowerShell scripts Using dollar ($) notation Using base objects Calling functions Pre-scripts for use in processes and process steps Using session services Using #LD notation Script library Support for processing scripts in the Script Editor Creating and editing scripts in the Script Editor Copying scripts in the Script Editor Testing scripts in the Script Editor Testing script compilation in the Script Editor Overriding scripts Permissions for running scripts Editing and testing script code with the System Debugger Extended debugging in the Object Browser
One Identity Manager query language Reports in One Identity Manager Adding custom tables or columns to the One Identity Manager schema Web service integration One Identity Manager as SCIM 2.0 service provider Processing DBQueue tasks One Identity Manager Service configuration files

Using virtual data sources

You can use virtual data sources when you want to use a data source more than once within a report, but with other limitations or sorted differently.

To create a virtual data source

  1. In the Report Editor, open the report.

  2. Select the Report > New virtual data source menu item.

    Opens a dialog window showing all existing data sources for the report.

  3. Configure the properties for the virtual data source.

Related topics

Editing the report form

You can create and edit reports in the edit view of the Report Editor. The Report Designer from the company Stimulsoft is integrated into the edit view. You can find accurate descriptions and the functionality of individual components in the Stimulsoft online help (www.stimulsoft.com).

NOTE: When you start the Report Editor for the first time, you can select the configuration type (basic, default or professional) for the report. The configuration type determines the range of properties displayed when editing a report. You can change the configuration type later in the edit view using the context menu in the property view.

The Report Designer's toolbar is extended by the following functions:

Table 165: Extensions to Stimulsoft Reports.Ultimate Report Designer toolbar
Icon Meaning

Imports a reports (XML format).

Export a report (XML format).

Globalization editor. Opens the Report Designer globalization editor.

Opens the Translate texts dialog.

Related topics

Adding data fields to report forms

You can find accurate descriptions and the functionality of individual components in the Stimulsoft online help (www.stimulsoft.com).

Add the control elements for the data you want to appear in the report on the report form and link the them to the data source columns. After you have created the data sources, they are listed with all the columns used in the Report Designer’s dictionary under Quest. The report parameters are available as variables under Quest.

To insert data boxes into the report form

  1. Select the column you want to add to the report in the Dictionary tab.

  2. Position the column on the report form using "drag and drop".

    This creates a new control element on the report form which includes some predefined variables.

    TIP: You can add other control elements as necessary with the Report Designer tool palette.

  3. The Report Designer properties window (Properties) allows you to customize individual control elements.

  4. Use Preview to view the report during editing. The preview takes some sample parameter values to determine the data for the preview display.

Related topics

Tips for entering dates in reports

If no date is given, the date 12/30/1899 is used internally. Take this into account when values are compared, for example, when used in reports.

To display a string other than the internal date 12/30/1899, you have the following options:

  • For data sources in the SQL query module, change the date conversion in the data source.

    Example:

    select ISNULL(convert(varchar, Person.ExitDate, 121), '-') as date_substituted

  • Change the expression for displaying the date columns when you create the report form.

    Example:

    {IIF(Person.ExitDate.ToString() = "12/30/1899 12:00:00 AM","-",Person.ExitDate)}

  • Define a condition for displaying the date columns when you create the report form.

    In the Report Designer, add conditions to toolbar using the icon.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating